RE: [PHP] php/Oracle db connection

Toni, You need to enter a string of the syntax: DSN=[name of your dsn] Since nothing shows up with a "?" I bet you haven't set your ODBCINI environment variables. Running the openlink.sh against the current shell should do this: . openlink.sh If you are doing it by hand, you need to set: ODBCINI (pointing to the odbc.ini) ODBCINSTINI (pointitng to the odbcinst.ini) LD_LIBARARY_PATH (pointing to the lib directory that contains the libiodbc.so file) DSNs need to be configured in the odbc.ini 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: Friday, October 26, 2001 11:11 AM > To: ahill@openlinksw.com; php-general@lists.php.net > Subject: 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 > > -- > 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 > > >