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

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

Tim

wrote in message
...
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

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


wrote in message
...
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

On May 28, 11:15*am, "Norman Jones"
wrote:
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

wrote in message

...



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- Hide quoted text -

- 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