|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 23rd, 2005, 06:27 AM
|
||||
|
||||
|
PHP & Oracle: use TNS_ADMIN instead of whole connection string?
Hi all
I have to connect to our Oracle 9i database using PHP4. I can connect to it using Code:
$conn = ocilogon("USER","PW","(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=pub.diso.ch)(PORT=1521)))(CONNECT_DATA=(SID= DBNAME)))");
but I'd like only to use the synonym specified in our TNS_ADMIN configuration file, like Code:
$conn = ocilogon("USER","PW","DBNAME");
Unfortunately this does not work, although I can connect without a problem using SQL*PLUS with the synonyme! Could it be that PHP is not able to look after the TNS_ADMIN config file? Or where else could the problem be? Thank you for help! Josh
__________________
God, you gave man penis and brain, but only enough blood to run one at a time.  my webpage: www.josh.ch my current project: phpmywebmin.josh.ch - a browser based file management application for webspace
|
|
#2
May 23rd, 2005, 07:24 AM
|
||||
|
||||
|
tnsnames.ora?
__________________
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)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > PHP & Oracle: use TNS_ADMIN instead of whole connection string? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
