0

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?

2
Contributors
1
Reply
3
Views
12 Years
Discussion Span
Last Post by Paladine
0

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?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.