I definitely fixed some problems when using Foxpro in DBD::ODBC in the later/latest versions. However, I do not believe that ActiveState has caught up with me yet. Use search.cpan.org searching for DBD::ODBC to check the changes information and compare that with the version you are running now. I *know* there's a line about finally fixing Foxpro stuff...
I suggest getting the latest and the *latest* binary is on: ftp://ftp.esoftmatic.com/outgoing/DBI Get *both* DBI and DBD::ODBC if you use my binaries. They are a pair. Better yet, if you have a compiler, build the latest yourself which is version 0.45_15. Regards, Jeff > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > Norris, Joseph > Sent: Wednesday, August 21, 2002 2:35 PM > To: 'Gerald Clark'; Norris, Joseph > Cc: Mysql_List (E-mail); Perl Database (E-mail); Perl Web (E-mail); Perl > Win32 Users (E-mail) > Subject: RE: Not sure which list to use - this is a real strange one > with ODBC > > > Agreed except in this case what I have to read is a FoxPro database - > (yuck!) > > -----Original Message----- > From: Gerald Clark [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 21, 2002 11:28 AM > To: Norris, Joseph > Cc: Mysql_List (E-mail); Perl Database (E-mail); Perl Web (E-mail); Perl > Win32 Users (E-mail) > Subject: Re: Not sure which list to use - this is a real strange one > with ODBC > > > Why use odbc when native drivers are available? > > Norris, Joseph wrote: > > >Groups, > > > >I have this snippet of code: > > > >$dbh = DBI->connect( "dbi:ODBC:${db_name}", "$user", "$pass") > > or &DoError("Unable to connect: $DBI::errstr"); > > > >#$dbh->debug(2); > > > >$fsql = qq!select empl_no_a, user_ln, user_fn, user_mi, aka, > > longname_a, longname_b, longname_c, useaka from activeempsinfo!; > > > >$db_action = $dbh->prepare($fsql); > >$db_action->execute or &DoError("could not do $fsql - $DBI::errstr "); > > > >The resource is set up for odbc as a system dsn it is setting on another > >drive and I have a batch file running the script that contains the code > >above which does the following: > > > >@echo off > >net use h: /delete > >net use h: \\mcdsssql\hrdata > > > >Then runs my script. > > > >OK - here is the problem: > >the execute above dies with the following error: > > > >panic: dbd_error on bad handle type at update_from_hr.pl line 48. > > > >However when I allow the debug statment above - it spews all of its debug > >infor and the script finishes successfully and updates what it > is supposed > >to. > > > >ANY IDEAS?????? - very perplexing. > > > >Thanks. > > > > _______________________________________________ > Perl-Win32-Database mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php