Bug #18491: Oracle/ODBC connection under PHP 4.2.1
| From: | frederic dot puteaux at chello dot fr | Date: | Tue, 23 Jul 2002 13:32:26 +0000 |
| Subject: | Bug #18491: Oracle/ODBC connection under PHP 4.2.1 | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-14878@lists.php.net to get a copy of this message | ||
From: frederic.puteaux@chello.fr
Operating system: Windows 2000
PHP version: 4.2.1
PHP Bug Type: ODBC related
Bug description: Oracle/ODBC connection under PHP 4.2.1
This is test page works with PHP and MySQL, but doesn't work with Oracle 8
and PHP4.
The Oracle configuration is OK. The ODBC configuration is OK.
<?
$myConn =
odbc_connect("MyDSN","MyUser","MyPassword",SQL_CUR_DEFAULT);
?>
Warning: SQL error: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve
service name, SQL state
08001 in SQLConnect in c:\web\cgi\gias\testoracle.php on line 3
I have the same message if i use ADO or if i use a Direct Oracle
connection with ora_logon.
All programs of Oracle, same as SQL*Plus run without problem.
Oracle Version : 8.0.5
Oracle Client Software Version : 8.0.5
PHP version : 4.2.1
Windows version : 5.0.2195 SP2
Oracle ODBC Driver : 8.0.5
I can't use the oci. I have this message :
Unable to load dynamic library : c:/php/extensions/php_oci8.dll - La
procédure spécifiée est introuvable. (don't find the specified procedure)
All others libraries can be loaded without problem.
Sorry for my english.
Fred.
--
Edit bug report at http://bugs.php.net/?id=18491&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=18491&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=18491&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=18491&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=18491&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=18491&r=support
Expected behavior: http://bugs.php.net/fix.php?id=18491&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=18491&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=18491&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=18491&r=globals