Proper Oracle connection syntax

[Robert Walker]

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?

[Paladine]

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.

:cool: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?