RE: [PHP-INST] ODBC Openlink Connection problems..

Hi Andrew, Actually, none of the solutions you mention below would have worked. The problem was that the guy compiling PHP used --with-iodbc, instead of --with-openlink ... Regards - Fredrik. "Andrew Hill" <ahill@openli To: <Fredrik.Palm@notes.sema.se>, nksw.com> <php-install@lists.php.net> cc: 2000-12-20 Subject: RE: [PHP-INST] ODBC Openlink Connection problems.. 15:12 Please respond to ahill Fredrik, Unknown Host means either: 1. the Host field in the DSN is not 'pingable' from the client - try changing it to an IP address - verify networking issues and possible permissions 2. there is a mal-formed DSN name. - check your odbc.ini for both [ and ] around the top key and subsequent parameters area - check that the names in [ and ] match exactly in both areas in the odbc.ini - check that php doesn't expect to be passed a slightly differenct connect attribute, eg. "DSN=DSN_Name" instead of "DSN_Name" Please open a free support case at http://www.openlinksw.com/support/suppindx.htm if the problem persists. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Fredrik.Palm@notes.sema.se [mailto:Fredrik.Palm@notes.sema.se] > Sent: Wednesday, December 20, 2000 2:40 AM > To: php-install@lists.php.net > Subject: [PHP-INST] ODBC Openlink Connection problems.. > > > Hi all ! > > I've managed to configure, make and install PHP w. Openlink and the > functions are there alright. But when I try to connect to my DSN set up in > odbc.ini, I get the following error : > > Warning: SQL error: [OpenLink][ODBC]RPC: Unknown host, SQL state 08004 in > SQLConnect in /var/www/html/fpm/connect.php on line 31 > can not connect to DSN: DSN=STFI > > The environment variables are there : > > putenv("LD_LIBRARY_PATH=/usr/local/openlink/odbcsdk/lib"); > putenv("ODBCINSTINI=/usr/local/openlink/bin/odbcinst.ini"); > putenv("ODBCINI=/usr/local/openlink/bin/odbc.ini"); > > and I can successfully print them from my .php page (even before I use > putenv), and the DSN works fine in odbctest supplied with openlink.. > > now I'm stuck !!! .. > > Anyone feel friendly ? > > // Fredrik > > > -- > PHP Install Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-install-unsubscribe@lists.php.net > For additional commands, e-mail: php-install-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-install-unsubscribe@lists.php.net For additional commands, e-mail: php-install-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net