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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lakshmisaran@gmail.com - 28 May 2008 03:30 GMT

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

Reply to this Message

Tim Williams - 28 May 2008 04:11 GMT

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

Tim

> Hi,
>
[quoted text clipped - 9 lines]
>
> Lakshmi

Reply to this Message

Norman Jones - 28 May 2008 04:15 GMT

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

> Hi,
>
[quoted text clipped - 9 lines]
>
> Lakshmi

Reply to this Message

lakshmisaran@gmail.com - 28 May 2008 04:51 GMT

On May 28, 11:15 am, "Norman Jones" <normanjo...@wherforartthou.com>
wrote:

> Hi Lakshimi,
>
[quoted text clipped - 30 lines]
>
> - 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

Reply to this Message