Member Avatar for 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?

  • 2 Contributors
  • 1 Reply
  • 506 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by Paladine
Member Avatar for 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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.