Upgrade DBD::ODBC to the latest version. The ActiveState repository version is old, so you'll have to look at the archives for how to ftp it from my site.
Jeff > -----Original Message----- > From: Marusic Juraj [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 11, 2002 10:29 AM > To: [EMAIL PROTECTED] > Subject: SELECT from DBF > > > I try to access DBF files (FoxPro DBF). > Using ODBC with System DSN > > my $attr = { > PrintError=>1, > AutoCommit=>0 > }; > my $dbf_dbh = DBI->connect("dbi:ODBC:$system_dsn_name", '', > '', $attr) or > die "Cannot connect to " . $system_dsn_name . "\nError:" . > $DBI::errstr; > > my $sel_cmd = "select count(*) from " . $table_name; > my @dbf_res = $dbf_dbh->selectrow_array($sel_cmd); > > The program crashes when it comes up to the last row in the code. > The message in the command prompt is: > > DBD::ODBC::db selectrow_array failed: [Microsoft][ODBC Driver > Manager] Program t > ype out of range (SQL-S1003)(DBD: describe/SQLBindCol err=-1) at > D:\work\test_pr > e\test2.pl line 121. > And the perl interpreter crash with message > perl.exe has generated errors and will be closed by > Windows. You will need to restart the program. > > Using ADO with System DSN > it produces this output: > > Use of uninitialized value in null operation at > D:/Perl/site/lib/DBI.pm line 535 > .. > DBD::ADO::db STORE failed: at D:/Perl/site/lib/DBI.pm line 535. > does not exist in hash > Can't use an undefined value as an ARRAY reference at > D:/Perl/site/lib/DBD/ADO.p > m line 1467. > Issuing rollback() for database handle being DESTROY'd without > explicit disconne > ct(). > Connection open, destroy at D:\work\test_pre\test2.pl line 0 > > Thanx for any help >
