Select Code to Download

Select or download this

# http://www.awilcox.com/geek_stuff/perl/proxy.html
use DBI;
...
$dbh= DBI->connect("DBI:Proxy:hostname=192.168.200.101;port=3522;debug
+=1;dsn=dbi:ODBC:dbtest",'test','test') or die $DBI::errstr;
$sth = $dbh->prepare("select f1,f2,f3 from table1 where f1=1");
$sth->execute;

Select or download this

$VAR1 = {
          'f1' => '1',
          'f2' => 'A123',
          'f3' => 'Vista'
        };

Select or download this

$sth = $dbh->prepare("desc table1");
$sth->execute;

Select or download this

DBD::Proxy::st execute failed: Server returned error: Failed to execut
+e method CallMethod: DBD::ODBC::st execute failed: [Oracle][ODBC][Ora
+]ORA-00900: invalid SQL statement
 (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at C:/Perl/site/lib/DB
+I/ProxyServer.pm line 344.