 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
