-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: venkat_kl
Message 5 in Discussion
hi, this may help u Oracle .NET Data Provider - From Microsoft
System.Data.OracleClient
The Microsoft .NET Framework Data Provider for Oracle is an add-on component to
the .NET Framework 1.0 that provides access to an Oracle database using the
Oracle Call Interface (OCI) as provided by Oracle Client software.
Oracle 8i Release 3 (8.1.7) Client or later must be installed for this provider
to function correctly.
Note: This .NET Data Provider is included in version 1.1 of the .NET Framework.
You need only download this, if you are running version 1.0.
Using C#:using System.Data.OracleClient; OracleConnection oOracleConn = new
OracleConnection(); oOracleConn.ConnectionString = "Data Source=Oracle8i;" +
"Integrated Security=SSPI"; oOracleConn.Open();
Using VB.NET:Imports System.Data.OracleClient Dim oOracleConn As
OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "Data
Source=Oracle8i;" & _ "Integrated
Security=SSPI"; oOracleConn.Open()
***************************************************************** Oracle .NET
Data Provider - From Oracle
Oracle.DataAccess.Client
The Oracle .NET Framework Data Provider from Oracle is an add-on component to
the .NET Framework
Using C#using Oracle.DataAccess.Client; ... OracleConnection oOracleConn = new
OracleConnection(); oOracleConn.ConnectionString = "Data
Source=MyOracleServerName;" + "Integrated
Security=SSPI"; oOracleConn.Open();
Using VB.NETImports Oracle.DataAccess.Client ... Dim oOracleConn As
OracleConnection = New OracleConnection() oOracleConn.ConnectionString = "Data
Source=MyOracleServerName;" & _ "Integrated
Security=SSPI"; oOracleConn.Open()
*****************************************************************
For Oracle ODBC Driver' VB.NET Imports System.Data.Odbc ... Dim oODBCConnection
As OdbcConnection Dim sConnString As String = _ "Driver={Microsoft
ODBC for Oracle};" & _ "Server=OracleServer.world;" & _
"Uid=myUsername;" & _ "Pwd=myPassword" oODBCConnection = New
Odbc.OdbcConnection(sConnString) oODBCConnection.Open()
*****************************************************************
For Oracle OLE DB Provider' VB.NET Imports System.Data.OleDb ... Dim
oOleDbConnection As OleDbConnection Dim sConnString As String = _
"Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _
"User ID=myUsername;" & _ "Password=myPassword" oOleDbConnection =
New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open()
****************************************************************** OraDirect
.NET Data Provider - From CoreLab
CoreLab.Oracle
The OraDirect .NET Data Provider is an add-on component to the .NET
Framework that provides access to an Oracle database using the Oracle
Call Interface (OCI) as provided by Oracle Client software.
Using C#using CoreLab.Oracle; OracleConnection oOracleConn = new
OracleConnection(); oOracleConn.ConnectionString = "User ID=myUsername;" +
"Password=myPassword;" +
"Host=(local);" + "Pooling=true;" +
"Min Pool Size=0;" + "Max Pool
Size=100;" + "Connection Lifetime=0";
oOracleConn.Open();
Using VB.NETImports CoreLab.Oracle Dim oOracleConn As OracleConnection = New
OracleConnection() oOracleConn.ConnectionString = "User ID=myUsername;" & _
"Password=myPassword;" & _
"Host=(local);" & _ "Pooling=true;" & _
"Min Pool Size=0;" & _
"Max Pool Size=100;" & _ "Connection Lifetime=0"
oOracleConn.Open()
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
