Oracle Connection String 1

[FengShui1998]

Hello,

I'm trying to connect to an Oracle database. Does any body have a connection string I could use with

server
uid
password
dbq

Or is it more involved than using an SQL connection string?


Thanks,

fengshui1998

 

[wushutwist]

Why not create a DSN and just connect to it that way? Wushutwist

 

[WenStin]

Here's an example. I use this DSN-less string to connect to an Oracle 8i database:

set dbconn = server.CreateObject("ADODB.Connection&quot
dbconn.Open "Provider=MSDAORA.1;Data Source=sun1.xxxxxxx.com;User Id=xxxxxt;PASSWORD=xxxxxxx;"

Hope this helps.

 

[FengShui1998]

wenstin,

Just what I was looking for. Thanks!!!


fengshui1998