i changed prepare to include an option solved the problem

my $sth = $db->prepare( $sql, { odbc_exec_direct => 1})

i am creating a script to refresh devlopment database from production.

it will be called from a front end screen that lists source/target server and developer can refresh any dev database

thanks . i see the backup type.