View Single Post
  #3   Report Post  
Old September 26th 06, 03:00 PM posted to microsoft.public.excel.programming
Mike Hartsough Mike Hartsough is offline
external usenet poster
First recorded activity by ExcelBanter: Oct 2006
Posts: 11
Default Error 429 ActiveX Component can't create object

That did the trick, everything's working fine now.


"Tom Ogilvy" wrote:

to download:

Tom Ogilvy

"Mike Hartsough" wrote:

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.