php/Oracle db connection
| From: | toni baker | Date: | Thu, 25 Oct 2001 20:56:27 +0000 |
| Subject: | php/Oracle db connection | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-72347@lists.php.net to get a copy of this message | ||
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