Kbase P12008: SQL-92: NO_DATA - no error information available using .Net
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/27/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
NO_DATA - no error information available.
Using SQL-92 engine
Using ODBC.NET data provider
Character data type field contains NULL value
Using .NET Framework 1.0
The problem does not occur with .NET Framework 1.1
CAUSE:
This is a Microsoft issue.
See http://support.microsoft.com/default.aspx?scid=kb;EN-US;q319243 for further information.
FIX:
Upgrade to .NET Framework 1.1 and later.
If upgrading is not an option, use the DataDirect workarounds (WorkArounds2=4096) in the OdbcConnection function.
WorkArounds2=4096. The ODBC Driver Manager incorrectly translates lengths of empty strings when a UNICODE enabled application uses a non-UNICODE driver. This workaround causes the MERANT drivers to internally adjust the length of empty strings. Use this workaround only if your application is UNICODE enabled.
For example:
Dim con as New Microsoft.Data.Odbc.OdbcConnection("dsn=test;WorkArounds2=4096;uid=myUser;pwd=myPwd;database=sports")