FirebirdSQL/firebird-odbc-driver

Cannot link tables using MS Access

jabrugger opened this issue · 4 comments

jabrugger commented

SQL.LOG
Using Firebird_ODBC_3.0.0.1_x64.exe release (dated 8/Dec/2023)

irodushka commented

Hi jabrugger!

Looking at your log:

SIPRES          10764-107dc	ENTER SQLExecDirectW 
		HSTMT               0x0000027FB10D21B0
		WCHAR *             0x00007FFF8EE587B0 [      -3] "SELECT Config, nValue FROM MSysConf\ 0"
		SDWORD                    -3

SIPRES          10764-107dc	EXIT  SQLExecDirectW  with return code -1 (SQL_ERROR)
		HSTMT               0x0000027FB10D21B0
		WCHAR *             0x00007FFF8EE587B0 [      -3] "SELECT Config, nValue FROM MSysConf\ 0"
		SDWORD                    -3

		DIAG [42S02] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
-SQL error code = -204
-Table unknown
-MSYSCONF
-At line 1, column 28 (-204) 
...
		WCHAR *             0x0000027FB6E42120 [     119] "[ODBC Firebird Driver][Firebird]Dynamic SQL Error\ a-SQL error code = -204\ a-Table unknown\ a-MSYSCONF\ a-At line 1, column 28"

Are you sure the table MSYSCONF exists in you DB?.. You see, it's not an ODBC driver error, it is forwarded from the Firebird SQL server.

Please check your MS Access project. If you think there is nothing wrong on your end, please tell me how I can reproduce it.

Regards
Yuri

irodushka commented

Aha, sorry, your are right, I've just reproduced it. Will investigate.

  • 👍1
irodushka commented

Hi
Just uploaded the patched driver to https://github.com/FirebirdSQL/firebird-odbc-driver/wiki
Seems it will work with MSAccess properly)
If you could spend some of your time testing it, I would greatly appreciate it.
Regards

jabrugger commented

It seems to be resolved. Thank you.