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