RE: Perl, DBI and DBD-Oracle - Anyone got this to work in perlscript?

[IMCEANOTES-Ian+20Stewart_Great+20Lakes_AirTouch+40AIRTOUCH+5FCONNECT]

        From:   [EMAIL PROTECTED] on 12/26/2000 08:15 AM

        To:     [EMAIL PROTECTED]@SMTP@JVEXCHANGE,
[EMAIL PROTECTED]@SMTP@JVEXCHANGE,
[EMAIL PROTECTED]@SMTP@JVEXCHANGE
        cc:      
        bcc:    

        Subject:        RE: Perl, DBI and DBD-Oracle - Anyone got this to
work in perlscript?

        > I could be wrong, and someone please correct me if I am, but if
your script is running on NT and connecting to an Oracle database on any
platform, you > would use DBD:ODBC because the connect string contains an
ODBC DSN.  If your are running the script on a UNIX box, then DBD:Oracle is
used. In 
        > this case the connect string would contain an entry from the
tnsnames.ora file.


        I connect to an Oracle database running on Solaris from Win2k
regularly using DBD::Oracle:

        my $dbh =
DBI->connect("dbi:Oracle:sid=database;host=hostname;port=1234", $userid,
$passwd) or die "error connecting to database: $DBI::errstr";


        HTH,
        Ian

_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web