Thanks for the information Ashish

Hello Guggiusers,

As long as the oipXX.dll where XX = 8 or 9 or 10
depending on the database version is installed and
oipXX.tlb is present either in the folder where Guggi
is installed or in the ORACLE_HOME/bin folder,
execution of DML SQL in background thread should work
fine.


In version 1.5.3, execution in background thread has
been made optional.

You can download ORADAC.exe from Oracle's download
site and install OO4O in case you don't have the
client CD.

Shakti

--- Ashish Ranjan <ashishwave@...> wrote:

> i am using Oracle 8i and hence i do have oip8.dll
> present there.
> bye :-)
> Ashish
>
> --- "Shakti <skgoel@...>"
> <shakti_k_goel@...> wrote:
>
> > Thanks for the response Ashish. Can you please
> let
> > me
> > know if you have oip10.dll or oip9.dll file in the
> > ORACLE_BASE/ORACLE_HOME/bin folder?
> >
> > Thanks
> >
> > Shakti
> >
> > --- Ashish Ranjan <ashishwave@...> wrote:
> >
> > > atleast i don't have any problems, but i will
> > > definitely like to say that if it finally gets
> > > resolved, then add this to a "Troubleshooting
> FAQ"
> > > bye :-)
> > > Ashish Ranjan
> > >
> > > --- vandana_arora <vandana_arora@...>
> wrote:
> > >
> > > > 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
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > > __________________________________
> > > Yahoo! FareChase: Search multiple travel sites
> in
> > > one click.
> > > http://farechase.yahoo.com
> > >
> >
> >
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>