Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error

[lakshmisaran]

Hi,

I get this error while running a report in Excel VBA 2003,

my code is

Dim OraSession As Object
Set OraSession = CreateObject("OracleInProcServer.XOraSession")

Do i need to set any references for this? pls. help very urgent.
This report runs in few system.

Lakshmi

 

[Tim Williams]

You're using late binding, so you should not need to set a reference.
Is the Oracle package installed on the client ?

Tim

 

[Norman Jones]

Hi Lakshimi,


Unfortunately, you do not provide the next
linewhich describes the automation error.

However, the error may relate to an Oracle
privileges issue.

As you are using late binding, you do not need
to set references.

 

[lakshmisaran]

Hi Lakshimi,

Unfortunately, you do not provide the next
linewhich describes the automation error.

However, the error may relate to an Oracle
privileges issue.

As you are using late binding, you do not need
to set references.

---
Regards.
Norman











- Show quoted text -

even if i didnt provide that line the report works fine, but it was
running fine in my system, from yesterday i got this error, do i need
to check any dlls? or priveleges? I'm new to this Excel
programming(I'm basically Oracle person).

I even have another problem in my client system. In another report the
error is "Rowset cannot be loaded because the stream is invalid" the
report is connected in WAN. Can you pls help on these 2 rgds.

Thx in advance.

Lakshmi