RE: [PHP] php/Oracle db connection
| From: | Andrew Hill | Date: | Thu, 25 Oct 2001 21:03:03 +0000 |
| Subject: | RE: [PHP] php/Oracle db connection | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72349@lists.php.net to get a copy of this message | ||
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
>
>
>