Friday, July 08, 2005

NO_DATA in ODBC

Exploring MySQL in the Microsoft .NET Environment: "Note: Using ODBC.NET with MyODBC, while fetching empty string (0 length), will give SQL_NO_DATA exception as shown below.


System.Data.Odbc.OdbcException: NO_DATA - no error information available
at System.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb)
at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap typemap)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at System.Data.Odbc.OdbcDataReader.IsDBNull(Int32 i)
at GameShopWS.GameProvider.GetGameInfo(Int32 game_ID) in ..


You can fix the above problem by applying the patch for ODBC32.DLL from: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q319243."

No comments: