AW: AW: [PHP] Access to oracle db

which oracle version do you use? if it is 8.x then you should use the OCI-Functions not ora if it is not 8.X then i can't help. ( and you should upgrade :-] ) the tnsnames.ora looks ok try ocilogon("sr_tst" , "sr_tst","ORATEST"); sebastian > -----Ursprungliche Nachricht----- > Von: giupar@sirmione.sodalia.it [mailto:giupar@sirmione.sodalia.it]Im > Auftrag von Parisi Giuliano > Gesendet: Dienstag, 10. Juli 2001 17:49 > An: Sebastian Stadtlich > Cc: 'Php-General (E-Mail) > Betreff: Re: AW: [PHP] Access to oracle db > > > HI, > I use this PHP call to open an Oracle db connection: > > ora_logon("sr_tst@ORATEST" , "sr_tst") > > where user=password=sr_tst and service name is ORATEST . > > My tnsnames.ora contains: > > ORATEST = > (DESCRIPTION = > (ADDRESS = > (PROTOCOL = TCP) > (Host = offida) > (Port = 1525) > ) > (CONNECT_DATA = > (SID = ORATEST) > ) > ) > > Thanks > > Giuliano > > Sebastian Stadtlich wrote: > > > hi > > > > did you specify the third 'optional' parameter? > > OCILogon (string username, string password [, string db]) > > > > db should be your tnsname > > on windows i could not make it without that parameter. > > it should be set as enviroment variable ORACLE_SID, > > but that did not work for me on win( it does on linux ) > > despite that no further configuration was needed by me > after installing > > the > > oracle client > > > > sebastian > > > > > -----Ursprungliche Nachricht----- > > > Von: giupar@sirmione.sodalia.it [mailto:giupar@sirmione.sodalia.it]Im > > Auftrag von Parisi Giuliano > > Gesendet: Dienstag, 10. Juli 2001 17:10 > > An: php-general@lists.php.net > > Betreff: [PHP] Access to oracle db > > > > > > Hi, > > I've installed Apache server and PHP interpreter on Microsoft Windows > > platform. I'm trying to access to Oracle db without results (I've > > installed Oracle client and configured tnsnames.ora file). PHP > > interpreter return following error: > > > > Oracle: Connection Failed: ORA-12154: TNS:could not resolve > > service name > > in ... > > > > I think that Oracle client used by PHP doesn't find tnsnames.ora file > > (I've tryied to move tnsnames.ora file from installation folder to > > another folder and error message doesn't change). > > sqlplus utility, that used the same tnsnames.ora file, > > correctly access > > to oracle db without problem . > > The question is: how can I configure PHP to enable access to oracle db > > via oracle client ? > > Thanks in advantage for any suggestion. > > Regards > > > > Giuliano > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > >