469,904 Members | 2,067 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,904 developers. It's quick & easy.

Help: Invalid application buffer type

I 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/...ror-codes.html

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 <SQL_HANDLE_STMT>
SQLHANDLE 011715E8
SQLHANDLE * 051E983C

abt 1634-17ec EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
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 <unknown>
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 <unknown>
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 <unknown>
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 <unknown>
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 <unknown>
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 <unknown>
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 <unknown>
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 <unknown>
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 <unknown>
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 <unknown>
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)

Apr 29 '06 #1
0 1078

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Mike | last post: by
6 posts views Thread by Ian Gibbons | last post: by
19 posts views Thread by Mark Richards | last post: by
7 posts views Thread by Timothy Shih | last post: by
3 posts views Thread by Alami | last post: by
7 posts views Thread by John Wright | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.