Bjorn, I already have DBI installed, so I downloaded DBD-Oracle8.zip from active state, unpacked it, and tried 'ppm install DBD-Oracle8.ppd' - I get this error:
C:\Documents and Settings\hmerrill.000\Desktop\Downloads\Perl\temp_unpack>ppm install DBD-Oracle8.ppd Error: no suitable installation target found for package DBD-Oracle8. ---------------------------------- Any idea what the problem is? I have Perl5.8 subversion 2 on my WinXP box. Thanks. Hardy Merrill >>> <[EMAIL PROTECTED]> 03/04/04 09:30AM >>> Hello, I have perl , DBI and DBD::ORACLE running on a ouple of NT, win2000 and xp machines here. What I do is fairly simple. - install activestate perl 5.8 - download DBD-Oracle8 and DBI packages - install them using "ppm install DBI.ppd" + "ppm install DBD-Oracle8.ppd" I didn't need any oracle libraries. If you want I can email you a zip file including the packages and install files. Activestate you can download yourself for free on their website. Kind regards Bjorn Naessens -----Original Message----- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: donderdag 4 maart 2004 15:25 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 >>> <[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
