Re: [PHP4BETA] [PHP4] ODBC Error with IBM db2 With odbc_connect

Hi all Just wanted to comment on Nicks suggestion... So far I have tested unixODBC on the same machine as DB2 server. I use RS/6000 and AIX 4.3.3 so the Driver entry should read in this case Driver = /usr/lpp/db2_06_01/lib/db2.o And don't forget DontDLCLose = 1 because without it isql command core dumps on quit!!!:) Thanks Nick "Nick Gorham" <nick@easysoft.com> wrote in message news:3911AB64.4CEBFFD3@easysoft.com... > LIARD DENIS wrote: > > > Hello, > > > > We success to install IBM db2 V6.1 Cli on a Redhat 6.1 with Apache 1.3.9 > > and PHP4.0RC1. > > > > Before make, we do : export LDFLAG='-L/home/db2inst1/sqllib/lib' > > > > Make Ok > > Hi. > > If you want to go via ODBC... > > It might be worth installing a driver manager (http://www.unixODBC.org) works > with db2 here, and building PHP with that. it will map the ODBC 2 calls in > PHP to the ODBC 3 calls. > > Just as a aside, when you configure odbcinst.ini you need to set a special > flag for DB2 to overcome a problem with the lib and dynamic linking, I have > the entry set as > > [DB2] > Description = DB2 Driver > Driver = /usr/IBMdb2/V6.1/lib/libdb2.so > FileUsage = 1 > DontDLClose = 1 > > and the odbc.ini entry as > > [sample] > Description = Test to DB2 > Driver = DB2 > > You must have the DB2INSTANCE variable set to a configured user, ie > > DB2INSTANCE=db2inst1 > > Check that you can connect via the command line tools before using PHP. > > -- > Nick Gorham > Easysoft > > > -- > PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > For additional commands, e-mail: php4beta-help@lists.php.net > To contact the list administrators, e-mail: php4beta-admin@lists.php.net >