AnsweredAssumed Answered

[RESOLVED] ODBC Unknown Error (16390) when querying FileMaker 6

Question asked by fxd on Nov 29, 2017
Latest reply on Nov 29, 2017 by beverly

EDIT:

I had more luck with ODBC Test tool from the Microsoft MDAC SDK 2.8 available from (Download Microsoft Data Access Components (MDAC) 2.8 Software Development Kit from Official Microsoft Download Center ), I also attached it. It gets installed under C:\Program Files (x86)\Microsoft Data Access SDK 2.8\

 

Use the 32bit tool with a 32bit ODBC driver for FileMaker 6, this is at C:\Program Files (x86)\Microsoft Data Access SDK 2.8\Tools\x86

 

The name is odbcte32.exe for the ANSI version, odbce32w.exe for Unicode.

 

Just remember to use backticks ` to quote table/column names with spaces in them.

 

ODBC Test (ANSI).png

See https://www.simba.com/blog/testing-driver-odbc-test/ for some usage examples.

 

Or use RowsetViewer.exe (in the same folder):

Microsoft OLE DB RowsetViewer.jpg

 

 

I'm trying to integrate/migrate data from a FileMaker 6 runtime application.

I installed the legacy FileMaker Pro Version 6 Trial (http://fmdl.filemaker.com/TBUB/fm/6/Win/fm_60v1_win_trial.zip) from https://support.filemaker.com/s/answerview?language=en_US&anum=750

 

 

I configured a 32bit User DSN on a Windows 10 Build 1703 machine, enabled ODBC tracing and opened a connection without user or password using ODBC Query Tool (ODBC Query Tool download | SourceForge.net ).

 

After opening a .PSR File with FileMaker 6 and enabling sharing, I can access the catalog (the table, columns and their types).

 

(right-click and open image in new tab to enlarge)

GEH-TDB - ODBC query tool v1.39 by Jaime de los Hoyos M..png

 

However, a simple "SELECT * FROM [ISO country codes.PSR] LIMIT 100;" results in an Error 16390.

 

I cannot find any reference to this error number; can anyone point me in the right direction?

 

Following is the relevant portion of the ODBC trace with the error in red:

 

ODBC_Qry        4a08-3f88 ENTER SQLExecDirect

HSTMT               0x00BAC5E0

UCHAR *             0x041C7954 [      -3] "SELECT * FROM [ISO country codes.PSR] LIMIT 100\ 0"

SDWORD                    -3

 

 

ODBC_Qry        4a08-3f88 EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)

HSTMT               0x00BAC5E0

UCHAR *             0x041C7954 [      -3] "SELECT * FROM [ISO country codes.PSR] LIMIT 100\ 0"

SDWORD                    -3

 

 

DIAG [HY000] [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Unknown error (16390)

 

 

ODBC_Qry        4a08-3f88 ENTER SQLGetDiagRecW

SQLSMALLINT                  3 <SQL_HANDLE_STMT>

SQLHANDLE           0x00BAC5E0

SQLSMALLINT                  1

SQLWCHAR *          0x041C764C

SQLINTEGER *        0x041C788C

SQLWCHAR *          0x00BAC950

SQLSMALLINT                260

SQLSMALLINT *       0x041C7894

 

 

ODBC_Qry        4a08-3f88 EXIT  SQLGetDiagRecW  with return code 0 (SQL_SUCCESS)

SQLSMALLINT                  3 <SQL_HANDLE_STMT>

SQLHANDLE           0x00BAC5E0

SQLSMALLINT                  1

SQLWCHAR *          0x041C764C [       5] "HY000"

SQLINTEGER *        0x041C788C (16390)

SQLWCHAR *          0x00BAC950 [      66] "[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Unknown error"

SQLSMALLINT                260

SQLSMALLINT *       0x041C7894 (66)

Attachments

Outcomes