Then it doesn't belong on the MySQl list, does it? Norris, Joseph wrote:
>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. >> > > --------------------------------------------------------------------- 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