Help: Invalid application buffer type

dmacq

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

abt 1634-17ec EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STM T>
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','SYSTE M
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','SYSTE M
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_SCHE M"
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

Subscribe Reply

1317

Similar topics

1554

Invalid Buffer Error (Hotfix 815494) and ADO.NET and Framework 1.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 SQL exception of "General network error" or "A severe error occured on the current command. The Results, if any,

Microsoft SQL Server

3013

Help with CryptoStream and incomplete files...

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 a specific extension in a specific directory. The files are uploaded by FTP to this directory. The service then does the following steps: 1) Verify it can open the file (so we know it's fully uploaded). 2) Try to decrypt the file with known...

.NET Framework

5558

Please HELP .. instance crash ver 8.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 brings the whole instance down and it has to be restarted. In addition the job seems to be stuck in the TOOLSDB as if I try to delete the backup job I get "The task is currently running". So I went to the command line and tried "db2 backup database...

DB2 Database

2612

Help with building a string

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..). However the crc32 stuff doesnt return as a string, and because the number of hostname fields is not static I need to build a string which contains each hostname field hashed and joined together. if (parc > 4) /* There are isp's like...

C / C++

2072

Help the helpless.. code read

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 pointer beasties. The following code is excerpted from digitemp, a program that reads 1-wire devices. Digitemp is the work of Brian C. Lane. As I walk through this code, I have a number of questions. I'm hoping someone with experience in...

C / C++

3301

Need help with importing unmanaged code

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 buffer into the character pointer. The code looks like the following: #include <stdio.h> #include <stdlib.h> #include "stdafx.h" BOOL APIENTRY DllMain( HANDLE hModule, DWORD ul_reason_for_call,

C# / C Sharp

2930

Need Help declaring parameter variables for DllImport for c-dll fu

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 call the function, EncodeAsnUser. And it's returning OK but when I display the decoded data in another part of my application it shows no data has been decoded, all fiedls are either null or blanks. For some reason, I am not able to step through...

C# / C Sharp

1848

Please help me to find the error

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 seats as 0 and the flight no. is also repeating. If any can tell why is this please help me. #include<stdio.h> #include<ctype.h> #include<conio.h> #include<memory.h>

C / C++

1633

Serial Port Help

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 manipulate it. However, when I try to take any action on the data, I get errors. When I call the function GetTareandWeight, it gives me an error on the split function because the data is not done streaming in yet. How can I wait for all the data to get...

Visual Basic .NET

8457

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8788

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8563

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8646

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6203

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5675

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

2776

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2013

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1778

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General