Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and the Internet
The method I use to write client/server apps is to call Oracle Objects for OLE (OO4O) from VB. For instance, I can dial up my ISP from home, and run a VB/OO4O program which connects to a remote Oracle database service which I have defined in my PC's tnsnames.ora file. OO4O can be installed from the Oracle Client install CD.
I don't have enough experience with ADO to know whether you could use this instead of OO4O, but you should consider OO4O as a solution, because OO4O will provide you with full access to all Oracle functionality included in the remote database, whereas ADO probably won't. ADO is a "generic" product which might not expose all of the functionality of a connected database.
Hope this helps.
Jon
Cal wrote:
> I have to look at possible solutions for connecting to a remote Oracle
> database over the Internet. One idea is a VB client application. I am also
> open to other solutions at this point. Can anybody help me out with
> gathering information on this? Point me in the right direction? I am
> exploring ADO/VB Client scenario, but am unclear if I can connect through
> the Internet. Security is also important. Should I be looking at another
> method?
>
> Thanks.
>
> Cal Gardner
> Programmer, PageMail, Inc.
Received on Wed Aug 16 2000 - 22:32:00 CDT