dbTalk Databases Forums  

DBD::Informix -1820

comp.databases.informix comp.databases.informix


Discuss DBD::Informix -1820 in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Clive Eisen
 
Posts: n/a

Default DBD::Informix -1820 - 12-24-2010 , 06:35 AM






I'm using DBD::Informix and mod_perl and was having a problem with a
-1820 error (-1820: Host variable type has been changed between fetches
or puts) hitting a particular query on a second or subsequent execute of
a prepared statement.

So I decided to check the DBD build and running the make test I get

t/t93lvarchar.t ..... DBD::Informix::st fetchrow_hashref failed: SQL:
-1820: Host variable type has been changed between fetches or puts. at
/root/.cpan/build/DBD-Informix-2008.0513-jLu21N/blib/lib/DBD/Informix/TestHarness.pm
line 669

Which is what I'm seeing with a fetchrow_array under mod perl

IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.UC8
IBM Informix Dynamic Server Version 11.70.FC1IE
This is perl, v5.8.8 built for i386-linux-thread-multi
Client is on Centos 5.2

under mod_perl I can make the problem 'go away' by re-preparing before
each execute, but that seems to be sub-optimal :-)

Anyone seen anything similar?

TIA

--
Clive

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.