Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2001042

[PHP-WIN] Oracle8 ODBC connection From: Ling Wang (LingWang <email protected>)
Date: 04/29/01

Hi Everyone,

I installed the latest PHP (v4.04) and it works fine with ODBC driver
for Microsoft SQL7.0 and Access97 databases. However, I just can't get
it right for Oracle. I tested the ODBC connection for Oracle with VB/ADO
and it works fine. Here are the error messages I am getting when I run

$connection_id = odbc_connect("OracleExample", "scott", "tiger");

Warning: SQL error: [Microsoft][ODBC driver for
Oracle][Oracle]ORA-12154: TNS:could not resolve service name, SQL state
08001 in SQLConnect in

I also tried Oracle ODBC driver and I am getting the following:

Warning: SQL error: [Oracle][ODBC][Ora]Server rejected the connection.,
SQL state 08004 in SQLConnect

I then tried $connection_id = ocilogon("scott", "tiger", "ora0.OFFICE");

I got the following:

Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name

Again, I tested the service name with EasyConfig and SQLPlus. I also
tested ODBC set up with VB/ADO and they all work fine.

Can anyone tell me what went wrong?

Thanks in advance.

Ling Wang 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-windows-unsubscribe <email protected>
For additional commands, e-mail: php-windows-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>