Hi,

How can I connect to a Sybase and Oracle Database using the ODBC DSN name.

Thanks.

RGD

Connect to Oracle from asp page:
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=OraOLEDB.Oracle.1;User ID=xxxx;Password=xxxx;Data Source=xxxxxx;"
or
oConn.Open "Driver={Microsoft ODBC for Oracle};Server=xxxxxx;Uid=xxxx;Pwd=xxxx;"
(both worked for me when i used Oracle in OraHome 92 driver to create ODBC)

Or sorry, forgot about DSN connection:
oConn.Open "DSN=YourDSN;Uid=xxxx;Pwd=xxxx;"
Microsoft ODBC for Oracle driver was used to create system DSN 'YourDSN'