We won't let you twist forever...But the standard reply is Read The Fine (F..ing) Manual (RTFM). But in a nutshell you must have Perl, DBI, DBD-Oracle, Sqlnet (really all of Oracle client software, ask your DBA for help), all installed on the client machine (i.e. the machine upon which you intend to run your perl script). You must BEFORE YOU USE DBI be able to connect to the target database from the client machine with a client side app such as SQLPLUS (again ask your dba).
Once you can, read the DBI readme, and DBD-Oracle doc, together they have all you need (though no one wants to make the effort). Lastly, here is sorta what your script will look like: use DBI; my $userid = "jstrauss"; my $passwd = "smile"; my $tnsname = "an entry in your tnsnames.ora file"; my $dsn = "dbi:Oracle:" . $tnsname; print "$dsn\n"; my $dbh = DBI->connect($dsn,$userid,$passwd) || die "your dead\n"; # you'll have to read the DBI readme files for your logic # its a learning experience :) $dbh->disconnect; ----- Original Message ----- From: "Nicolas M�nant" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 18, 2002 2:41 PM Subject: Use a script perl to connect to SqlNet server Hi, i'm a student and a company asked me to build a perl script which will test an oracle Database through the SqlNET server... It seems that i can use the perl module DBI with a DBD oracle driver.... does anyone have an url with good tutorials on??? Thanks a lot for your answer!! Nico _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
