PEAR Oci8 connection

[lrargerich]

Hi,

I need an example of a PHP script connecting to an Oracle database running in another machine.
I know the user, password, SID, schema and hostname but can't find how to build a working DSN to connect using PEARDb.
I get an error "No such database" in almost all my attempts.

Thanks in advance.

[steved]

I use a format like this:

$DSN = oci8://username:password@protocol+hostspec/database

[steved]

Not sure why it threw it in there, but the smiley face should be a colon (🙂.