how to connect to oracle database 10g? 1

[jfdabiri]

hi,
i'm trying to write a script to connect to an oracle database 10g and do some queries from a table. i know how the code is done for access databases like this:

Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open _
   "Provider = Microsoft.Jet.OLEDB.4.0; " & _
   "Data Source = " & db_path

what would be the equivalent of this for oracle?
thanks.

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jfdabiri]

thanks,
PHV.
that link has the connection string for every database.
it worked like a charm.