Error 429 ActiveX Component can't create object

G

Guest

A coworker has given me a spreadsheet that pulls data from an Oracle database.

He has no problem running the macro, but when I try to run it I get error
'429' ActiveX Component can't create object.

Here's the line that causes the error:
Set oOraSession = CreateObject("OracleInProcServer.XOraSession")

Can anyone suggest what my problem might be?

I'm pretty sure that I have an Oracle client installed on my PC, though I'm
not sure how to check that it's running.

Thanks,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to use CreateObject("OracleInProcServer.XOraSession") 2
VBA fails with Run-time Error 429 "ActiveX component can't create object" 1
"Run-time error 429: ActiveX comonent can't create object" MSComm 5
Erro 429 Set gApp = CreateObject("AcroExch.App") 0
ActiveX component can't create object or return reference to thisobject (Error 429) 4
Runtime error 429 3
"Scripting.FileSystemObject" suddenly stopped working 3
Does CDO mail require a reference? 2

Top