Oracle conection with VB.NET

[waldesro]

:omg:How cant I conect with oracle data base with VB.NET?

[Mike Ellison]

You can use the Microsoft OLEDB provider for Oracle with the System.Data.OleDb objects; you can use the Microsoft native provider for Oracle with the OracleClient objects; or you can use Oracle's own .NET provider (I haven't used it so I'm not sure its object library). For OLEDB, you would use something like this code:

Imports System.Data.OleDb

Sub DoSomethingInOracle()
'-- setup a connection string for Oracle
'-- using the Microsoft OleDb provider
Const kConnectionString = _
"Provider=MSDAORA.1;User ID=myUser; Password=myPass;Data Source=myServer;"

Dim conn As OleDbConnection        

Try            
    '--establish the connection
    conn = New OleDbConnection(kConnectionString)            
    conn.Open()            

    '--do something useful with the connection;
    '-- probably setup an OleDbCommand object
    '-- to run a query, or execute a stored
    '-- procedure...

    ...
    
Catch ex As Exception            
    '--do something with the exception
    ...

Finally            
    '--close and dispose the OleDbConnection object
    conn.Dispose()        
End Try        

End Sub