Posted by tg-php on 08/11/05 21:52

Yeah, you can connect to Oracle remotely. The standard PHP functions should do it probably, but I've done it using ADODB.

I don't know if this is the same on a *nix box, but I was running PHP on a Windows box and needed special Oracle stuff installed on my machine to connect to the Oracle DB. There's a file..something like "tsnames.ora" that has the database information. Sort of like their version of ODBC. You give it an aliased name, then give it all the server info, then when you connect to Oracle, you give it the name that's entered into "tsnames.ora" (or whatever the file is) and the username/password combo.

Maybe that'll give you a nudge in the right direction.

Good luck! Let us know what you find!

-TG

= = = Original message = = =

Hi,

Can PHP connect to a remote Oracle db?
Because all oracle connecting functions only require 'user' and 'pass'

http://us3.php.net/manual/en/function.oci-connect.php
http://us3.php.net/manual/en/function.ora-plogon.php

Thanks,
Regards,
pancarne.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

[Back to original message]