Bug in ODBC.net Driver ??
Working in vb.net, I am connecting to a Paradox 8.0 database trhough the odbc.net driver. Everything is working fine, But for all boolean fields. They seem to have no consistency in values whatsoever. Thus i get unpredictable results, that are NOT comming from the database.I have testet this in the simplet enviroment possible (only one class, one method etc) and the error is still there
Any help would be very appreciated.
connString as string =
"Driver={Microsoft Paradox Driver (*.db )};" & _ "DriverID=538;" & _
"Fil=Paradox 8.X;" & _
"DefaultDir=" & dataSource & _
";Dbq=" & dataSource & _
";CollatingSequence=ASCII;" & _
"Uid=" & userid & ";Pwd=" & password & ";"
ODBCConnection = New OdbcConnection(ConnString)
When i do a select on a paradox 8 databse the boolean fields are random! no predictable sequence in them
The bug seems to be in the driver as a sqlConnection to a MsSql database with the SAME CODE AROUND IT do not produce the error.
Microsoft Visual Basic .NET 55537-640-4091527-18564
__________________
/ab