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" <[email protected]> wrote in message
news:[email protected]...
> 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: [email protected]
> For additional commands, e-mail: [email protected]
> To contact the list administrators, e-mail: [email protected]
>