Hello Aaron,

Thank you for trying Guggi Oracle.

It seems that one of the dlls is not installed properly on the
computer running Guggi Oracle.

The software uses Oracle Objects for Ole (OO4O) for implementing some
of the features such as background SQL.

Please let me know which version of Oracle you are using.

Do you have following files in the ORACLE_HOME/bin folder:

oip10.dll or oip9.ddl
oip10.tlb or oip9.tlb
oraansi.dll

How difficult will it be to install Oracle Objects for Ole on your
machine? It comes on Oracle Client CD. Just install Oracle Objects
for Ole (OO4O). Otherwise, I will provide the files and a set of
instructions to install these files.

Also, can you compile this test procedure and see if you are able to
compile it ....

CREATE OR REPLACE PROCEDURE prc_test
IS
BEGIN
null;
END;

Also, is anyone else in your group also facing the same problem?

Regards

Shakti

--- In guggiusers@yahoogroups.com, Aaron Stallfus <astallfus@l...>
wrote:
>
> Good day,
>
> I am an associate of Dan, who emailed you last week. I am
experiencing a
> difficulty with Guggi that I would appreciate some assistance with.
When I
> attempt to run an UPDATE query in the SQL Editor I receive errors
and the
> update does not happen.
>
> I am trying to run the following query.
>
> update table1
> set val4 = 'x4'
> where val1 = 'x1' and val2 = 'x2' and val3 = 'x3'
>
> I highlight the query and click on the black arrow pointing left
(Run sql
> Statement). The Background SQL window appears with my query in it.
When I
> click the black arrow pointing left I receive an error message
stating that
> the "ActiveX component can't create object." When I click on
anything else I
> receive "Object variable or With block variable not set." This
includes the
> four icons to the right of the black arrow pointing left and the
red X icon
> in the upper right hand corner. When I attempt to run an INSERT
query the
> same sequence of events occur.
>
> Thank you in advance for your help,
> Aaron
>