Oracle Database Interaction Using ODP.NET and ASP.NET: All Possible Ways To Get Connected - Connecting to Oracle using .NET Framework Data Provider for ODBC
(Page 3 of 6 )
The .NET Framework Data Provider for OLE DB requires the installation of MDAC 2.6 or later, but MDAC 2.7 is recommended by Microsoft. It uses a native ODBC Driver Manager (DM) through “COM interop” to enable data access. To use the .NET Framework Data Provider for ODBC, you must use an ODBC driver.
All classes for “.NET Framework Data Provider for ODBC” are located in the System.Data.Odbc namespace. If you are using .NET Framework 1.0 (or Visual Studio.NET 2002), you need to download and install the provider (which is not provided by default) from http://msdn.microsoft.com/downloads.
Now we shall test an example for connecting to and accessing data from an Oracle database using .NET Framework Data Provider for ODBC.
Imports System.Data.Odbc
.
.
Dim cnAs New OdbcConnection("Driver={Microsoft ODBC for
Oracle};Server=ORCL;Uid=scott;Pwd=tiger;")
Try
Dim da As New OdbcDataAdapter("select * from
scott.emp", cn)
Dim dt As New OleDbData
da.Fill(dt)
da.Dispose()
Me.DataGrid1.DataSource = dt
Me.DataGrid1.DataBind()
dt.Dispose()
Cath ex As Exception
Me.lblError.Text = ex.Message
Finally
If cn.State = ConnectionState.Open Then
cn.Close()
End If
End Try
The explanation for the above code is very similar to that of the previous section (mainly, I replaced all “oledb” with “odbc” everywhere). But you need to take extreme care with the “connection string” I specified above. Another issue is that, you need not create any DSN (the old traditional way to access from ODBC) within the ODBC manager to run the above code! The above example is demonstrated in “webform4” of the downloadable.
Next: Connecting to Oracle using the .NET Framework Data Provider for Oracle >>
More ASP.NET Articles
More By Jagadish Chaterjee
/ 18 
