Windows 2000 client Oracle8i 8.1.6.0.0

[netelf]

I have an Apache web server running on windows2000 with php. I'm using the php_oracle.dll, but the only time I can connect with the Oracle DB with success is the first time I run the script after the Apache started. After that I always get a "ORA-12154: TNS:could not resolve service name".
I tryed to use an ODBC connection, but I can't access a result set from a query!

Any ideas?

thanks.

[Anon]

This error basically means that the database name you are trying to connect to cannot be resolved.

How is the Oracle client and database set up regards name resolution. Are you using TNSNAMES.ORA or Oracle Names or some other mechanism.

Have you got SQL*Plus on the webserver box and if so can you connect to the database from it.

Regarding ODBC on Oracle 8.1.6 - this is very flakey on this version, I would advise you to avoid it or use a third party ODBS driver if you must use ODBC.

Regards,

Fes