× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. June 2009

RE: Client Access ODBC Driver

Well ODBCte32 is throwing this:

SQLExecDirect:
In: hstmt =
0x00841BA0,

szSqlStr = "select * from amflib/vennam", cbSqlStr = -3
Return: SQL_ERROR=-1

FYI, I have tried amflib.vennam as well. I do not know how to use
ODBCte32.



Here is the Trace from the actual 3rd party app...

DocRecordSvc 10c-b6c ENTER SQLAllocHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 00A5FF00
SQLHANDLE * 0155B110

DocRecordSvc 10c-b6c EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 00A5FF00
SQLHANDLE * 0x0155B110 ( 0x00a5ff78)

DocRecordSvc 10c-b6c ENTER SQLSetConnectAttrW
SQLHDBC 00A5FF78
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
SQLINTEGER -5

DocRecordSvc 10c-b6c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 00A5FF78
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -5

DocRecordSvc 10c-b6c ENTER SQLDriverConnectW
HDBC 00A5FF78
HWND 00000000
WCHAR * 0x6853B264 [ -3] <Invalid
string length!>
SWORD -3
WCHAR * 0x6853B264
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

DocRecordSvc 10c-b6c EXIT SQLDriverConnectW with return code 0
(SQL_SUCCESS)
HDBC 00A5FF78
HWND 00000000
WCHAR * 0x6853B264 [ -3] <Invalid
string length!>
SWORD -3
WCHAR * 0x6853B264
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

DocRecordSvc 10c-b6c ENTER SQLGetInfoW
HDBC 00A5FF78
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0155B148
SWORD 100
SWORD * 0x046AE9E4

DocRecordSvc 10c-b6c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 00A5FF78
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0155B148 [ 22] "CWBODBC.DLL"
SWORD 100
SWORD * 0x046AE9E4 (22)

DocRecordSvc 10c-b6c ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 00A5FF78
SQLHANDLE * 0155F068

DocRecordSvc 10c-b6c EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 00A5FF78
SQLHANDLE * 0x0155F068 ( 0x0410c520)

DocRecordSvc 10c-b6c ENTER SQLSetStmtAttrW
SQLHSTMT 0410C520
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x0000001E
SQLINTEGER -5

DocRecordSvc 10c-b6c EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0410C520
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x0000001E (BADMEM)
SQLINTEGER -5

DocRecordSvc 10c-b6c ENTER SQLGetInfoW
HDBC 00A5FF78
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x0155F0D8
SWORD 100
SWORD * 0x046AE79C

DocRecordSvc 10c-b6c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 00A5FF78
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x0155F0D8 [ 10] "03.51"
SWORD 100
SWORD * 0x046AE79C (10)

DocRecordSvc 10c-b6c ENTER SQLSetStmtAttrW
SQLHSTMT 0410C520
SQLINTEGER 1228 <unknown>
SQLPOINTER [Unknown attribute 1228]
SQLINTEGER -5

DocRecordSvc 10c-b6c EXIT SQLSetStmtAttrW with return code -1
(SQL_ERROR)
SQLHSTMT 0410C520
SQLINTEGER 1228 <unknown>
SQLPOINTER [Unknown attribute 1228]
SQLINTEGER -5

DIAG [HYC00] [IBM][iSeries Access ODBC Driver]Driver not
capable. (30058)

DocRecordSvc 10c-b6c ENTER SQLGetDiagFieldW
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 1
SQLSMALLINT 4
SQLPOINTER 0x002188A0
SQLSMALLINT 12
SQLSMALLINT * 0x046AE7B4

DocRecordSvc 10c-b6c EXIT SQLGetDiagFieldW with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 1
SQLSMALLINT 4
SQLPOINTER 0x002188A0
SQLSMALLINT 12
SQLSMALLINT * 0x046AE7B4 (10)

DocRecordSvc 10c-b6c ENTER SQLSetStmtAttrW
SQLHSTMT 0410C520
SQLINTEGER 1227 <unknown>
SQLPOINTER [Unknown attribute 1227]
SQLINTEGER -5

DocRecordSvc 10c-b6c EXIT SQLSetStmtAttrW with return code -1
(SQL_ERROR)
SQLHSTMT 0410C520
SQLINTEGER 1227 <unknown>
SQLPOINTER [Unknown attribute 1227]
SQLINTEGER -5

DIAG [HYC00] [IBM][iSeries Access ODBC Driver]Driver not
capable. (30058)

DocRecordSvc 10c-b6c ENTER SQLGetDiagFieldW
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 1
SQLSMALLINT 4
SQLPOINTER 0x002188A0
SQLSMALLINT 12
SQLSMALLINT * 0x046AE7B4

DocRecordSvc 10c-b6c EXIT SQLGetDiagFieldW with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 1
SQLSMALLINT 4
SQLPOINTER 0x002188A0
SQLSMALLINT 12
SQLSMALLINT * 0x046AE7B4 (10)

DocRecordSvc 10c-b6c ENTER SQLGetInfoW
HDBC 00A5FF78
UWORD 70 <SQL_CONVERT_VARCHAR>
PTR 0155F1E4
SWORD 4
SWORD * 0x00000000

DocRecordSvc 10c-b6c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 00A5FF78
UWORD 70 <SQL_CONVERT_VARCHAR>
PTR 0155F1E4
SWORD 4
SWORD * 0x00000000

DocRecordSvc 10c-b6c ENTER SQLBindParameter
HSTMT 0410C520
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD -9 <SQL_WVARCHAR>
SQLULEN 6
SWORD 0
PTR 0x0020E0F4
SQLLEN 14
SQLLEN * 0x0020E0F0

DocRecordSvc 10c-b6c EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0410C520
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD -9 <SQL_WVARCHAR>
SQLULEN 6
SWORD 0
PTR 0x0020E0F4
SQLLEN 14
SQLLEN * 0x0020E0F0 (12)

DocRecordSvc 10c-b6c ENTER SQLExecDirectW
HSTMT 0410C520
WCHAR * 0x0155EEC4 [ -3] <Invalid
string length!>
SDWORD -3

DocRecordSvc 10c-b6c EXIT SQLExecDirectW with return code -1
(SQL_ERROR)
HSTMT 0410C520
WCHAR * 0x0155EEC4 [ -3] <Invalid
string length!>
SDWORD -3

DIAG [42000] [IBM][iSeries Access ODBC Driver][DB2
UDB]SQL0104 - Token [ was not valid. Valid tokens: ( TABLE LATERAL
<IDENTIFIER>. (-104)

DocRecordSvc 10c-b6c ENTER SQLGetDiagRecW
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 1
SQLWCHAR * 0x00212718 (NYI)
SQLINTEGER * 0x046AE784
SQLWCHAR * 0x00211F10 (NYI)
SQLSMALLINT 1024
SQLSMALLINT * 0x046AE788

DocRecordSvc 10c-b6c EXIT SQLGetDiagRecW with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 1
SQLWCHAR * 0x00212718 (NYI)
SQLINTEGER * 0x046AE784 (-104)
SQLWCHAR * 0x00211F10 (NYI)
SQLSMALLINT 1024
SQLSMALLINT * 0x046AE788 (118)

DocRecordSvc 10c-b6c ENTER SQLGetDiagRecW
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 2
SQLWCHAR * 0x00212718 (NYI)
SQLINTEGER * 0x046AE784
SQLWCHAR * 0x00211F10 (NYI)
SQLSMALLINT 1024
SQLSMALLINT * 0x046AE788

DocRecordSvc 10c-b6c EXIT SQLGetDiagRecW with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3
SQLHANDLE 0410C520
SQLSMALLINT 2
SQLWCHAR * 0x00212718 (NYI)
SQLINTEGER * 0x046AE784
SQLWCHAR * 0x00211F10 (NYI)
SQLSMALLINT 1024
SQLSMALLINT * 0x046AE788

DocRecordSvc 10c-b6c ENTER SQLGetConnectAttrW
SQLHDBC 00A5FF78
SQLINTEGER 1209 <unknown>
SQLPOINTER 0x0155FFE8
SQLINTEGER 4
SQLINTEGER * 0x046AE794

DocRecordSvc 10c-b6c EXIT SQLGetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 00A5FF78
SQLINTEGER 1209 <unknown>
SQLPOINTER 0x0155FFE8
SQLINTEGER 4
SQLINTEGER * 0x046AE794 (4)

DocRecordSvc 10c-b6c ENTER SQLMoreResults
HSTMT 0410C520

DocRecordSvc 10c-b6c EXIT SQLMoreResults with return code 100
(SQL_NO_DATA_FOUND)
HSTMT 0410C520

DocRecordSvc 10c-b6c ENTER SQLFreeStmt
HSTMT 0410C520
UWORD 0 <SQL_CLOSE>

DocRecordSvc 10c-b6c EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 0410C520
UWORD 0 <SQL_CLOSE>

DocRecordSvc 10c-b6c ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0410C520

DocRecordSvc 10c-b6c EXIT SQLFreeHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0410C520

DocRecordSvc 10c-cf0 ENTER SQLDisconnect
HDBC 00A5FF78

DocRecordSvc 10c-cf0 EXIT SQLDisconnect with return code 0
(SQL_SUCCESS)
HDBC 00A5FF78

DocRecordSvc 10c-cf0 ENTER SQLFreeHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 00A5FF78

DocRecordSvc 10c-cf0 EXIT SQLFreeHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 00A5FF78___




-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave
Sent: Monday, June 22, 2009 2:51 PM
To: Midrange Systems Technical Discussion
Subject: re: Client Access ODBC Driver

What sort of error message are you getting?

----------------------------------------

From: "ibm" <ibm@xxxxxxxxxx>
Sent: Monday, June 22, 2009 12:46 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Client Access ODBC Driver

I am able to make a connection to the ODBC DSN but issuing any SELECT
statements fails.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.