Re: PHP4 and Oracle 8.0.5/WinNT

YESSS! That did it! Thank you Florian!!! And thank you to all you helpful people for your suggestions. I dealt with the tnsnames.ora, tried the oci-calls, and set environment-variables so the swap started working. No success. PHP3 worked fine, but PHP4 refused all the time no matter using ora_logon or OCILogon. Switched over to the ISAPI-module from the www.php.net distribution, and it connected at once using the OCILogon. I guess the uncompability of the CGI-PHP4 with other Oracle-distributions then 8.1.6 is an undocumented feature. :-) Why I've kept up with the ora_logon is just laziness... thats what I started doing the Oracle-connections with. Working on convering all the scripts to oci-calls now. Have a great weekend everyone, and again - Thank You all. Regards, bod Florian Clever wrote: > >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.