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


 

Forums >

microsoft.public.dotnet.framework.odbcnet

ODBC.NET errors when accessing blank fields

Nicolas Husson

1/19/2003 2:37:00 AM

Hi,


I'm using an ODBC.NET datareader to get some records from
a Sybase 5 db, but sometimes when I try to access a field
whose content is blank (i.e. a blank string), then I got
an ODBC exception that says something like "NO_DATA..",
The thing is, when it happens, the rest of my select
statement (i.e the fields coming after the "blank" field
in the SELECT statement) is "corrupted"...

Has anybody experienced that?

Nicolas Husson
Aniworld, Inc.
3 Answers

(Microsoft Developer Support)

1/20/2003 9:11:00 PM

0

Hi Nicolas,
Looks like you are running into a bug.

Please look the following article for further information.

319243 FIX: ODBC Driver Manager Incorrectly Reports SQL_NO_DATA_FOUND for
ANSI
http://support.microsoft.com/...

Thanks
Syed Mehdi
Microsoft Developer Support

This posting is provided “AS IS” with no warranties, and confers no rights.
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.co....

Neil Allen

1/21/2003 9:04:00 AM

0

In article <01f201c2bf5b$4eeb2e40$d3f82ecf@TK2MSFTNGXA10>,
nhusson@aniworld.com says...
> Hi,
>
>
> I'm using an ODBC.NET datareader to get some records from
> a Sybase 5 db, but sometimes when I try to access a field
> whose content is blank (i.e. a blank string), then I got
> an ODBC exception that says something like "NO_DATA..",
> The thing is, when it happens, the rest of my select
> statement (i.e the fields coming after the "blank" field
> in the SELECT statement) is "corrupted"...
>
> Has anybody experienced that?
>
> Nicolas Husson
> Aniworld, Inc.
>

Dear Nicolas

It's a known problem

The following should help...

http://www.microsoft.com/downloads/details.aspx?displaylang=en&...
6263FCF4-A2AD-4690-8F6D-3341C16B31E6


Regards

Neil Allen

Samuel Ludlow

1/21/2003 1:48:00 PM

0

I was also having the same problem using ODBC.Net to
connect to a Sage Line50 ODBC data source.

I can confirm that the patch at:

http://support.microsoft.com/...

did fix the problem.

Samuel Ludlow

>-----Original Message-----
>Hi,
>
>
>I'm using an ODBC.NET datareader to get some records from
>a Sybase 5 db, but sometimes when I try to access a field
>whose content is blank (i.e. a blank string), then I got
>an ODBC exception that says something like "NO_DATA..",
>The thing is, when it happens, the rest of my select
>statement (i.e the fields coming after the "blank" field
>in the SELECT statement) is "corrupted"...
>
>Has anybody experienced that?
>
>Nicolas Husson
>Aniworld, Inc.
>.
>