PHP 4.0 Bug #4648: odbc and oci8 can't link to dbase

From: Date: Sun, 28 May 2000 01:25:24 +0000
Subject: PHP 4.0 Bug #4648: odbc and oci8 can't link to dbase
Groups: php.dev 
Request: Send a blank email to php-dev+get-19624@lists.php.net to get a copy of this message
From: znsoft@sy163.net Operating system: windows 98 PHP version: 4.0.0 Release PHP Bug Type: ODBC related Bug description: odbc and oci8 can't link to dbase <?php ////////////////////////////////////////////////////////////////////////////////// //ԭʼÎļþÃû£ºodbc.php4 //×÷ Õߣºmayong //ÈÕ ÆÚ£º //Óà ;£ºodbc tester ///////////////////////////////////////////////////////////////////////////////// $conn = odbc_connect("xxcx", "xxcx", "xxcx"); $query = "select userid,sortid from subscibe"; $result_id = odbc_do($conn, $query); while(odbc_fetch_row($result_id)) { $user = odbc_result($result_id, 1); $idno = odbc_result($result_id, 2); echo $user."µÄÉí·ÝÖ¤×ÖºÅΪ".$idno."<br>\n"; } odbc_close($conn); ?> //above is odbc linking Threr is a DSN of name "xxcx" in odbc of my machine. this file is renamed to odbc.php3 ,it can normal running! error information after run above script: Warning: SQL error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name, SQL state 08001 in SQLConnect in e:\my\odbc.php4 on line 9 <?php /* OCIDefineByPos example thies@digicol.de (980219) */ $conn = OCILogon("XXCX","xxcx","xxcx"); $stmt = OCIParse($conn,"select * from reguser where userid='znsoft'"); /* the define MUST be done BEFORE ociexecute! */ OCIDefineByName($stmt,"USERID",&$empno); OCIDefineByName($stmt,"PASSWORD",&$ename); OCIExecute($stmt); while (OCIFetch($stmt)) { echo "empno:".$empno."\n"; echo "ename:".$ename."\n"; } OCIFreeStatement($stmt); OCILogoff($conn); ?> //above is oci8 linking this file is renamed to test.php3 ,it can normal running! error information after run above script Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in e:\my\test.php4 on line 5 //a part of php.ini file ;Windows Extensions ;extension=php_sybase_ct.dll ;extension=php_mysql.dll ;extension=php_nsmail.dll ;extension=php_dbase.dll ;extension=php_filepro.dll ;extension=php_dbm.dll ;extension=php_mssql65.dll ;extension=php_mcrypt.dll ;extension=php_msql2.dll ;extension=php_odbc.dll extension=php_exif.dll ;extension=php_swf.dll extension=php_ftp.dll extension=php_calendar.dll extension=php_oracle.dll extension=php_gd.dll extension=php_zlib.dll extension=php_imap.dll extension=php_ldap.dll extension=php_java.dll extension=php_oci8.dll ;;;;;;;;;;;;;;;;;;;

« previous php.dev (#19624) next »