Toni, Note the "Unknown host". Check your odbc.ini for the Host field of the DSN you are using. Ensure it's resolvable. Try an IP address instead maybe.
Also, set the variables in the environment and see if your DSN works in odbctest without PHP in the mix. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: toni baker [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 25, 2001 4:56 PM > To: [EMAIL PROTECTED] > Subject: [PHP] php/Oracle db connection > > > I have successfully compiled php with linked iODBC > driver manager as an Apache shared module. However > when trying to connect php to the Oracle database I > get an error. The error and the sample connection > code is below. > > Warning: SQL error: [OpenLink][ODBC]RPC: Unknown host, > SQL state 08004 in SQLConnect in > /home/httpd/html/ronsdev/putenv.php on line 9 > can not connect to DSN: data1.tsl.state.tx.us > > <? > putenv("LD_LIBRARY_PATH=/usr/local/src/odbcsdk/lib"); > putenv("ODBCINSTINI=/usr/local/src/bin/odbcinst.ini"); > putenv("ODBCINI=/usr/local/src/bin/odbc.ini"); > $dsn="data1.tsl.state.tx.us"; > $user="scott"; > $password="tiger"; > $sql="SELECT * FROM scott.emp"; > if($conn_id=odbc_connect("$dsn","","")) { > echo "connected to DSN: $dsn"; > if($result=odbc_do($conn_id, $sql)) { > echo "executing '$sql'"; > echo "Results: "; > odbc_result_all($result); > echo "freeing result"; > odbc_free_result($result); > } > else { > echo "can not execute '$sql'"; > } > echo "closing connection $conn_id"; > odbc_close($conn_id); > } > else { > echo "can not connect to DSN: $dsn"; > } > ?> > > Can someone help with this? > Thanks Toni > > __________________________________________________ > Do You Yahoo!? > Make a great connection at Yahoo! Personals. > http://personals.yahoo.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
