Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OraOLEDB error '80040e4b' : Accessor is not a parameter accessor

503027Mar 30 2006 — edited Dec 2 2008
Hi!

I'm seeing the following error, inconsistently, in my ASP application:

OraOLEDB error '80040e4b'
Accessor is not a parameter accessor

The database is an Oracle 9i database - the web server has an Oracle 9i
client installation on it. Not sure as to the MDAC version as my
company firewall prevents me downloading the Component Checker. Is
there another way to determine the version?

If I refresh the page, the error will disappear and the page will load
correctly. I've notice that, although it occurs on and off, it always
occurs on the following line of code:

start_date = rstProb("start_date")

In context:

Set cnnDB = Server.CreateObject("ADODB.Connection")
strConn = "Provider=OraOLEDB.Oracle;User
ID=USER_SCHEMA;Password=password; Data Source=SOURCE"
cnnDB.Open(strConn)
Set rstProb = SQLQuery(cnnDB, "SELECT * FROM PROBLEMS WHERE ID = 10)
start_date = rstProb("start_date")

You get the picture.

The column PROBLEMS.START_DATE is of type DATE

Any thoughts? I can't understand why this doesn't fail consistently,
even though the data does not change...

Thanks in advance for your thoughts.

Regards,

mroshaw
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 30 2008
Added on Mar 30 2006
16 comments
56,371 views