[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ar002
Forum Newbie
Posts: 5
Joined: Mon Aug 26, 2002 7:33 pm
Location: Colombia-Barranquilla

[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service

Post by ar002 »

Hello,

excuse me english.

i am a new php user. I am tying to connect to database oracle of my companie by ODBC , but i have the error :

Warning: SQL error: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name , SQL state S1000 in SQLConnect .

the connection is good : i try it with sql net, and is good.
also i try by a visual fox pro program and the same is good.

i dont' know what i have to do.

my environmet is :

apache 1.3.14 on win nt 4.0
oracle 8 on unix.
odbc
php4

what i have to set in the apache or php4 ?.

thanks for your help.

alex rincon

note : This entry to ODBC is been used by others applications without problem. the problem is when i use php.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

does the path statement to the oracle home directory exist in either the user's login script or the environment settings for the effective user under which permissions the script runs?
You may have to add the settings to the webservers "user".
Post Reply