php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #4608 Unable connect Oracle DB via ODBC
Submitted: 2000-05-26 13:33 UTC Modified: 2000-10-02 19:06 UTC
From: mcader at eragsm dot com dot pl Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.0 Release OS: Win NT
Private report: No CVE-ID: None
View Developer Edit
 [2000-05-26 13:33 UTC] mcader at eragsm dot com dot pl 
Hi,
I have a problem when i try to use odbc connection to Oracle.
The problem is:
Warning: SQL error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name, SQL state 08001 in SQLConnect in <file name>

ODBC configuration is ok :-)

odbc_connect works ok with M$ Access DB, doesn't work with Oracle

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-06-20 11:53 UTC] kara at cvs dot php dot net 
This is an oracle issue, make shure your odbc drivers are
correctly set up
 [2000-06-20 14:18 UTC] mcader at eragsm dot com dot pl 
The computer's configuration is ok.
The same page works correctly with PHP3, doesn't work with PHP4.
I have no idea why!!!

This is test page - very simply, but doesn't work with Oracle and PHP4 - works with M$ Access

<?
   $fcon = odbc_connect("dsnName","user","password",SQL_CUR_DEFAULT);
?>

error

Warning: SQL error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name, SQL state 08001 in SQLConnect in d:\stronahtml\strona\test.php3 on line 10
 [2000-09-04 22:26 UTC] sniper@php.net 
Is this still happening with php4.0.2 ?

--Jani
 [2000-10-02 19:06 UTC] sniper@php.net 
No feedback.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Wed Jun 17 18:00:02 2026 UTC