Connecting to an Oracle database

From: Dan McLoughlin <infoserve_at_indigo.ie>
Date: Tue, 23 Oct 2001 08:23:29 +0100
Message-ID: <QT8B7.2016$8s4.7778@news.indigo.ie>

Hi all,

I am trying to connect to an Oracle database with a VB application that curreently uses a SQL database. I set up the connection for SQL as follows:

Public conMain As Connection
.
.

Set conMain = New Connection
.
.

' get database settings from registry
strDatabasePath = GetSetting("MyDB", "ConnectionDetails", "DatabasePath") strDatabaseUser = GetSetting("MyDB", "ConnectionDetails", "DatabaseUser") strDatabasePassword = GetSetting("MyDB", "ConnectionDetails", "DatabasePassword")
strDatabase = GetSetting("MyDB", "ConnectionDetails", "Database")
.
.

'set the connection properties

conMain.Properties("Data Source") = strDatabasePath ' machine name
conMain.Properties("User ID") = strDatabaseUser ' user name
conMain.Properties("Password") = strDatabasePassword ' password

'connect to SQL
conMain.Open
'specify db to use
conMain.DefaultDatabase = g_Database '

Can anyone please tell me what is the equivalent connection string for an Oracle 8i database, plus any other problems to expect after I make the connection. Any help would be much appreciated.

Dan. Received on Tue Oct 23 2001 - 02:23:29 CDT