Urgente, conexion para Oracle, de las siguientes:

[BlancaYuri]

Hola, tengo problemas para conectarme a la base de datos de Oracle, si sabes algo al respecto, help me!!!
Cual de las siguientes es la correcta y porque?

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=OracleDSN;uid=userid;pwd=password;&qu ot;

'Microsoft OLEDB Provider for Oracle
"Provider=MSDAORA.1;Data Source=Your_TNSNames_Alias;User ID=User;Password=Password"

'Microsoft ODBC for Oracle DSN-Less
"Provider=MSDASQL;DRIVER={Microsoft ODBC for ORACLE};UID=User;PWD=Password;Server=Your_TNSNames _Alias"

'Microsoft ODBC for Oracle using a DSN
"DSN=Your_DSN_Name;UID=User;PWD=Password&quot ;

Set OraSession = Server.CreateObject("OracleInProcServer.XOraS ession")
Set OraDatabase = OraSession.DbOpenDatabase("", "usID/pw", cint(0))

Set OraDatabase = Server.CreateObject("ADODB.Connection")
OraDatabase.Open "dsn= ;uid= ;pwd= ;"

trConn= "DNS=; User ID=; Pwd=" '
strConn = "Provider=OraOLEDB.Oracle;Data Source=; ID=; Password="
Set Conn = Server.CreateObject("ADODB.Connection")

Nota: Me marca error en el TNS :roto: