Daniel Naumann
2/28/2002 6:56:00 AM
Hi Dan,
Any time frame on that SP1 for MDAC 2.7??
Thanks,
Daniel.
""Dan Kirby"" <dank@online.microsoft.com> wrote in message
news:mCQdHaxvBHA.2196@cpmsftngxa09...
> Hi Johannes,
>
> A number of folks have posted this problem when using the MYSQL ODBC
> driver. We have been investigating this and the problem appears to be with
> conversions which are done by the ODBC driver manager when an ODBC 3.0
> application is calling SQLGetData on an ODBC driver which doesn't support
> the UNICODE ODBC APIs. In this case, the ODBC Driver manager is returning
> SQL_NO_DATA rather than SQL_SUCCESS as it shoud with a zero-length string.
> If we confirm that this is a problem with the driver manager, we will push
> to get it fixed in the next MDAC Service Pack (2.7 SP1).
>
> In the mean-time, not using empty string data (use null values perhaps or
> pad with spaces) would be one way to resolve the problem. Anything but
> having zero-length data would work.
>
> For those ODBC drivers which are ODBC 3.0 drivers and support the Unicode
> APIs, the problem will not occur.
>
> Dan Kirby
> Microsoft Corporation
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --------------------
> Reply-To: "Aza" <johannes.stromberg@skanska.se>
> From: "Aza" <johannes.stromberg@skanska.se>
> Subject: NO DATA error on empty strings
> Date: Tue, 26 Feb 2002 15:29:03 +0100
> Lines: 10
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
> Message-ID: <uDNJrItvBHA.2216@tkmsftngp05>
> Newsgroups: microsoft.public.dotnet.framework.odbcnet
> NNTP-Posting-Host: c246-189.users.skanska.se 144.57.246.189
> Path: cpmsftngxa07!cpmsftngxa09!tkmsftngp01!tkmsftngp05
> Xref: cpmsftngxa07 microsoft.public.dotnet.framework.odbcnet:746
> X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet
>
> Hi,
>
> I get a NO DATA exception when running ODBC.NET
> with select statements that return columnvalues with empty strings.
>
> Is there any way of solving this problem?
>
> /Johannes
>
>
>