PHP4 and Oracle 8.0.5/WinNT

>Hello! > > >The machine situation is a Windows NT 4 server with IIS 4, and the >server is running an Oracle 8.0.5 database. > >PHP3 had no problems connecting to the database, nor had it any problems >connecting to external databases. PHP4, enter the scene. I suppose you are running PHP 4 as CGI and are using the binaries compiled by Daniel B. >No more >connections. Always the good old "TNS:could not resolve service name". I have been using PHP 4, IIS 4 with Oracle 8.0.5 until two months ago. And I found that PHP 4 will not connect through Oracle 8.0.5 if you are running as CGI. As soon as you switch to ISAPI (which is a great performance improvement with Oracle anyways!) it will connect. >I've browsed through all the messages in here, and everything point on >one thing - upgrade to Oracle 8.1.6. And this will be a problem... I >need to stay on Oracle 8.0.5 as that will be the situation once the >application is put in production. Yes and if you upgrade to Oracle 8.1.6 it will also again connect as CGI. Now I think this is actually really weird. PS: Why are you not using the OCI interface? Good Luck, Florian -- Florian Clever fc@clever-soft.com http://www.Clever-Software-Solutions.de/ PGP Key @ ldap://certserver.pgp.net/ A bug in the hand is better than one as yet undetected.