Problem using ODBC with MySQL

[Faisal Yaqoob]

I am using MySQL ODBC driver and System.Data.Odbc package to connect to
database.

I am using OdbcDataReader to read the recordset returned as a result of a
query.
I do check if the column value is null or not before reading it using
OdbcDataReader.IsDBNull(column_index)
This function throws an exception saying "Specified Cast is not valid" if
the column type is varchar ans contains an empty string (not a null), and
any subsequent calls on the said OdbcDataReader fails.

Is this the problem with the Odbc classes or the Odbc driver?

 

[Mohamoss]

Hi Faisal
It cound be related to that known problem, check out:

Q319243 FIX: ODBC Driver Mgr. Reports SQL_NO_DATA_FOUND for ANSI Driver
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319243

Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC