By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,280 Members | 2,244 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,280 IT Pros & Developers. It's quick & easy.

oracle db connectionstring problem

P: 79
What's the connectionstring to connect to the Oracle9.0 Database Server irrespective of servername,username and password using VB.Net2002 (.Net framework 1.0)? In case of Microsoft SQL Server the connectionstring is something like "Provider=MSOleDB4.0;server=localhost;data source=pubs;Integrated Security=SSPI".

'Server=localhost' allows the front-end application to identify the database server irrespecive of servername. 'Integrated Security=SSPI' allows the front-end application to connect to the database irrespective of username and password.

I'm looking for the Oracle counterpart of the connectionstring.
In case of oracle I'm writing this:
"Provider=MSDAORA 4.0, Server=Self, Username=scott, password=tiger"

It works properly but I wanna avoid writing that (servername=Self, Username=scott, password=tiger) b'coz it's static. What if somebody changes the servername from Self to Selfish or password from tiger to lion at a later time? I'll hav to change the core code again and again. Wut's the option to write the connectionstring irrespective of them?
Sep 27 '07 #1
Share this Question
Share on Google+
1 Reply

Post your reply

Sign in to post your reply or Sign up for a free account.