Hi,
Just a brief, I've got an ASP site which runs on an Oracle database(9.2.0.1.0) and also a compiled DLL written in
VB. All was working fine until i updated the ODBC driver for Oracle to version 9.2.0.5.4. The previous version was the default driver that came with the package which was 9.2.0.0.0.
Now with the new driver installed, i get the following error message
"
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."
And for the life of me i cannot figure out why just updating the driver it causes an error like this. To me it seems like that the recordset is being corrupted...i've tried debugging the DLL but to no avail have i found the root of the problem.
Here is an example of the connection string that i am using
If DBType = "Oracle" Then ConnectionString = Trim("DSN=" & DSN & ";UID=" & UserId & ";PWD=" & password & "")
Has anyone experienced something like this? Anyone know of a fix that might solve this?
i'm open to all suggestion as i'm nearly at my wits end...any help appreciated.
Many Thanks