Re: HY003 error
Nick Gorham <[email protected]>
| Newsgroups | gmane.comp.db.unixodbc.devel |
|---|---|
| Message-ID | <[email protected]> |
Tony Khalil wrote: >Hi Nick, > >Thank you for your reply. You are right with what you said, in the trace >file I have the following: >[ODBC][25164][SQLBindCol.c][222] > Entry: > Statement = 0x83c13d0 > Column Number = 1 > Target Type = 12 SQL_VARCHAR > Target Value = 0x83c1350 > Buffer Length = 50 > StrLen Or Ind = (nil) >[ODBC][25164][SQLBindCol.c][282]Error: HY003 > >The field type in the database is a varchar. How can I make the correct >binding. > >Thank you in advance. > > > Ok, well, if you have the source to the acc making the (or the library) you can change the SQL_VARCHAR to a SQL_C_CHAR which is the correct value, other than that, you could patch the driver manager in SQLBindCol.c to change a SQL_VARCHAR to a SQL_C_CHAR. You could try adding it to the list of valid types, but the driver may then hav a issue with it. If you get a copy of the 2.2.13pre unixODBC code, I will send you a tweeked copy of SQLBindCol.c that should do what you want. -- Nick _______________________________________________ unixODBC-dev mailing list [email protected] http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev