Hi all.
I have a DSN pointing to a remote (LAN) Firebird database.
I´ve linked tables in Access.
If I close Access and reopen the same database (ACCDB), I get an error
when I try to open a table.
Trace log contains (full log atached):
Farmadev 2788-2e4c EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 0x000000000036E7D0
HWND 0x00000000004B08E4
WCHAR * 0x000007FEDB7230D8 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x000007FEDB7230D8
SWORD -3
SWORD * 0x0000000000000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [08004] [ODBC Firebird Driver]Unable to complete network
request to host "xnet://Global\FIREBIRD". (-902)
Farmadev 2788-2e4c ENTER SQLErrorW
HENV 0x0000000011EF8280
HDBC 0x000000000036E7D0
HSTMT 0x0000000000000000
WCHAR * 0x0000000000279858
SDWORD * 0x0000000000279834
WCHAR * 0x000000000B6DE040
SWORD 4095
SWORD * 0x0000000000279830
Farmadev 2788-2e4c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x0000000011EF8280
HDBC 0x000000000036E7D0
HSTMT 0x0000000000000000
WCHAR * 0x0000000000279858 [ 5] "08004"
SDWORD * 0x0000000000279834 (-902)
WCHAR * 0x000000000B6DE040 [ 90] "[ODBC Firebird
Driver]Unable to complete network request to host "xnet://Global\FIREBIRD"."
SWORD 4095
SWORD * 0x0000000000279830 (90)
I have to update linked tables ("refresh") from the MS Access Linked
Table Manager ("select all", "Ok") to get it work.
Can I fix this issue someway? It´s an Access bug? FBODBC bug?
Thanks
--
Jorge Andrés Brugger
Departamento de Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103 / 406-3278
Correo electrónico: jbrug...@dasu.com.ar
Website: www.dasu.com.ar
“Un experto es una persona que ha cometido todos los errores que se pueden
cometer en un determinado campo.” (Niels Bohr)
--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.
Farmadev 2788-2e4c ENTER SQLAllocEnv
HENV * 0x0000000000279E38
Farmadev 2788-2e4c EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x0000000000279E38 ( 0x0000000011EF8280)
Farmadev 2788-2e4c ENTER SQLAllocConnect
HENV 0x0000000011EF8280
HDBC * 0x0000000000279938
Farmadev 2788-2e4c EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 0x0000000011EF8280
HDBC * 0x0000000000279938 ( 0x000000000036E7D0)
Farmadev 2788-2e4c ENTER SQLSetConnectOptionW
HDBC 0x000000000036E7D0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 20
Farmadev 2788-2e4c EXIT SQLSetConnectOptionW with return code 0
(SQL_SUCCESS)
HDBC 0x000000000036E7D0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 20
Farmadev 2788-2e4c ENTER SQLSetConnectAttrW
SQLHDBC 0x000000000036E7D0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
Farmadev 2788-2e4c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 0x000000000036E7D0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
Farmadev 2788-2e4c ENTER SQLDriverConnectW
HDBC 0x000000000036E7D0
HWND 0x00000000004B08E4
WCHAR * 0x000007FEDB7230D8 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x000007FEDB7230D8
SWORD -3
SWORD * 0x0000000000000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
Farmadev 2788-2e4c EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 0x000000000036E7D0
HWND 0x00000000004B08E4
WCHAR * 0x000007FEDB7230D8 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x000007FEDB7230D8
SWORD -3
SWORD * 0x0000000000000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [08004] [ODBC Firebird Driver]Unable to complete network
request to host "xnet://Global\FIREBIRD". (-902)
Farmadev 2788-2e4c ENTER SQLErrorW
HENV 0x0000000011EF8280
HDBC 0x000000000036E7D0
HSTMT 0x0000000000000000
WCHAR * 0x0000000000279858
SDWORD * 0x0000000000279834
WCHAR * 0x000000000B6DE040
SWORD 4095
SWORD * 0x0000000000279830
Farmadev 2788-2e4c EXIT SQLErrorW with return code 0
(SQL_SUCCESS)
HENV 0x0000000011EF8280
HDBC 0x000000000036E7D0
HSTMT 0x0000000000000000
WCHAR * 0x0000000000279858 [ 5] "08004"
SDWORD * 0x0000000000279834 (-902)
WCHAR * 0x000000000B6DE040 [ 90] "[ODBC
Firebird Driver]Unable to complete network request to host
"xnet://Global\FIREBIRD"."
SWORD 4095
SWORD * 0x0000000000279830 (90)
Farmadev 2788-2e4c ENTER SQLErrorW
HENV 0x0000000011EF8280
HDBC 0x000000000036E7D0
HSTMT 0x0000000000000000
WCHAR * 0x0000000000279858
SDWORD * 0x0000000000279834
WCHAR * 0x000000000B6DE10C
SWORD 3993
SWORD * 0x0000000000279830
Farmadev 2788-2e4c EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 0x0000000011EF8280
HDBC 0x000000000036E7D0
HSTMT 0x0000000000000000
WCHAR * 0x0000000000279858
SDWORD * 0x0000000000279834
WCHAR * 0x000000000B6DE10C
SWORD 3993
SWORD * 0x0000000000279830
Farmadev 2788-2e4c ENTER SQLFreeConnect
HDBC 0x000000000036E7D0
Farmadev 2788-2e4c EXIT SQLFreeConnect with return code 0
(SQL_SUCCESS)
HDBC 0x000000000036E7D0
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
