RE: [PHP] php/Oracle db connection

When I run odbctest I get the following prompt: OpenLink ODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): ? DSN | Description --------------------------------------------------------------- Enter ODBC connect string (? shows list): What ODBC connet string should I enter here? Thanks Toni. --- Andrew Hill <ahill@openlinksw.com> wrote: > 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:tanknank@yahoo.com] > > Sent: Thursday, October 25, 2001 4:56 PM > > To: php-general@lists.php.net > > 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: > php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: > php-general-help@lists.php.net > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > php-general-unsubscribe@lists.php.net > For additional commands, e-mail: > php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com