Connect to TSM ODBC Driver with Regina and Rexx/SQL for ODBC no longer possible 
Author Message
 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
????
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
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 more a Windows problem than a TSM one.

Thanks a lot for any idea.

Best greatings.

Christian Bagard
Tl : 04 42 93 08 13

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 squence
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 (see attached file,
here after an extract or the end of the file)
****************************************************************************
***************

   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:09 2003 000001dc 00000584
              DllMain.cpp(  218): --------------------------------- BEGIN
TRACE ---------------------------------
Mon Apr 14 11:35:09 2003 000001dc 00000584               DllMain.cpp(  220):
Tivoli Storage Manager ODBC Driver
Mon Apr 14 11:35:09 2003 000001dc 00000584               DllMain.cpp(  229):
Version 5.1.5.0

Mon Apr 14 11:35:09 2003 000001dc 00000584               DllMain.cpp(  230):
Entering DllMain() - DLL_PROCESS_ATTACH.
Mon Apr 14 11:35:09 2003 000001dc 00000584               DllMain.cpp(  289):
Exiting DllMain(), rc = 'true'.
Mon Apr 14 11:35:22 2003 000001dc 00000584                 Setup.cpp( 1439):
Entering ConfigDlgProc() - IDOK.
Mon Apr 14 11:35:22 2003 000001dc 00000584               DllMain.cpp(  263):
Entering DllMain() - DLL_PROCESS_DETACH.
Mon Apr 14 11:35:22 2003 000001dc 00000584
              DllMain.cpp(  266): ---------------------------------- END
TRACE ----------------------------------

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        
...

read more »



Fri, 30 Sep 2005 23:56:16 GMT  
 Connect to TSM ODBC Driver with Regina and Rexx/SQL for ODBC no longer possible
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



Quote:
> 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
> ????
> 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
> 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 more a Windows problem than a TSM one.

> Thanks a lot for any idea.

> Best greatings.

> Christian Bagard
> Tl : 04 42 93 08 13

> SOS-Restore - 32 cours Mirabeau - 13100 Aix-en-Provence - France
> www.sos-restore.com

****************************************************************************
Quote:
> ***************
> File : SQL.LOG trace sql with ODBC Driver

****************************************************************************

- Show quoted text -

Quote:
> ***************

> 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
squence
> 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

****************************************************************************
Quote:
> ***************
> File : ODBCADSMREADME.TXT Readme TSM ODBC Driver 5.1.5 (see attached file,
> here after an extract or the end of the file)

****************************************************************************

- Show quoted text -

Quote:
> ***************

>    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.

****************************************************************************
Quote:
> ***************
> File : ODBCADSM.TRC trace ODBC with ODBC Driver

****************************************************************************

- Show quoted text -

Quote:
> ***************

> Mon Apr 14 11:35:09 2003 000001dc 00000584
>               DllMain.cpp(  218): --------------------------------- BEGIN
> TRACE ---------------------------------
> Mon Apr 14 11:35:09 2003 000001dc 00000584
lMain.cpp(  220):
> Tivoli Storage Manager ODBC Driver
> Mon Apr 14 11:35:09 2003 000001dc 00000584
lMain.cpp(  229):
> Version 5.1.5.0

> Mon Apr 14 11:35:09 2003 000001dc 00000584
lMain.cpp(  230):
> Entering DllMain() - DLL_PROCESS_ATTACH.
> Mon Apr 14 11:35:09 2003 000001dc 00000584
lMain.cpp(  289):
> Exiting DllMain(), rc = 'true'.
> Mon Apr 14 11:35:22 2003 000001dc 00000584
etup.cpp( 1439):
> Entering ConfigDlgProc() - IDOK.
> Mon Apr 14 11:35:22 2003 000001dc 00000584
lMain.cpp(  263):
> Entering DllMain() - DLL_PROCESS_DETACH.
> Mon Apr 14 11:35:22 2003 000001dc 00000584
>               DllMain.cpp(  266): ---------------------------------- END
> TRACE ----------------------------------

> Mon Apr 14 11:35:55 2003 00000584 000001dc
>               DllMain.cpp(  218): --------------------------------- BEGIN
> TRACE ---------------------------------
> Mon Apr 14 11:35:55 2003 00000584 000001dc
lMain.cpp(  220):
> Tivoli Storage Manager ODBC Driver
> Mon Apr 14 11:35:55 2003 00000584 000001dc
lMain.cpp(  229):
> Version 5.1.5.0

> Mon Apr 14 11:35:55 2003 00000584 000001dc
lMain.cpp(  230):
> Entering DllMain() - DLL_PROCESS_ATTACH.
> Mon Apr 14 11:35:55 2003 00000584 000001dc
lMain.cpp(  289):
> Exiting DllMain(), rc = 'true'.
> Mon Apr 14 11:35:55 2003 00000584

...

read more »



Sat, 01 Oct 2005 21:51:35 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Access odbc driver in ODBC 3.0

2. ODBC driver for Clipper 5.2 to connect to Access

3. Non-ODBC MS Sql Connect

4. ODBC SQL Driver Compatability

5. Whether can work SQL Accelerator Drivers without ODBC?

6. CW5 MS SQL Driver uses ODBC??

7. **ODBC Drivers and SQL Union Statements**

8. ODBC/drivers for MS-SQL

9. Using VARCHAR with SQL Server 6.5 ODBC Driver (NetExpress 2.0 on NT 4.0)

10. SQL or ODBC for Rexx ?

11. REXX Interface to ODBC Drivers

12. MAID supports C, REXX, EHLLAPI, APPC, SQL, ODBC, NT, OS/2

 

 
Powered by phpBB® Forum Software