Doug, It may be - I'm a bit more familiar with iODBC.
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:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:14 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2? does this look like the ODBC SDK of unixODBC (not that i expect you to know unixODBC) /usr/lib/libboundparam.so.1 /usr/lib/libboundparam.so.1.0.0 /usr/lib/libesoobS.so.1 /usr/lib/libesoobS.so.1.0.0 /usr/lib/libgtrtst.so.1 /usr/lib/libgtrtst.so.1.0.0 /usr/lib/libnn.so.1 /usr/lib/libnn.so.1.0.0 /usr/lib/libodbc.so.1 /usr/lib/libodbc.so.1.0.0 /usr/lib/libodbccr.so.1 /usr/lib/libodbccr.so.1.0.0 /usr/lib/libodbcdrvcfg1S.so.1 /usr/lib/libodbcdrvcfg1S.so.1.0.0 /usr/lib/libodbcdrvcfg2S.so.1 /usr/lib/libodbcdrvcfg2S.so.1.0.0 /usr/lib/libodbcextras.so.1 /usr/lib/libodbcextras.so.1.0.0 /usr/lib/libodbcinst.so.1 (...it continues) I found this from "$rpm -q --list unixODBC" ... somehow I was under the assumption that IBM DB2 UDB came with a ODBC SDK -- i.e. this stuff... /usr/IBMdb2/V7.1/lib/libdb2ccai.so.1 /usr/IBMdb2/V7.1/lib/libdb2ar.so /usr/IBMdb2/V7.1/lib/libdb2.so /usr/IBMdb2/V7.1/lib/libdb2qp.so /usr/IBMdb2/V7.1/lib/libdb2apie.so /usr/IBMdb2/V7.1/lib/libdb2jdbc.so (which continues as well...) or am i still missing something? thanks again, and thanks for your patience too, i really appreciate it. -doug "Andrew Hill" <[EMAIL PROTECTED]> wrote in message news:043601c23f0c$0d74efc0$[EMAIL PROTECTED]... > 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:[EMAIL PROTECTED]] > 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" <[EMAIL PROTECTED]> wrote in message > news:03f101c23eea$986d8960$[EMAIL PROTECTED]... > > 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:[EMAIL PROTECTED]] > > Sent: Thursday, August 08, 2002 9:38 AM > > To: [EMAIL PROTECTED] > > 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" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED]... > > > 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 > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
