Forums » .NET » .NET »

connection string for oracle in VB.NET

Posted Date: 09 Jul 2008      Posted By:: shajahan     Member Level: Silver  Member Rank: 0     Points: 1   Responses: 3

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.


#261379    Author: Ultimaterengan      Member Level: Gold      Member Rank: 8     Date: 09/Jul/2008   Rating: 2 out of 52 out of 5     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

Thanks & Regards
Nothing is mine ,Everything is yours!!!

#261469    Author: Pavan Ravi      Member Level: Gold      Member Rank: 0     Date: 09/Jul/2008   Rating: 2 out of 52 out of 5     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"

Pavan Ravi Kumar.

"Complex problems have simple, easy to understand wrong answers."

#261470    Author: Bunty      Member Level: Gold      Member Rank: 0     Date: 09/Jul/2008   Rating: 2 out of 52 out of 5     Points: 2


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

Thanks and Regards

Thanks & Regards


Post Reply     

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

  • Return to Discussion Forum
  • Start new thread

  • Subscribe to Subscribers
    Active Members
      Last 7 Daysmore...

      Awards & Gifts
      Talk to Webmaster Tony John

      Online Members

      Vaishali Jain
      Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India