How to connect to oracle remotely

Anon

I'm newbie in PHP.

I have problem to connect to my oracle database remotely. I'm using Apache on Win NT. I had setup my oracle client & ODBC connection. I had also configure my php.ini, httpd.conf. When i try to connect to db with my php script, I got an error message stated that "Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name"

Can anyone give me some guideline to make this work??

Thanks.

Anon

I'm new to PHP too, but I believe you need to install and setup SQL*Net/Net8 on the same machine where PHP resides. You only need this client side protocol to talk with your Oracle database - don't install the whole Oracle server!
To configure it, you need to edit the tnsnames.ora file - usually in $ORACLE_HOME/network/admin (Unix side) or some similar location on NT.

The file itself contains the means to define network services so that your client programs (i.e.PHP) can find the Oracle database by a simple name. You need to create a new entry by copying a tcp/ip entry and then changing the name, global_name, hostname and SID/service value for Oracle.

I hope this helps!

Regards,

Rick

Anon

Newbies Unite!
I'm thinking of administering a web database with PHP and MySQL remotely but on Linux OS...do I need SQL*Net/Net8 on the client machine too? Does the client need both PHP and MySQL installed or it that only in the server?
Thanks!
Allen

Anon

You might want to look into how MySQL can be accessed over a network Net8/SQL*Net is for Oracle only. I don't know what MySQL uses, since I've only fiddled with it a little bit.