Help: Invalid application buffer type

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dmacq@erols.com
    #1

    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
    fw_error_www
    http://dev.mysql.com/doc/refman/5.0/en/myodbc-error-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)

    Tags: None
    Previous template Next
    Working...