RE: Accessing oracle from windows 2000

[brian . barto]

Hardy, I've set up my data source like you suggested and it worked
beautifully! That's all I needed!

Thanks to everyone for helping me!

Thanks,
Brian

-----Original Message-----
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 9:25 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Accessing oracle from windows 2000


Brian Barto may be right, but I haven't yet tried to connect to an
Oracle db using DBD::Oracle.  I'm going to try that hopefully today. 
I'm not quite sure how to install that since on Linux it requires the
Oracle client libraries - not sure if I have those on this WinXP box.

This might help get you started using DBD::ODBC to connect to an Oracle
db:
   * read the perldocs by doing 'perldoc DBD::ODBC' at a command prompt
-
       it explains how to set up your ODBC data source using a
"System"
       DSN.

       If you have trouble with this let me know - it's been a while
but I think
      I can help with this.

  * Once you've set up your ODBC data source, according to
     'perldoc DBD::ODBC' you just name the DSN instead of the Oracle 
    instance/db, like this:

   my $dbh = DBI->connect('dbi:ODBC:system_oracle_dsn',
                          'user_name',
                          'user_password',
                          { RaiseError => 1, PrintError => 1 }
   ) || die "Can't connect: $dbi::errstr";

HTH.

Hardy Merrill