[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

NO_DATA error

Robert Phillips

11/7/2002 12:48:00 PM

i'm using the odbc.net data provider with the mysql odbc driver
(myodbc-2.50.39). when selecting data from a table that has an empty string
in a field (as opposed to null), i'm getting the "NO_DATA" error. i've seen
numerous posts on this that all point to qfe Q319243. i've downloaded it and
installed it, but it doesn't fix the problem.

the fix seems to install version 3.520.8504.0 of the odbc32.dll file, i have
version 3.520.9001.0 prior to installing the patch.

does anyone have any additional info, or is there other fixes that need to
be put into place?

my server is w2k server with sp3 and all latest stuff from windows update.
i have the latest .net service packs. besides mysql, nothing else is
installed on the server (besides w2k stuff - iis, msmq).

any suggustions greatly appreciated.

robert phillips
rphillips@sark.com
2 Answers

Daniel

11/15/2002 9:51:00 AM

0

you should look at this, it may help ...
http://www.mysql.com/articl...

(Using ODBC.NET with MyODBC, while fetching empty string
(0 length), will give SQL_NO_DATA exception
--> apply the patch for ODBC32.dll as it is shown on this
site)

Daniel



>-----Original Message-----
>i'm using the odbc.net data provider with the mysql odbc
driver
>(myodbc-2.50.39). when selecting data from a table that
has an empty string
>in a field (as opposed to null), i'm getting
the "NO_DATA" error. i've seen
>numerous posts on this that all point to qfe Q319243.
i've downloaded it and
>installed it, but it doesn't fix the problem.
>
>the fix seems to install version 3.520.8504.0 of the
odbc32.dll file, i have
>version 3.520.9001.0 prior to installing the patch.
>
>does anyone have any additional info, or is there other
fixes that need to
>be put into place?
>
>my server is w2k server with sp3 and all latest stuff
from windows update.
>i have the latest .net service packs. besides mysql,
nothing else is
>installed on the server (besides w2k stuff - iis, msmq).
>
>any suggustions greatly appreciated.
>
>robert phillips
>rphillips@sark.com
>
>
>.
>

Daniel

11/15/2002 10:06:00 AM

0

first ... please forget what i said about the odbc.dll
patch, i don't know why, but i dont read all of your
message ... sorry.
but you should try the mysql link ... could be that there
is something new and interesting, maybe a hint to fix the
problem.

Daniel Hommeyer

>-----Original Message-----
>you should look at this, it may help ...
>http://www.mysql.com/articl...
>
>(Using ODBC.NET with MyODBC, while fetching empty string
>(0 length), will give SQL_NO_DATA exception
> --> apply the patch for ODBC32.dll as it is shown on
this
>site)
>
>Daniel
>
>
>
>>-----Original Message-----
>>i'm using the odbc.net data provider with the mysql odbc
>driver
>>(myodbc-2.50.39). when selecting data from a table that
>has an empty string
>>in a field (as opposed to null), i'm getting
>the "NO_DATA" error. i've seen
>>numerous posts on this that all point to qfe Q319243.
>i've downloaded it and
>>installed it, but it doesn't fix the problem.
>>
>>the fix seems to install version 3.520.8504.0 of the
>odbc32.dll file, i have
>>version 3.520.9001.0 prior to installing the patch.
>>
>>does anyone have any additional info, or is there other
>fixes that need to
>>be put into place?
>>
>>my server is w2k server with sp3 and all latest stuff
>from windows update.
>>i have the latest .net service packs. besides mysql,
>nothing else is
>>installed on the server (besides w2k stuff - iis, msmq).
>>
>>any suggustions greatly appreciated.
>>
>>robert phillips
>>rphillips@sark.com
>>
>>
>>.
>>
>.
>