Re: NT4, IIS (CGI), and Oracle8

Kevin McLaughlin wrote: > I have installed PHP4.0.2 (CGI) on an NT Server (SP5) with IIS4. I can > access MySql databases through the native MySql support in PHP4, as well as > through ODBC, but the database I really need to access is Oracle 8.0.5. > > Whether I use ODBC or OCI8, I get ora-12154, TNS:could not resolve service > name. I can access the same Oracle8 Database using sqlplus, and MS Access, > so I know that TNS and ODBC are set up right. > > Has anyone got Oracle8 working with PHP4, IIS4 on NT4 (SP5)? Any help would > be appreciated. In order to get the oci8 extension working, you should install Oracle Client 8.1.6 on your web server. The oci functions are compiled specifically for the 8.1.6 client. You can use this latest client to connect to any database server you like, but the client itself needs to be 8i. If you still have troubles after setting up the 8.1.6 client, let me know and we'll work it out :) -- Andy Hoffman Web Developer Bristol-Myers Squibb email: andy.hoffman@bms.com