oracle Conexão ASP Oracle

[leo_pirola 0]

Boa tarde prezados.

Comecei a mexer com ASP a pouco tempo e estou com dificuldades de conectar em um banco Oracle.

Alguém pode me ajudar?

Desde já agradeço.

Léo

[xanburzum 169]

Segue os exemplos:

Microsoft OLE DB Provider for Oracle

Standard security

This connection string uses a provider from Microsoft.
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

Oracle

Trusted connection
Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;
Integrated Security=Yes;


Oracle in OraClient11g_home1 connection strings

Standard
Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myUsername;
Pwd=myPassword;

Server SID
Driver={Oracle in OraClient11g_home1};Server=serverSID;Uid=myUsername;
Pwd=myPassword;

Both Server and Dbq
ODBC;Driver={Oracle in OraClient11g_home1};SERVER=[server SID];UID=[userid];
PWD=[password];DBQ=[server SID];

Oracle Provider for OLE DB


Standard Security
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Password=myPassword;


Trusted Connection

This one specifies OS authentication to be used when connecting to an Oracle database.
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;


Oracle XE, VB6 ADO
Provider=OraOLEDB.Oracle;dbq=localhost:1521/XE;Database=myDataBase;
User Id=myUsername;Password=myPassword;


Oracle XE, C++ ADO
Provider=OraOLEDB.Oracle;Data Source=localhost:1521/XE;
Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;