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
>>> <[EMAIL PROTECTED]> 03/04/04 09:15AM >>>
>Warning: I am _NOT_ a windows expert, but I am on a Windows XP
machine
>and I have gotten DBI to connect to an oracle database using
DBD::ODBC.
>Do you have an ODBC data source set up on your Win2000 box?
Probably not. Is this anything like configuring the tnsnames.ora on the
unix
side?
As i am googling right now for setting up a ODBC data source, i'm
finding
some good info. I'm gonna go with this and hopefully it will solve the
problems.
It made sense that there was something I had to configure but I just
didn't
know what or where.
Thanks!
Brian
