it depends in the method you are using to connect, but here are the details for using ODBC (uncomment the string you require and change to include your database details).
Code:
Dim oConn
set oConn = Server.CreateObject("ADODB.Connection")
'For the current Oracle ODBC Driver from Microsoft
'oConn.Open "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=myUsername;Pwd=myPassword"
'For the older Oracle ODBC Driver from Microsoft
'oConn.Open "Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword"
' ODBC Driver for Oracle - from Oracle
'oConn.Open "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword"
Connection strings taken from
http://www.able-consulting.com/MDAC/...eFromMicrosoft
dBforums
>
cionnect to oracle
10-13-04, 19:33
Linear Mode
