How to connect oracle using ADO

All,

I am working on a VB application where I need to access some data on an ORACLE database. ADO provides a Connection object that will allow me to perform this activity. The Connection object has a ConnectionString property that provides ADO the necessary information to make the connection
to the database. The arguments needed within the string to make a connection to an ORACLE database are as follows:

 anADOConnection.ConnectionString = "Driver={Microsoft ODBC for Oracle};" _
  & "Server=name of server;UID= user name;Password=password"

For the Server argument, the only value that worked for me was the name of a
service that I had previously established using the ORACLE Net8 Assistant
interface. This interface creates a service that establishes the hostname,
the port number, the SID, the username, and password of an ORACLE database.

My question: Is there a way to create an ORACLE service(server) within my VB
code so that my application will not have to depend on an existing service?

The ADO documentation from Microsoft seems only to have examples using Microsoft Access or SQL Server. Any help or advice will be appreciated. Thanks

Please reply to dfong_at_esri.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 12 1999 - 19:44:12 CST