473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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 1300

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jean-Francois Gagnon | last post by:
Hi, FYI, We were able to fix a problem we had with SQLServer after Hotfix 815495 was installed. Our application, written in VB.NET, with ADO.NET under .NET framework 1.0, would generate an...
8
by: MattP | last post by:
Ok, with the help of some examples found on the web and some minor modifications on our own, we have a simple and working encrypt and decrypt solution. It runs as a service, watches for files with...
2
by: Mike | last post by:
Greetings, Having a major problem here. running version 8.2 on win2003 server. The problem I am having is backing up a database seems to get to the last part of the backup and then fails. This...
6
by: Ian Gibbons | last post by:
Firstly what type is %x as I've not encountered it before? Now the problem: I'm trying to alter a host masking system for ircd so that it masks all but the isp name and location (if .uk.us etc..)....
19
by: Mark Richards | last post by:
I've been programming for many years, but have only recently taken a deep "C" dive (bad pun, i know) and need a lot of explanation from an expert. My questions center around those mysterious...
7
by: Timothy Shih | last post by:
Hi, I am trying to figure out how to use unmanaged code using P/Invoke. I wrote a simple function which takes in 2 buffers (one a byte buffer, one a char buffer) and copies the contents of the byte...
8
by: =?Utf-8?B?UHVjY2E=?= | last post by:
Hi, I'm using vs2005, .net 2, C# for Windows application. I use DllImport so I can call up a function written in C++ as unmanaged code and compiled as a dll us vs2005. My application is able to...
3
by: Alami | last post by:
I'm newdie in c programming. this is my first project in programming. I have to write a program for a airline reservation. this is what i have done yet. but when it runs it shows the number of...
7
by: John Wright | last post by:
I have data coming into a serial port that I need to take action on. I have created a delegate to read the data from the port and put it into a text box. Once the data is read, I need to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.