Hi,
   I have oralce 8.0 installed on Linux RedHat 9.0, I am trying to use PHP 4.2.2 to connect to Oracle by using ODBC. However, I have one problem, when I try to use odbc_connect I need to provide the DSN (Data Source Name) which I don't know and the SysAdmin does not know either. My question is how can I figure it out? Even though the ODBC package is installed with PHP. Can anyone help me with..I appreicate it

Thanks

Hi dude!
I'm assuming you set this up on your own system?
How do you normally log in to Oracle using sql+?
If you have installed at home, follow from start menu..
START ->
     Oracle-OraHome(whatever version)->
              Configuration and Migration tools ->
                   Administration Assistant
Once opened, the left-hand pane will show Oracle managed objects
 Expand this and Computers and then the icon with your computer name.
Expand Databases and this will show the database name / names you have available

This / these are your DSN names...


Failing that....
Try logging in using a blank string for DSN, sometimes works :)

Simon

Hi,
I have run go-pear.bat and download the PEAR module.
So, now I have create DB.php, PEAR.php, common.php and oci8.php. When i run at browser, it display error msg:
DB ERROR connect failed.

Please advise me which .php file that I need to modify and change?
I use PHP 4.3.4 Oracle 8 IIS 5.0

Thabks in advance,
molly.