SqlState HY000, Unicode conversion failed
Question
Thursday, October 25, 2012 9:07 AM
i have an microsoft odbc driver in unix rh 5. when running sqlcmd im able to connect but when running a query im getting error:
SqlState HY000, Unicode conversion failed
im guessing im missing one of the configuration in odbc.ini/odbcinst.ini that does the conversion but i couldn't find which.
does anyone have an idea how to solve the problem?
All replies (3)
Monday, October 29, 2012 5:46 AM âś…Answered | 1 vote
iw8iso,
Sorry for missing the OS information in your first post.
Please download the package on this website:
http://www.microsoft.com/en-ca/download/details.aspx?id=28160
It has the unixODBC 2.3.0 Driver, please use the latest version in your machine and try again.
Iric Wen
TechNet Community Support
Friday, October 26, 2012 9:15 AM
Hi iw8iso,
This error message indicates that an error occurred during conversion to or from a Unicode string. The native error will contain the Win32 error code.
Please check your event viewer and post the error code.
http://windows.microsoft.com/is-IS/windows-vista/Open-Event-Viewer
Iric Wen
TechNet Community Support
Friday, October 26, 2012 12:17 PM
its unix there is no event viewer as for the debug nothing there but the error as well