| problem with VB6, ODBC, Access, ORACLE 9i, UNIX [message #350980] |
Sun, 28 September 2008 13:29  |
OlafCologne
Messages: 11
Registered: September 2008
Location: Cologne
|
Junior Member |
|
|
We have an application, which under NT without error with two
Databases works. The database can be accessed from VB6 on a
ACCESS.MDB (Acces 97 or Access 2003, both testet) via an ODBC driver.
The two databases are identical, a database and productive
a test database.
The application is now under WIN XP (SP3) run.
With a database always breaks the connection after starting 30s.
Regardless of whether activities are true or not. The other database working correctly. There was also a PC equipped with the same result. There were several drivers tried.
ORACLE Driver 9.02.00.8 and also the current MS ODBC driver and many other versions.
All settings in the registry, etc. to the respective
Databases, to the name, identical. I have changed all timeout parameters - no effect. On the server are also SQLNet.ora and Listener.ora identical.
What can be the cause?
Thanks
ODBC SQL.log
Error by Oracle ODBC Oracle Driver
exe_8_0_0 cc8-fc4 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 07CC3530
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)
exe_8_0_0 cc8-fc4 ENTER SQLExecDirectW
HSTMT 07CC3530
WCHAR * 0x51C416C0 [ -3] "SELECT "LVSOWN"."SYSTEM_PARA"."SYS_ID" FROM "LVSOWN"."SYSTEM_PARA" WHERE (("SYS_TYP" = 40 ) AND ("SYS_NAME" = 'USER_TIMEOUT' ) ) \ 0"
SDWORD -3
exe_8_0_0 cc8-fc4 EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 07CC3530
WCHAR * 0x51C416C0 [ -3] "SELECT "LVSOWN"."SYSTEM_PARA"."SYS_ID" FROM "LVSOWN"."SYSTEM_PARA" WHERE (("SYS_TYP" = 40 ) AND ("SYS_NAME" = 'USER_TIMEOUT' ) ) \ 0"
SDWORD -3
DIAG [S1000] [Oracle][ODBC][Ora]ORA-03114: Nicht mit ORACLE verbunden
(3114)
Error by Microsoft ODBC Oracle Driver
exe_8_0_0 b2c-714 ENTER SQLAllocStmt
HDBC 07CC1830
HSTMT * 10F418A4
exe_8_0_0 b2c-714 EXIT SQLAllocStmt with return code -1 (SQL_ERROR)
HDBC 07CC1830
HSTMT * 10F418A4
DIAG [08S01] [Microsoft][ODBC driver for Oracle][Oracle]ORA-03114: Nicht mit ORACLE verbunden (3114)
exe_8_0_0 b2c-714 ENTER SQLErrorW
HENV 07CC1788
HDBC 07CC1830
HSTMT 00000000
WCHAR * 0x0012B910 (NYI)
SDWORD * 0x0012B95C
WCHAR * 0x02B3C220
SWORD 4095
SWORD * 0x0012B948
exe_8_0_0 b2c-714 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07CC1788
HDBC 07CC1830
HSTMT 00000000
WCHAR * 0x0012B910 (NYI)
SDWORD * 0x0012B95C (3114)
WCHAR * 0x02B3C220 [ 80] "[Microsoft][ODBC driver for Oracle][Oracle]ORA-03114: Nicht mit ORACLE verbunden"
SWORD 4095
SWORD * 0x0012B948 (80)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
