I'm trying to connect to an Oracle 10g database through PHP to run some web reports. The server admin has installed Oracle (instant client, it looks like) and enabled OCI8 support in PHP. He says he can connect to the Oracle server through the Oracle client now installed on the web server. He also set up a TNSNAMES.ORA file for me when I ran into my initial connection problems.
I've tried connecting with both Instant Connect syntax and TNSNAMES.ORA syntax to no avail. These are the strings I've used with oci_connect (database names have been changed to protect the innocent):
It looks like you're using my "urlserver" approach. Referencing the variables above, here's what I've attempted. From what you're telling me above, my syntax is fine and it's still a server problem?