Home » Infrastructure » Windows » Errors when trying to connect to Orable from VBA using OraOLEDB.Oracle
icon9.gif  Errors when trying to connect to Orable from VBA using OraOLEDB.Oracle [message #130919] Wed, 03 August 2005 03:29
Spud_1001
Messages: 2
Registered: August 2005
Junior Member
This is really frustrating me.

I have created a macro within Microsoft Access to connect to an oracle server and run a PL/SQL Procedure. This worked fine when I was using the MSDAORA provider but I came across a problem when I needed to return a recordset. It wouldn't work.

Having searched online for a little I found that using the OraOLEDB.Oracle provider should solve all my problmes however using this provider, I cannot even execute a simple Stored procedure. I get cryptic error messages back from Oracle.

The most recent error message said:

Run-time error '-2147467259 (80004005)':
?|□?□

I've looked online for resolutions and people mention changing the permissions on the oracle folder, but it didn't work.

Please help, I'm desperate!

Dave
Previous Topic: Time taken by Export and Import
Next Topic: export running om win200
Goto Forum:
  


Current Time: Thu Mar 28 12:44:41 CDT 2024