RE: [PHP-INST] Linux/iodbc connection problems

Klaus, The ODBCINI envrionment variable isn't set to the /path/to/openlink/bin/odbc.ini or there are permission problems on that file (either group read, or the user you started apache on cannot see it). The error indicates that the driver manager (libiodbc) cannot find the odbc.ini file. Verify that the env is set properly - the openlink.sh variables should all be applied: 1. before you start oplrqb (server side, not needed on client) 2. before you start apache then: putenv("ODBCINI=/path/to/openlink/bin/odbc.ini"); putenv("ODBCINSTINI=/path/to/openlink/bin/odbcinst.ini"); putenv("LD_LIBRARY_PATH=/path/to/openlink/lib/and/any/needed/database/lib/di rectory"); echo these in your script to verify. If they are set properly then it's permissions on your openlink stuff. Hope this helps. If you would like, you may open a free tech support case at http://www.openlinksw.com/suppport/suppindx.htm Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Klaus Haberkorn [mailto:hk@hknets.de] > Sent: Thursday, November 16, 2000 4:16 PM > To: php-install@lists.php.net > Subject: [PHP-INST] Linux/iodbc connection problems > > > I installed php3/iodbc/openlink-multi-tier-drivers on an apache > webserver on > SuSE Linux 6.4. > Everything runs fine from the test programs 'odbctest' and > 'udbctest'. I can > query SQL-tables on a NT MSSQL7-Server. > When I try to connect from a php3-script, I get this message: > > Warning: SQL error: [SOFTWARE AG][ODBCLIB A]Data source name not found and > no default driver specified., SQL state IM002 in SQLConnect in > /usr/web-hk/test/test2.php3 on line 31 > can not connect to DSN: DSN=MSSQL7 > > I set all of the necessary variables with 'putenv()' and when I run a > 'phpinfo()' in the same script, the environment variables are shown with > their correct values. > > Can anybody tell me what´s wrong? > > Klaus Haberkorn > hk@hknets.de > > > > > -- > 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 > > >