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:
------------------------------
server'same:\\orcl
username=developer
pwd:dev
dsn:emr(System DSN)

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


Comments

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

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"


http://www.daniweb.com/forums/thread26939.html
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

Hi,

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

Thanks and Regards
S.S.Bajoria