ODBC connection to oracle using PHP

Anon

Hi there,

I have some problem using php4 in ODBC connection to my remote oracle database.

My code is something stated below.
$connect = odbc_connect("DSN", "UID", "PWD");

& I get this error message:
SQL error: [Oracle][ODBC][Ora]Server rejected the connection., SQL state 08004 in SQLConnect

But when I use ASP to do the same thing, it worked.

Is this because of my php configuration setting?

Can anyone advice me on this...

Thanks

Anon

I have the exact same problem.
Just adding more information...

I am running IIS 5 on a Win2000 machine, using php4 to connect to an Oracle DB on a Sun box.

When I try to connect I get the following error, using a dsn with the "Oracle ODBC Driver"...

Warning: SQL error: [Oracle][ODBC][Ora]Server rejected the connection., SQL state 08004 in SQLConnect in lib/h_db.php on line 32

And using a dsn with the "Microsoft ODBC for Oracle" driver, i get...

Warning: SQL error: [Microsoft][ODBC driver for Oracle][Oracle], SQL state NA000 in SQLConnect in lib/h_db.php on line 32

The line this error is thrown on is something like ...

$conn=odbc_connect("My_dsn_name","username","pword");

Get this... The Microsoft ODBC DSN to Oracle works with ASP on this server & the Oracle Driver DSN works with Analysis Services on this server, which makes me very confused why it does not seem to work with php4. In addition, i remember (different time, different servers) trying this with php3 on IIS 4 & PWS and failing, but it may have been a different error message.

I know i should try to use the OCI interface (php_oci8.dll), if i can find it. But it does not seem to come with my php4 win32 distribution. I'd like to try using ODBC. Any body else have ideas?

Ken