Re: can i use --with-unixODBC instead of --with-ibm-db2?

Doug, You need an ODBC SDK - you should be able to find the libs in UnixODBC or simply use iODBC from www.iodbc.org 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 10:11 AM To: Andrew Hill Subject: Re: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2? Thanks for the suggestion. I tried issuing the command # export LD_LIBRARY_PATH=/usr/IBMdb2/V7.1/include/ (which is where i found sql.h and sqlext.h to be living) Before I ran "make install" but, unfortunately it came up with the same errors. Well... Maybe it is time I head back to the drawing board.... and checkout iodbc -- thank you very much, I appreciate it. -Doug Smith "Andrew Hill" <ahill@openlinksw.com> wrote in message news:03f101c23eea$986d8960$eb0ba8c0@usnet.private... > 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 > >