|
Thomas Write
Hi Ruben
Do you use the latest ODBC driver? If yes, please send me the MS driver manager trace then. Can you get the ODBC trace anyway (i.e. when no error occurs). It's weird that the trace file is empty since it is written syncronous. Regards Thomas ---------------------------------------------- Dr. Thomas K=F6tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org Dear Thomas
Thanks a lot for your quick response
I use the 7.3.00 ODBC drivers, is there a newer version? I manage to get a trace from the driver, first is a connection
to an instance that is not running, then is the trace of the
faliure:
pb70 10d-13f ENTER SQLSetConnectOption HDBC 02A01D10 UWORD 105 <SQL_OPT_TRACEFILE> SQLLEN 27416321 pb70
13e-14a ENTER SQLSetConnectOption
HDBC 02A01D10 UWORD 105 <SQL_OPT_TRACEFILE> SQLLEN 27416249 pb70
193-144 ENTER SQLSetConnectOption
HDBC 02A01878 UWORD 105 <SQL_OPT_TRACEFILE> SQLLEN 27416321 pb70
160-fa ENTER SQLSetConnectOption
HDBC 033B1238 UWORD 105 <SQL_OPT_TRACEFILE> SQLLEN 27414081 pb70
19c-156 ENTER SQLSetConnectOption
HDBC 02A01D10 UWORD 105 <SQL_OPT_TRACEFILE> SQLLEN 27416321 pb70
14f-156 ENTER SQLSetConnectOption
HDBC 02A01878 UWORD 105 <SQL_OPT_TRACEFILE> SQLLEN 27416321 pb70
132-e8 ENTER SQLAllocEnv
HENV * 10C8D6C4 pb70
132-e8 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x10C8D6C4 ( 0x02a01430) pb70
132-e8 ENTER SQLAllocConnect
HENV 02A01430 HDBC * 0012E298 pb70
132-e8 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 02A01430 HDBC * 0x0012E298 ( 0x02a014d8) pb70
132-e8 ENTER SQLDriverConnectW
HDBC 02A014D8 HWND 000D02AA WCHAR * 0x1F7D8B70 [ -3] "******\ 0" SWORD -3 WCHAR * 0x1F7D8B70 SWORD 8 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> pb70
132-e8 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 02A014D8 HWND 000D02AA WCHAR * 0x1F7D8B70 [ -3] "******\ 0" SWORD -3 WCHAR * 0x1F7D8B70 SWORD 8 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> DIAG [08001] [SAP AG][SQLOD32 DLL][SAP DB]Unable to connect to
data source;-709 CONNECT: (database not running). (-709)
pb70
132-e8 ENTER SQLErrorW
HENV 02A01430 HDBC 02A014D8 HSTMT 00000000 WCHAR * 0x0012E24C (NYI) SDWORD * 0x0012E294 WCHAR * 0x0012DE4C SWORD 512 SWORD * 0x0012E29C pb70
132-e8 EXIT SQLErrorW with return code 0
(SQL_SUCCESS)
HENV 02A01430 HDBC 02A014D8 HSTMT 00000000 WCHAR * 0x0012E24C (NYI) SDWORD * 0x0012E294 (-709) WCHAR * 0x0012DE4C [ 99] "[SAP AG][SQLOD32 DLL][SAP DB]Unable to connect to" SWORD 512 SWORD * 0x0012E29C (99) pb70
132-e8 ENTER SQLFreeEnv
HENV 02A01430 pb70
132-e8 EXIT SQLFreeEnv with return code -1
(SQL_ERROR)
HENV 02A01430 DIAG [S1010] [Microsoft][Administrador de controladores ODBC]
Error en la secuencia de la funci�n (0)
pb70
132-e8 ENTER SQLAllocEnv
HENV * 10C8D6C4 pb70
132-e8 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x10C8D6C4 ( 0x02a01f48) pb70
132-e8 ENTER SQLAllocConnect
HENV 02A01F48 HDBC * 0012DB08 pb70
132-e8 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 02A01F48 HDBC * 0x0012DB08 ( 0x02a01ff0) pb70
132-e8 ENTER SQLSetConnectOption
HDBC 02A01FF0 UWORD 104 <SQL_OPT_TRACE> SQLLEN 1 pb70
132-e8 EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
HDBC 02A01FF0 UWORD 104 <SQL_OPT_TRACE> SQLLEN 1 pb70
132-e8 ENTER SQLSetConnectOption
HDBC 02A01FF0 UWORD 105 <SQL_OPT_TRACEFILE> SQLLEN 27414081 I also have a trace from powerbuilder with the connection parameters
/*---------------------------------------------------*/
/* 18/04/02 16:08 */ /*---------------------------------------------------*/ (3250d80): DIALOG CONNECT TO TRACE ODBC: (3250d80): USERID= (3250d80): DBPARM=ConnectString='DSN=SAPTICKET;UID=DBA;PWD=DBA',ConnectOption='SQL_OPT_TRACE,SQL_OPT_TRACE_ON;SQL_OPT_TRACEFILE,m:\traceodbc.txt' |
