On 29-Sep-2006 Stephen More wrote:
> On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote:
>> Stephen. I would try correcting your code which calls bind_param
>> incorrectly:
>>
>> $sth->bind_param(1, \$a ); -> $sth->bind_param(1, $a );
>> $sth->bind_param(2, \$b ); -> $sth->bind_param(2, $b );
>
> I changed my code with:
> $sth->bind_param(1, $a );
> $sth->bind_param(2, $b );
>
> But I am still getting "DBD::ODBC::st execute failed:
> [unixODBC][IBM][iSeries Access ODBC Driver]Error in assignment"
OK, I'll try and get hold of a DB2 ODBC driver and see what I can find.
>> BTW
>> what is with all those "my( $a ) = 1;" statements? You don't need the ().
>
> I know they are not needed...This was a company coding standard that
> was put in place and I have been following it ever since :-)
>
>> and why do "$ENV{PERL_DL_NONLAZY}=1;"?
> This is left over from a previous problem...actually you told me to try it.
> In May of 2005 I was getting a seg fault:
> http://www.codecomments.com/archive237-2005-5-498915.html
:-) That was a method to see if your unixODBC had been built right - the
solution if PERL_DL_NONLAZY fixed it was to rebuild unixODBC. However, that is
up to you.
>
> -Thanks for you assistance
> Steve More
Do you know where I can get the DB2 ODBC driver for Linux. I have not got a rpm
based system but I could probably unpack the rpm and manually install it.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
