RE: [PHP] php/Oracle db connection

After running openlink.sh and the set command the following variables or set: ODBCINI=/usr/local/src/bin/odbc.ini ODBCINSTINI=/usr/local/src/bin/odbcinst.ini OLDPWD=/home/httpd/html/ronsdev OPTERR=1 OPTIND=1 ORACLE_HOME=/home/oracle/OraHome1 ORACLE_SID=data1 However when odbctest I still get the following error: Enter ODBC connect string (? shows list): DSN=[pc963];UID=test;PWD=test OpenLink: RPC: Unknown host [OpenLink][ODBC]RPC: Unknown host, SQLSTATE=08004 [OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004 Have a nice day.[tbaker@PC963 tbaker]$ /usr/local/src/odbcsdk/examples/odbctest OpenLink ODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): DSN=[pc963];UID=scott;PWD=tiger OpenLink: RPC: Unknown host [OpenLink][ODBC]RPC: Unknown host, SQLSTATE=08004 [OpenLink][ODBC]Connection rejected by data source, SQLSTATE=08004 Any ideas as to what may be the problem. --- Andrew Hill <ahill@openlinksw.com> wrote: > 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 > > > > > > > > > > -- > 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