Re: Oracle ODBC Connection Environment

Woods Ron Contr SA-ALC/FMIS wrote: > I am using php.exe version 4.0.2 (as cgi) on a WinNT > server (SP6a) running IIS. I am unable to connect to an > Oracle 8 database running on a Solaris 8 platform via > ODBC. I have tried both the Oracle ODBC driver version > 8.00.59.00 and the MS Oracle ODBC driver with the same > results (ORA-12154: TNS:could not resolve service name). What version of the Oracle Client do you have installed on the web server? If you are using Oracle 8i (client 8.1.6) you can connect using the PHP_OCI8 extension. This extension is available with php4.0.2 (and above) from www.php4win.de. Also, you might try adding the env. variable "TNSADMIN"... this env var should point to the directory where your tnsnames.ora file resides. And as a final check, make sure your "extension_dir" setting in php.ini uses only front-slashes and not back-slashes - this one is a 50-50 shot, but some php database extensions (specifically oracle) like to see front-slashes instead of back-slashes in directory names. -- Andy Hoffman Web Developer Bristol-Myers Squibb email: andy.hoffman@bms.com