Menu

#2 MDB2 Driver Connection to Oracle Database

open
nobody
None
5
2006-10-26
2006-10-26
Deepak
No

PHPOnTrax with the MDB2 driver to connect to Oracle has a bug. Because the hostspec gets
specified as the service name in the connection descriptor.

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

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.