Moving from SQL to Oracle

From: Dan McLoughlin <infoserve_at_indigo.ie>
Date: Mon, 22 Oct 2001 20:26:12 +0100
Message-ID: <mn_A7.1889$8s4.6889_at_news.indigo.ie>

Hi,

I have been asked to port an application to an Oracle database from its current target of SQL Server. I connect to 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 for making a connection to an Oracle database, with any other pointers as to what to look out for, etc.

Any help would be very much appreciated.

Dan McLoughlin. Received on Mon Oct 22 2001 - 21:26:12 CEST