Forums » .NET » .NET »

connection string for oracle in VB.NET


Posted Date: 09 Jul 2008      Posted By:: shajahan     Member Level: Silver    Member Rank: 3463     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:
------------------------------
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.




Responses

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



Thanks & Regards
G.Renganathan
Nothing is mine ,Everything is yours!!!



 
#261469    Author: Pavan Ravi      Member Level: Gold      Member Rank: 149     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"

Regards,
Pavan Ravi Kumar.

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


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

Hi,

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

Thanks and Regards
S.S.Bajoria


Thanks & Regards


Bunty





 
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.



Next : How to achieve Polimorphism in vb.net.can u pls provide sample program also.
Previous : Accessmodifer
Return to Discussion Forum
Post New Message
Category: .NET

Related Messages

Subscribe to Subscribers
Active Members
TodayLast 7 Daysmore...

Awards & Gifts
Talk to Webmaster Tony John
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India