Help: Invalid application buffer type
am 29.04.2006 04:30:49 von dmacqI am getting myOdbc error 518 Sqlstate- HY001 Invalid application
buffer type when I try to retrieve all table names. I am using version
mysql Ver 14.12 Distrib 5.0.19, for Win32 (ia32) with Odbc driver
03.51 on Windows XP Home.
I have googled the heck out of this and would like a clue. The trace
file is below. The query dies looking for a non-existent coumn 6, but
in
http://dev.mysql.com/doc/refman/5.0/en/myodbc-error-codes.ht ml
hy001 is a memory allocation error with mySql code of 516 and
mySql code 518 in invalid application buffer type with sqlState of
Hy003,
so someone is confusing me here. Any help appreciated.
Thanks in advance.
abt 1634-17ec ENTER SQLAllocHandle
SQLSMALLINT 3
SQLHANDLE 011715E8
SQLHANDLE * 051E983C
abt 1634-17ec EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 011715E8
SQLHANDLE * 0x051E983C ( 0x01172140)
abt 1634-17ec ENTER SQLTablesW
HSTMT 01172140
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x011720D8 [ 40] "'TABLE','SYSTEM
TABLE','ALIAS','SYNONYM'"
SWORD 40
abt 1634-17ec EXIT SQLTablesW with return code 0
(SQL_SUCCESS)
HSTMT 01172140
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x011720D8 [ 40] "'TABLE','SYSTEM
TABLE','ALIAS','SYNONYM'"
SWORD 40
abt 1634-17ec ENTER SQLDescribeCol
HSTMT 01172140
UWORD 1
UCHAR * 0x051E9DC0
SWORD 32
SWORD * 0x051E9DEC
SWORD * 0x051E9DFC
SQLULEN * 0x051E9E0C
SWORD * 0x051E9E20
SWORD * 0x051E9E30
abt 1634-17ec EXIT SQLDescribeCol with return code 0
(SQL_SUCCESS)
HSTMT 01172140
UWORD 1
UCHAR * 0x051E9DC0 [ 9] "TABLE_CAT"
SWORD 32
SWORD * 0x051E9DEC (9)
SWORD * 0x051E9DFC (12)
SQLULEN * 0x051E9E0C (64)
SWORD * 0x051E9E20 (0)
SWORD * 0x051E9E30 (1)
abt 1634-17ec ENTER SQLColAttribute
SQLHSTMT 01172140
SQLSMALLINT 1
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051E9F0C
abt 1634-17ec EXIT SQLColAttribute with return code 0
(SQL_SUCCESS)
SQLHSTMT 01172140
SQLSMALLINT 1
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051E9F0C (64)
abt 1634-17ec ENTER SQLDescribeCol
HSTMT 01172140
UWORD 2
UCHAR * 0x051EA164
SWORD 32
SWORD * 0x051EA190
SWORD * 0x051EA1A0
SQLULEN * 0x051EA1B0
SWORD * 0x051EA1C4
SWORD * 0x051EA1D4
abt 1634-17ec EXIT SQLDescribeCol with return code 0
(SQL_SUCCESS)
HSTMT 01172140
UWORD 2
UCHAR * 0x051EA164 [ 11] "TABLE_SCHEM"
SWORD 32
SWORD * 0x051EA190 (11)
SWORD * 0x051EA1A0 (12)
SQLULEN * 0x051EA1B0 (64)
SWORD * 0x051EA1C4 (0)
SWORD * 0x051EA1D4 (1)
abt 1634-17ec ENTER SQLColAttribute
SQLHSTMT 01172140
SQLSMALLINT 2
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EA2B0
abt 1634-17ec EXIT SQLColAttribute with return code 0
(SQL_SUCCESS)
SQLHSTMT 01172140
SQLSMALLINT 2
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EA2B0 (64)
abt 1634-17ec ENTER SQLDescribeCol
HSTMT 01172140
UWORD 3
UCHAR * 0x051EA508
SWORD 32
SWORD * 0x051EA534
SWORD * 0x051EA544
SQLULEN * 0x051EA554
SWORD * 0x051EA568
SWORD * 0x051EA578
abt 1634-17ec EXIT SQLDescribeCol with return code 0
(SQL_SUCCESS)
HSTMT 01172140
UWORD 3
UCHAR * 0x051EA508 [ 10] "TABLE_NAME"
SWORD 32
SWORD * 0x051EA534 (10)
SWORD * 0x051EA544 (12)
SQLULEN * 0x051EA554 (64)
SWORD * 0x051EA568 (0)
SWORD * 0x051EA578 (1)
abt 1634-17ec ENTER SQLColAttribute
SQLHSTMT 01172140
SQLSMALLINT 3
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EA654
abt 1634-17ec EXIT SQLColAttribute with return code 0
(SQL_SUCCESS)
SQLHSTMT 01172140
SQLSMALLINT 3
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EA654 (64)
abt 1634-17ec ENTER SQLDescribeCol
HSTMT 01172140
UWORD 4
UCHAR * 0x051EA8AC
SWORD 32
SWORD * 0x051EA8D8
SWORD * 0x051EA8E8
SQLULEN * 0x051EA8F8
SWORD * 0x051EA90C
SWORD * 0x051EA91C
abt 1634-17ec EXIT SQLDescribeCol with return code 0
(SQL_SUCCESS)
HSTMT 01172140
UWORD 4
UCHAR * 0x051EA8AC [ 10] "TABLE_TYPE"
SWORD 32
SWORD * 0x051EA8D8 (10)
SWORD * 0x051EA8E8 (12)
SQLULEN * 0x051EA8F8 (64)
SWORD * 0x051EA90C (0)
SWORD * 0x051EA91C (1)
abt 1634-17ec ENTER SQLColAttribute
SQLHSTMT 01172140
SQLSMALLINT 4
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EAA24
abt 1634-17ec EXIT SQLColAttribute with return code 0
(SQL_SUCCESS)
SQLHSTMT 01172140
SQLSMALLINT 4
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EAA24 (64)
abt 1634-17ec ENTER SQLDescribeCol
HSTMT 01172140
UWORD 5
UCHAR * 0x051EAC2C
SWORD 32
SWORD * 0x051EAC58
SWORD * 0x051EAC68
SQLULEN * 0x051EAC78
SWORD * 0x051EAC8C
SWORD * 0x051EAC9C
abt 1634-17ec EXIT SQLDescribeCol with return code 0
(SQL_SUCCESS)
HSTMT 01172140
UWORD 5
UCHAR * 0x051EAC2C [ 7] "REMARKS"
SWORD 32
SWORD * 0x051EAC58 (7)
SWORD * 0x051EAC68 (12)
SQLULEN * 0x051EAC78 (64)
SWORD * 0x051EAC8C (0)
SWORD * 0x051EAC9C (1)
abt 1634-17ec ENTER SQLColAttribute
SQLHSTMT 01172140
SQLSMALLINT 5
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EADC4
abt 1634-17ec EXIT SQLColAttribute with return code 0
(SQL_SUCCESS)
SQLHSTMT 01172140
SQLSMALLINT 5
SQLSMALLINT 3
SQLPOINTER 0x00000000
SQLSMALLINT 0
SQLSMALLINT * 0x00000000
SQLPOINTER 0x051EADC4 (64)
abt 1634-17ec ENTER SQLDescribeCol
HSTMT 01172140
UWORD 6
UCHAR * 0x051EB01C
SWORD 32
SWORD * 0x051EB048
SWORD * 0x051EB058
SQLULEN * 0x051EB068
SWORD * 0x051EB07C
SWORD * 0x051EB08C
abt 1634-17ec EXIT SQLDescribeCol with return code -1
(SQL_ERROR)
HSTMT 01172140
UWORD 6
UCHAR * 0x051EB01C
SWORD 32
SWORD * 0x051EB048
SWORD * 0x051EB058
SQLULEN * 0x051EB068
SWORD * 0x051EB07C
SWORD * 0x051EB08C
DIAG [HY001] [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]Invalid
column number (518)
abt 1634-17ec ENTER SQLGetDiagRecW
SQLSMALLINT 3
SQLHANDLE 01172140
SQLSMALLINT 1
SQLWCHAR * 0x0012F79C (NYI)
SQLINTEGER * 0x051EB500
SQLWCHAR * 0x01172580 (NYI)
SQLSMALLINT 511
SQLSMALLINT * 0x051EB71C
abt 1634-17ec EXIT SQLGetDiagRecW with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 01172140
SQLSMALLINT 1
SQLWCHAR * 0x0012F79C (NYI)
SQLINTEGER * 0x051EB500 (518)
SQLWCHAR * 0x01172580 (NYI)
SQLSMALLINT 511
SQLSMALLINT * 0x051EB71C (64)