Hello,
We have found the problem :
it's when SQL tracing is activated in the ODBC driver configuration panel
(not the ODBC tracing)
Sorry for the inconvenience
Best regards
----- Original Message -----
From: Christian Bagard
To: ADSM: Dist Stor Manager
Sent: Tuesday, April 15, 2003 10:35 AM
Subject: Connect to TSM ODBC Driver with Regina and Rexx/SQL for ODBC no
longer possible
Hello,
We use Regina 2.2 for Win9x/NT/2k to interrogate a Tivoli Storage Manager
Server.
We interrogate TSM ODBC Driver with Rexx SQL for ODBC from Mark Hessling.
At first, all worked fine.
We were able to interrogate several servers without problem until friday.
And what happened friday, is a big mystere for us.
My colleague was testing our soft on a remote client TSM server.
There was an abend in the program but we cancel the session and it seemed
ordinary.
Thince this time we cannot any more "connect" to a TSM ODBC Driver.
TSM Message is ANR0568W which indicates that this is the client which
interrupts the session
This morning I try on the computer of an other colleague, and the soft works
????
And on a forth, it works also.
It looks like on the fisrt 2 computers something was changed in the way ODBC
dialogs with a TSM Driver.
But we look for which change during days ... and ???????
On the database which I cannot connect, I can do it with Excel (maybe it's
slower than "before" but I'm not sure)
I join 3 source of information :
File : SQL.LOG trace sql with ODBC Driver
File : ODBCADSMREADME.TXT Readme TSM ODBC Driver 5.1.5 (abstract)
File : ODBCADSM.TRC trace ODBC with ODBC Driver
Have you any idea about this ?
Do you know other people who use Rexx/SQL with TSM Database ?
I think this is more a Windows problem than a TSM one.
Thanks a lot for any idea.
Best greatings.
Christian Bagard
Tél : 04 42 93 08 13
email : c.bagard AT sos-restore DOT com
SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France
www.sos-restore.com
*******************************************************************************************
File : SQL.LOG trace sql with ODBC Driver
*******************************************************************************************
regina odbcfile 584-1dc ENTER SQLAllocEnv
HENV * 005286B4
regina odbcfile 584-1dc EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x005286B4 ( 0x009814f0)
regina odbcfile 584-1dc ENTER SQLAllocConnect
HENV 009814F0
HDBC * 00EA0C08
regina odbcfile 584-1dc EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 009814F0
HDBC * 0x00EA0C08 ( 0x00981598)
regina odbcfile 584-1dc ENTER SQLConnectW
HDBC 00981598
WCHAR * 0x009816A0 [ 7] "TSMODBC"
SWORD 7
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
regina odbcfile 584-1dc EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 00981598
WCHAR * 0x009816A0 [ 7] "TSMODBC"
SWORD 7
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
regina odbcfile 584-1dc ENTER SQLGetFunctions
HDBC 00981598
UWORD 72
UWORD * 0x0012F2D0
regina odbcfile 584-1dc EXIT SQLGetFunctions with return code 0
(SQL_SUCCESS)
HDBC 00981598
UWORD 72
UWORD * 0x0012F2D0 (1)
regina odbcfile 584-1dc ENTER SQLGetFunctions
HDBC 00981598
UWORD 63
UWORD * 0x0012F2D0
regina odbcfile 584-1dc EXIT SQLGetFunctions with return code 0
(SQL_SUCCESS)
HDBC 00981598
UWORD 63
UWORD * 0x0012F2D0 (1)
regina odbcfile 584-1dc ENTER SQLGetFunctions
HDBC 00981598
UWORD 50
UWORD * 0x0012F2D0
regina odbcfile 584-1dc EXIT SQLGetFunctions with return code 0
(SQL_SUCCESS)
HDBC 00981598
UWORD 50
UWORD * 0x0012F2D0 (1)
regina odbcfile 584-1dc ENTER SQLSetConnectOption
HDBC 00981598
UWORD 102 <SQL_AUTOCOMMIT>
SQLLEN 0
regina odbcfile 584-1dc EXIT SQLSetConnectOption with return code -1
(SQL_ERROR)
HDBC 00981598
UWORD 102 <SQL_AUTOCOMMIT>
SQLLEN 0
DIAG [S1C00] Optional feature not implemented. (3)
regina odbcfile 584-1dc ENTER SQLErrorW
HENV 00000000
HDBC 00981598
HSTMT 00000000
WCHAR * 0x0012F014 (NYI)
SDWORD * 0x0012F058
WCHAR * 0x0012EC14
SWORD 512
SWORD * 0x0012F068
regina odbcfile 584-1dc EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 00000000
HDBC 00981598
HSTMT 00000000
WCHAR * 0x0012F014 (NYI)
SDWORD * 0x0012F058
WCHAR * 0x0012EC14
SWORD 512
SWORD * 0x0012F068
regina odbcfile 584-1dc ENTER SQLFreeEnv
HENV 009814F0
regina odbcfile 584-1dc EXIT SQLFreeEnv with return code -1 (SQL_ERROR)
HENV 009814F0
DIAG [S1010] [Microsoft][Gestionnaire de pilotes ODBC] Erreur de séquence
de la fonction (0)
regina odbcfile 584-1dc ENTER SQLErrorW
HENV 009814F0
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012F49C (NYI)
SDWORD * 0x0012F4E0
WCHAR * 0x0012F09C
SWORD 512
SWORD * 0x0012F4F0
regina odbcfile 584-1dc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 009814F0
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012F49C (NYI)
SDWORD * 0x0012F4E0 (0)
WCHAR * 0x0012F09C [ 75] "[Microsoft][Gestionnaire de
pilotes O"
SWORD 512
SWORD * 0x0012F4F0 (75)
regina odbcfile 584-1dc ENTER SQLErrorW
HENV 009814F0
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012F49C (NYI)
SDWORD * 0x0012F4E0
WCHAR * 0x0012F09C
SWORD 512
SWORD * 0x0012F4F0
regina odbcfile 584-1dc EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 009814F0
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012F49C (NYI)
SDWORD * 0x0012F4E0
WCHAR * 0x0012F09C
SWORD 512
SWORD * 0x0012F4F0
*******************************************************************************************
File : ODBCADSMREADME.TXT Readme TSM ODBC Driver 5.1.5
*******************************************************************************************
Defects fixed in version 5.1.5:
[ NONE ]
Defects fixed in version 5.1.1:
- Fixed "Optional feature not implemented" problem when an application
calls SQLSetConnectAttr() to set the SQL_ATTR_AUTOCOMMIT attribute to
SQL_AUTOCOMMIT_ON.
Note that TSM does not support manual commits, so trying to set
SQL_ATTR_AUTOCOMMIT to SQL_AUTOCOMMIT_OFF will still get "Optional
feature not implemented".
Defects fixed in version 5.1.0:
- The TSM ODBC driver now handles the creation, modification, and use of
file DSNs correctly.
*******************************************************************************************
File : ODBCADSM.TRC trace ODBC with ODBC Driver
*****************************************************************************************
Mon Apr 14 11:35:55 2003 00000584 000001dc
DllMain.cpp( 218): --------------------------------- BEGIN
TRACE ---------------------------------
Mon Apr 14 11:35:55 2003 00000584 000001dc DllMain.cpp( 220):
Tivoli Storage Manager ODBC Driver
Mon Apr 14 11:35:55 2003 00000584 000001dc DllMain.cpp( 229):
Version 5.1.5.0
Mon Apr 14 11:35:55 2003 00000584 000001dc DllMain.cpp( 230):
Entering DllMain() - DLL_PROCESS_ATTACH.
Mon Apr 14 11:35:55 2003 00000584 000001dc DllMain.cpp( 289):
Exiting DllMain(), rc = 'true'.
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLAllocHandle.cpp( 207):
Entering SQLAllocHandle()
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLAllocHandle.cpp( 238):
HandleType = Environment (1)
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLAllocHandle.cpp( 240):
InputHandle = 0x00000000
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLAllocHandle.cpp( 242):
OutputHandle = 0x00981a44
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLAllocHandle.cpp( 296):
Entering tsmAllocHandleEnv()
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLAllocHandle.cpp( 298):
hEnv = 0x00981a44
......................-----------------------------
......................----------------------------
.....................-----------------------------
Mon Apr 14 11:35:55 2003 00000584 000001dc Common.cpp( 4974):
Exiting InitializeServerSession().
Mon Apr 14 11:35:55 2003 00000584 0000069c DllMain.cpp( 250):
Entering DllMain() - DLL_THREAD_ATTACH.
Mon Apr 14 11:35:55 2003 00000584 0000069c DllMain.cpp( 289):
Exiting DllMain(), rc = 'false'.
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLConnect.cpp( 297):
Session opened successfully.
Mon Apr 14 11:35:55 2003 00000584 000001dc SQLConnect.cpp( 310):
Server version = 5.1.6.3
Mon Apr 14 11:35:55 2003 00000584 000001dc Common.cpp( 4998):
Entering IsServerDownLevel().
Mon Apr 14 11:35:55 2003 00000584 000001dc Common.cpp( 5109):
......................-----------------------------
......................----------------------------
.....................-----------------------------
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLSetConnectAttr.cpp( 197):
Attribute = SQL_ATTR_AUTOCOMMIT
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 4527):
Entering tsmMapSqlState()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 4529):
stateStr = 0x015e77bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 4531):
stateCode = 99
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 4533):
odbcVer = 2
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 4535):
funcName = 'SQLSetConnectAttr'
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 4750):
Exiting tsmMapSqlState(), stateStr = 'S1C00'
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 567):
Entering tsmUnLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 569):
mutex = 0x000000bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 586):
Exiting tsmUnlockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLSetConnectAttr.cpp( 361):
Exiting SQLSetConnectAttr(), rc = -1
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 134):
Entering SQLGetDiagRec()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 164):
HandleType = Connection (2)
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 166):
Handle = 0x015e76d0
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 168):
RecNumber = 1
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 170):
SqlState = 0x0012d0bc
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 172):
NativeErrorPtr = 0x0012e95c
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 174):
MessageText = 0x00982ae8
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 176):
BufferLength = 2000
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 178):
TextLengthPtr = 0x0012d178
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 533):
Entering tsmLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 535):
mutex = 0x000000bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 552):
Exiting tsmLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 567):
Entering tsmUnLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 569):
mutex = 0x000000bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 586):
Exiting tsmUnlockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 367):
SQL state = 'S1C00'
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 369):
Error message = 'Optional feature not implemented.'
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 378):
Exiting SQLGetDiagRec(), rc = 0
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 134):
Entering SQLGetDiagRec()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 164):
HandleType = Connection (2)
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 166):
Handle = 0x015e76d0
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 168):
RecNumber = 2
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 170):
SqlState = 0x0012d0bc
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 172):
NativeErrorPtr = 0x0012e95c
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 174):
MessageText = 0x00982ae8
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 176):
BufferLength = 2000
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 178):
TextLengthPtr = 0x0012d178
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 533):
Entering tsmLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 535):
mutex = 0x000000bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 552):
Exiting tsmLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 274):
Exiting SQLGetDiagRec(), rc = 100
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 567):
Entering tsmUnLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 569):
mutex = 0x000000bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 586):
Exiting tsmUnlockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 134):
Entering SQLGetDiagRec()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 164):
HandleType = Connection (2)
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 166):
Handle = 0x015e76d0
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 168):
RecNumber = 1
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 170):
SqlState = 0x0012eb5c
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 172):
NativeErrorPtr = 0x0012f058
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 174):
MessageText = 0x00981b38
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 176):
BufferLength = 512
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 178):
TextLengthPtr = 0x0012f068
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 533):
Entering tsmLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 535):
mutex = 0x000000bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 552):
Exiting tsmLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc SQLGetDiagRec.cpp( 274):
Exiting SQLGetDiagRec(), rc = 100
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 567):
Entering tsmUnLockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 569):
mutex = 0x000000bc
Mon Apr 14 11:35:56 2003 00000584 000001dc Common.cpp( 586):
Exiting tsmUnlockMutex()
Mon Apr 14 11:35:56 2003 00000584 000001dc DllMain.cpp( 263):
Entering DllMain() - DLL_PROCESS_DETACH.
Mon Apr 14 11:35:56 2003 00000584 000001dc
DllMain.cpp( 266): ---------------------------------- END
TRACE ----------------------------------
|