DBA Tools

How AnySQL connect to Oracle database?

    AnySQL is a command line database interface tools wrote in Java, just like Oracle's SQL*Plus, but connect to the database via JDBC. There are 3 connect methods available.     The default method is Oracle JDBC Thin driver,...

Posted on December 13, 2007 10:11 AM

How Perl or asyncdata connect to different databases

    Perl is very popular programming language for DBA scripts and tools, following are the code of how to connect to different database with DBI. There is something special for the DBD-Sybase driver. DBI->connect('DBI:Oracle:tnsname', $user, $pass); DBI->connect('DBI:mysql:database=;host=;port=', $user, $pass);...

Posted on September 14, 2007 2:20 PM