Here is an awesome site for Connection Strings (under Technology)
MVP
Here is the
ODBC Method:
' 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()
On the MVP site there is a like to an Oracle Add-in for .NET for use...check it out.
Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes"
OR
dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev"
I am using oracle8i but that should be provider shouldn't it? the MSDAORA.1 is for the OLEDB so I assume it is wrong also. Any Ideas?
Offline 
Unsolved 
