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
