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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: mcader at eragsm dot com dot pl
New email:
PHP Version: OS:

 

 [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 20:00:01 2026 UTC