|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 8th, 2005, 04:17 AM
|
|||
|
|||
|
User & pass in tnsnames.ora
Hello all,
I have a ms-access front-end with Oracle ODBC tot a Oracle 9 database. I want to hard code the username & password for the odbc connection. Is it possible to do in the tsnames.ora file? Does ne1 have some samples or ideas how to? Manny thanx.. Patric Netherlands.
|
|
#2
June 8th, 2005, 07:03 AM
|
||||
|
||||
|
I don't know exactly, and unfortunately I don't have an oracle connection at hand, but you might be interested in Implementing Windows Authentication for Oracle
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
June 8th, 2005, 06:02 PM
|
|||
|
|||
|
Hello,
In tnsnames.ora u can only specified the name of the schema, IP address and listner. I have no idea about "ms-access " but in D2k there is a concept of on-logon trigger where u can specified the username and passwd. Try to findout similar type of concept in "ms-access ". thanks Quote:
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > User & pass in tnsnames.ora |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
