What's the connectionstrin g to connect to the Oracle9.0 Database Server irrespective of servername,user name and password using VB.Net2002 (.Net framework 1.0)? In case of Microsoft SQL Server the connectionstrin g is something like "Provider=MSOle DB4.0;server=lo calhost;data source=pubs;Int egrated Security=SSPI".
'Server=localho st' 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 connectionstrin g.
In case of oracle I'm writing this:
"Provider=MSDAO RA 4.0, Server=Self, Username=scott, password=tiger"
It works properly but I wanna avoid writing that (servername=Sel f, 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 connectionstrin g irrespective of them?
'Server=localho st' 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 connectionstrin g.
In case of oracle I'm writing this:
"Provider=MSDAO RA 4.0, Server=Self, Username=scott, password=tiger"
It works properly but I wanna avoid writing that (servername=Sel f, 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 connectionstrin g irrespective of them?
Comment