PHP4 + Oracle 8.0.5

Anon

Hello,

I have Oracle client 8.0.5 + PHP 4 + Apache Server on Win NT and I can not connect to Oracle Databases using PHP.
I've included
extension=php_oci8.dll
extension=php_oracle.dll

the ORACLE_HOME is set to C:\orant

but the error that I received is :
Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in c:\a...

Thanks,
Camelia

Anon

putenv('ORACLE_HOME=c:\orant');

Anon

Hi.
ORA-12154 or TNS-12154 means that your workstation could not resolve service name.
Check your entry in:
C:\orant\net80\admin\tnsnames.ora file

it looks like:

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)

where hostname is the name of the host where database is installed SID is the identifier of the instance (on unix/linux in environment as variable ORACLE_SID)
Use your service name to connect as follows:

OCILogon("scott","tiger","ORCL");

Regards from Poland, Marek.

Anon

I set everything , but is not working.
Thanks,
Camelia

Anon

Hi,
the tnsnames.ora is OK.
The php3 is working with the same Oracle.
Is something strange .

Thanks,
Camelia

Anon

Dear Camelia

I had the same problem when upgrading
(this happens also with my IIS4)
I managed to solve giving null
for login, like
OCILogon("scott","tiger","")
,but this is working only
when your web-server resides
at the same machine with your
database server.
With php3 I didn't have this problem.
I'm working to find any solution
for this (versions of Oracle Net etc.).
If you have found anything
for this problem, please post a mail.

Thanks for reading this e-mail

Anon

$adminuser="aaaa";
$adminpassword="bbbb" ;
$server_name=" (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
";
$conn=OCILogon($adminuser,$adminpassword,$server_name);

Bill wrote:

Dear Camelia

Thanks for reading this e-mail