Bug #9175

MDB2 Driver Connection to Oracle Database

Details

Submitted	2006-10-26 22:59 UTC
From	dvohra09 at yahoo dot com
Status	Duplicate
Package	MDB2_Driver_oci8
PHP Version	5.1.4
OS	Windows 2000
Roadmaps	(Not assigned)

Comments

[2006-10-26 22:59 UTC] dvohra09 at yahoo dot com

Description:
------------
The MDB2 driver for Oracle has a bug. Because the hostspec gets specified as the service name in the connection descriptor.

PHPOnTrax with the MDB2 driver to connect to Oracle.
Database configuration is:

[development]
phptype = oci8
database = ORCL
hostspec = localhost
username = OE
password = password
persistent = true

Error Message: MDB2 Error: connect failed
for database 'ORCL' on host 'localhost' as user 'OE'
Did you configure file C:/Apache2/Apache2/htdocs/catalog/config/database.ini correctly?

SQLNET log:
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=localhost)(CID=(PROGRAM=C:\PHP\php.exe)(HOST=LAWSON-QOG7GIFF)(USER=Deepak?Vohra)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 26-OCT-2006 15:30:17
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

[2006-10-27 00:24 UTC] dvohra09 at yahoo dot com

If service name is specified in the hostspec parameter, an error gets generated:

Error Message: MDB2 Error: Array

Is the error a PHPOnTrax error or a MDB2 driver error? I have also submitted a bug report to PHPOnTrax.
http://sourceforge.net/tracker/index.php?

func=detail&aid=1585465&group_id=133536&atid=727537