Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 28th, 2005, 03:57 AM
Registered User
 
Join Date: Oct 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default weird ASP/VB/Oracle problem....

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









Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with oracle & crystal report with Vb abhijhegde Beginning VB 6 1 May 3rd, 2007 12:03 PM
Weird ASP/SQL Problem cancer10 Classic ASP Databases 4 March 7th, 2007 09:15 AM
weird problem with Ch 9 example proslambano BOOK: Ivor Horton's Beginning Visual C++ 2005 1 February 2nd, 2007 02:06 AM
weird problem! Please Help johnjohn Classic ASP Databases 5 December 21st, 2004 10:27 AM
weird Oracle problem! pankaj_daga Oracle 2 July 12th, 2004 09:33 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.