RE: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2?

Doug, You can try --with-iodbc if you like, there is a howto at www.iodbc.org. That being said, I think that you simply need to set LD_LIBRARY_PATH to the location of your ODBC SDK, so the .h files can be found. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server -----Original Message----- From: Doug Smith [mailto:doug.smith@nth-dimension.com] Sent: Thursday, August 08, 2002 9:38 AM To: php-general@lists.php.net Subject: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2? well.... i figured i'd try it... i run $ ./configure i386-redhat-linux --sysconfdir=/etc --with-unixODBC=shared --with-apxs=/usr/ sbin/apxs $ make clean $ make install which returns this aweful mess :/ Making install in odbc make[2]: Entering directory `/home/doug/php-4.2.2/ext/odbc' make[3]: Entering directory `/home/doug/php-4.2.2/ext/odbc' /bin/sh /home/doug/php-4.2.2/libtool --silent --mode=compile gcc -I. -I/home/dou g/php-4.2.2/ext/odbc -I/home/doug/php-4.2.2/main -I/home/doug/php-4.2.2 -I/u sr/i nclude/apache -I/home/doug/php-4.2.2/Zend -I/home/doug/php-4.2.2/ext/mysql/l ibmy sql -I/usr/local/include -I/home/doug/php-4.2.2/ext/xml/expat -DLINUX=22 -D EAPI -DEAPI_MM -DEAPI_MM_CORE_PATH=/var/run/httpd.mm -I/home/doug/php-4.2.2/TSRM -g -O2 -prefer-pic -c php_odbc.c && touch php_odbc.slo In file included from php_odbc.c:37: php_odbc.h:120:17: sql.h: No such file or directory php_odbc.h:121:20: sqlext.h: No such file or directory make[3]: *** [php_odbc.slo] Error 1 make[3]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' make[2]: *** [install-recursive] Error 1 make[2]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' make[1]: *** [install-recursive] Error 1 make[1]: Leaving directory `/home/doug/php-4.2.2/ext' make: *** [install-recursive] Error 1 how do i let php know where the sql.h / sqlext.h files are? TIA -- any ideas are appreciated. ___________________________________________________ "Doug Smith" <doug.smith@nth-dimension.com> wrote in message news:20020808133331.45588.qmail@pb1.pair.com... > can i use --with-unixODBC instead of --with-ibm-db2? > > I've had a lot of trouble getting php to talk to IBM DB2 (see > comp.databases.ibm-db2 for more info [if you want], ref "DB2 / PHP / > Redhat -- Tried Many Suggestions") > > But, I can get unixODBC to work with DB2, no problem (via the isql command, > so i've got the .odbc.ini and odbcinst.ini all set) > > So, if I compile php --with-unixODBC and _not_ --with-ibm-db2 --- will i be > able to make requests to the database using the unified ODBC commands in > php -- i.e. > $connection = odbc_connect('database','user','password'); > and $result = odbc_exec($connection, 'SELECT a, fine, brew FROM thefridge'); > > or do i still need to compile --with-ibm-db2 ?? > > Thanks :) > > -Doug Smith > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php