Re: php/Oracle db connection
| From: | Frewuill Rodriguez | Date: | Thu, 25 Oct 2001 21:07:57 +0000 |
| Subject: | Re: php/Oracle db connection | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72348@lists.php.net to get a copy of this message | ||
Check data1.tsl.state.tx.us it I can't even ping it.. try using IP adress
instead or check that name.
----- Original Message -----
From: "toni baker" <tanknank@yahoo.com>
To: <php-general@lists.php.net>
Sent: Thursday, October 25, 2001 4:56 PM
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