PERL/DBD error
Posted in 2001
Topics: Clustering, Grid & MACH11
All, Ive got a problem with DBI/DBD against informix that I'm looking into. Environment: Solaris 7 Informix 9.20 ClientSDK 2.1 PERL 5.005 with DBI and DBD built using gcc2.8 We've whittled the testing down to a short script: ##### 1 #set database requirements 2 use DBI; 3 use DBD::Informix; 4 5 #set environment variables 6 require "/h/MAPSRV/import/env.pl"; 7 8 #set data warehouse path if no argument set in command line 9 10 $|=1; 11 12 $dbh = DBI->connect('dbi:Informix:sde','','', 13 {'PrintError'=>3,'RaiseError'=>3}) 14 or die "Could not connect to Informix\\n"; 15 16 $test_query1 = "select count(*) from grid15;"; 17 18 $sth1 = $dbh->prepare($test_query1) or die "Could not execute $t est_query1"; 19 $sth1->execute(); 20 21 $dbh->disconnect; ##### I can step through this (perl -d) and can see the session when the DBI->connect takes place. The $test_query line also seems to take OK. However, when the prepare statement hits, I get the following error: sde-tascdiv3 (8) perl test.pl DBD::Informix::db prepare failed: SQL: -410: Prepare statement failed or was not executed. at test.pl line 18. Turning trace on shows same error and no further clues. If we change the test query to a bogus column name, it does return an error that the column does not exist, so it appears that connections are indeed being made there. We're trying to get set explain on in the perl script, but have not been successfull there yet (probably a syntax thing on that one). The user running this script has priviledges for the database. We are looking at the problem from both the PERL and Informix angles. Any ideas what may be going on here? We're about out of ideas of our own. We're going to try a recompile of DBI/DBD tomorrow, but if you folks have any other ideas, I'd like to hear them. Thanks. -- Alan