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
