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?