Oracle error
-
Greeting all, I'm trying to use on OleDbDataAdapter to read data from an Oracle 8.1 database. Ittermitantly, when I call the fill method, I get an OleDbException that has me stumped. The message is: "Oracle error occured, but error message could not be retrieved from Oracle." The error code is -2147467259. It seems to be ittermittant: sometimes it happens, no matter what's in the SQL and other times not... All insight appreciated, Bill
-
Greeting all, I'm trying to use on OleDbDataAdapter to read data from an Oracle 8.1 database. Ittermitantly, when I call the fill method, I get an OleDbException that has me stumped. The message is: "Oracle error occured, but error message could not be retrieved from Oracle." The error code is -2147467259. It seems to be ittermittant: sometimes it happens, no matter what's in the SQL and other times not... All insight appreciated, Bill
I haven't tried but I do know that the original OLE adapter had some problems going against Oracle. Oracle never behaves right with normal code :) Have you tried the updated Oracle Provider that Microsoft recently released? or perhaps Oracle's own provider? I think it can be found on the Technet site for Oracle. Mark