You must Sign In to post a response.

connection string for oracle in VB.NET

In VB.NET application i need to accesss a database located in another machine's Oracle server.

The details of Oracle server are:
dsn:emr(System DSN)

I use Microsoft ODBC for Oracle driver.Can anyone help with the connection string.


Author: Ultimaterengan09 Jul 2008 Member Level: Gold   Points : 1

Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes"


dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev"
i hope this may help u

Author: Pavan Ravi09 Jul 2008 Member Level: Gold   Points : 4

if u are using oracle data adapter use this string

dim OraStr As String = "User ID=scott;Data Source=testdb; Password=tiger"

other than oracle adapter (like Oledb or ODBC)

dim OraStr As String = "Provider=MSDAORA.1;User ID=scott;Data Source=testdb;Password=tiger"

Author: Bunty09 Jul 2008 Member Level: Gold   Points : 2


Dim con As String="provider=msdaora.1;user id=scott;password=tiger";

Thanks and Regards

Sign In to post your comments