Consultrar Base de Datos Oracle

Hola que hay,

Por si la cadena de conexión está mal montada, te paso una lista de formas
de conectarse a Oracle:

ODBC


New version:

"Driver={Microsoft ODBC for
Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"



Old version:

"Driver={Microsoft ODBC Driver for
Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"



OLE DB, OleDbConnection (.NET)


Standard security:

"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
Id=Username;Password=asdasd;"



Trusted Connection:

"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"



OracleConnection (.NET)


Standard:

"Data Source=MyOracleDB;Integrated Security=yes;"
This one works only with Oracle 8i release 3 or later
Specifying username and password:

"Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated
Security=no;"
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:

C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open();



VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()



Missing the System.Data.OracleClient namespace? Download .NET Managed
Provider for Oracle >>
Great article! "Features of Oracle Data Provider for .NET" by Rama Mohan G.
at C# Corner
Core Labs OraDirect (.NET)


Standard:
"User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0;Max
Pool Size0; Connection Lifetime=0"

Un saludo
Braulio
/// --
/// Braulio Díez
/// Desarrollador C#
/// Málaga - España
// --


"Luis Roberto" escribió:

Estoy usando VS 2003.
Trato de consultar una base de datos de ORACLE así:


Dim x As New OracleConnection("Data Source=ijd;User
ID=curso;password=curso2")

esta línea si la acepta, pero cuando trato de abrir la
base

x.Open()

me marca el siguiente error

Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details: System.EntryPointNotFoundException: ?

Source Error:

Line 392: Dim x As New OracleConnection("Data
Source=ijd;User ID=curso;password=curso2")
Line 393:
Line 394: x.Open()
Line 395: x.Close()
Line 396:

Lo curioso es que con el explorador de servidores puedo
ver la base de datos y pasearme por las tablas y ver todo
lo que hay alli.

No entiendo que pasa...
De antemano muchas gracias y saluos a la comunidad.