A problem about Oracle connection

[pengyang]

I'm a beginner of php programming.I met a problem about Oracle connection.
We use the function OCILogon() to build a connection with the database,but I don\'t know how to connect with the database on the server?(especially the parameter)

[Anon]

$conn = OCILogon("yourdbusername", "yourdbpassword","yourdbservicename");

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[pengyang]

$conn=OCILogon(""User","Password"£¬(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)(HOST = ¡­¡­)(PORT = ¡­¡­))(CONNECT_DATA =(SID=¡­¡­)))");

What does this mean??

[Anon]

You wrote:

$conn=OCILogon(""User","Password"£¬(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)
(HOST = ¡­¡­)(PORT = ¡­¡­))(CONNECT_DATA =(SID=¡­¡­)))");

That looks like garbled code to me.

The "(DESCRIPTION=...)" portion is garbled code which belongs in your tnsnames.ora file. Normally it would look something like: (don't copy this verbatim since it varies depending on how your Oracle environment is setup)

yourdbservicename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourdbserver.yourdomain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = yourdbSID)
)
)

The '$conn=OCILogon("User", "Password"' is part of the PHP statement to connect to your Oracle database. Normally it looks like:

$conn = OCILogon("yourdbusername", "yourdbpassword","yourdbservicename");

While it is possible to substitute the "(DESCRIPTION=...)" in place of the "yourdbservicename", that would mean hardcoding too much information in your PHP files.

If you have an Oracle DBA (or anyone familiar with Oracle's networking products) at your site, I recommend speaking with them. He/She should be able to explain things in more site-specific detail than this forum message can go into.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[pengyang]

Thank you very much!