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]
