Hello:
I am trying to locate a version of your ODBC drive that is compatible with the Windows 2003 software OS.
I am using odbc......MS ODBC Driver for DB2 6.00.1701.00
MSEIDB2D.DLL 6/9/2004
Furthermore, I am trying to find out why the ODBC app manager hanges trying to get to the mainframe db. (PLEASE SEE TRACE OUTPUT below of post).
The source envirnment was on NT but now upgrading to Windows 2003.
The applicaiton is web based built using VB, ASP pages web server architecture. Application supports 2 types of users (Super user and Normal users).The Users access the application via the web from a client 95 or NT workstation. There is a local Access db (Profile.mdb), that is used for user authentication. The application communicates to DB2 database server through SNA Server network communication using ODBC. I am trying to determine the correct version of the ODBC driver.
Software Stack on server trying to connect to mainframe DB2:
===================================================
Windows 2003 Server
Microsoft Host Integration Server 2000
MS IIS 6
ACCESS 2000
VB 6:00
If you provide any assistance that would be greatly appreciated.
Your time and assistance are appreciated.
Trace output
=============
odbcad32 1624-9e8 ENTER SQLAllocEnv
HENV * 000BB264
odbcad32 1624-9e8 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x000BB264 ( 0x00901788)
odbcad32 1624-9e8 ENTER SQLAllocConnect
HENV 00901788
HDBC * 0007CE18
odbcad32 1624-9e8 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 00901788
HDBC * 0x0007CE18 ( 0x00901830)
odbcad32 1624-9e8 ENTER SQLSetConnectOption
HDBC 00901830
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
odbcad32 1624-9e8 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 00901830
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
odbcad32 1624-9e8 ENTER SQLDriverConnectW
HDBC 00901830
HWND 001800B2
WCHAR * 0x4BF78088 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
I am trying to locate a version of your ODBC drive that is compatible with the Windows 2003 software OS.
I am using odbc......MS ODBC Driver for DB2 6.00.1701.00
MSEIDB2D.DLL 6/9/2004
Furthermore, I am trying to find out why the ODBC app manager hanges trying to get to the mainframe db. (PLEASE SEE TRACE OUTPUT below of post).
The source envirnment was on NT but now upgrading to Windows 2003.
The applicaiton is web based built using VB, ASP pages web server architecture. Application supports 2 types of users (Super user and Normal users).The Users access the application via the web from a client 95 or NT workstation. There is a local Access db (Profile.mdb), that is used for user authentication. The application communicates to DB2 database server through SNA Server network communication using ODBC. I am trying to determine the correct version of the ODBC driver.
Software Stack on server trying to connect to mainframe DB2:
===================================================
Windows 2003 Server
Microsoft Host Integration Server 2000
MS IIS 6
ACCESS 2000
VB 6:00
If you provide any assistance that would be greatly appreciated.
Your time and assistance are appreciated.
Trace output
=============
odbcad32 1624-9e8 ENTER SQLAllocEnv
HENV * 000BB264
odbcad32 1624-9e8 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x000BB264 ( 0x00901788)
odbcad32 1624-9e8 ENTER SQLAllocConnect
HENV 00901788
HDBC * 0007CE18
odbcad32 1624-9e8 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 00901788
HDBC * 0x0007CE18 ( 0x00901830)
odbcad32 1624-9e8 ENTER SQLSetConnectOption
HDBC 00901830
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
odbcad32 1624-9e8 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 00901830
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
odbcad32 1624-9e8 ENTER SQLDriverConnectW
HDBC 00901830
HWND 001800B2
WCHAR * 0x4BF78088 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>