Cannot link tables using MS Access

[jabrugger]

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

[irodushka]

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]

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

[irodushka]

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]

It seems to be resolved. Thank you.