RE: Accessing oracle from windows 2000
From: Hardy Merrill (HMerrill_at_dhcr.state.ny.us)
Date: 03/04/04
- Next message: Martin Moss: "Questions about connectivity"
- Previous message: Bjorn Naessens: "RE: Accessing oracle from windows 2000"
- Maybe in reply to: Brian Barto: "Accessing oracle from windows 2000"
- Next in thread: Hardy Merrill: "RE: Accessing oracle from windows 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 04 Mar 2004 09:56:03 -0500 To: <dbi-users@perl.org>,<Bjorn.Naessens@roularta.be>, <brian.barto@spectrum-health.org>
I didn't get your ppd file - here is mine:
<SOFTPKG NAME="DBD-Oracle8" VERSION="1,06,0,0">
<TITLE>DBD-Oracle8</TITLE>
<ABSTRACT>Oracle 8 database driver for the DBI
module</ABSTRACT>
<AUTHOR>Tim Bunce (dbi-users@fugue.com)</AUTHOR>
<IMPLEMENTATION>
<DEPENDENCY NAME="DBI" VERSION="0,0,0,0" />
<OS NAME="MSWin32" />
<ARCHITECTURE NAME="MSWin32-x86-multi-thread" />
<CODEBASE
HREF="MSWin32-x86-multi-thread/DBD-Oracle8.tar.gz" /
</IMPLEMENTATION>
</SOFTPKG>
What needs to be changed?
Thanks.
Hardy
>>> <Bjorn.Naessens@roularta.be> 03/04/04 09:50AM >>>
Had the same problem. I edited the ppd file to use the correct path.
Compare with the ppd I sended you. Probably just same change needed.
Kind regards.
Bjorn Naessens
-----Original Message-----
From: Hardy Merrill [mailto:HMerrill@dhcr.state.ny.us]
Sent: donderdag 4 maart 2004 15:49
To: dbi-users@perl.org; Bjorn Naessens; brian.barto@spectrum-health.org
Subject: RE: Accessing oracle from windows 2000
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
>>> <Bjorn.Naessens@roularta.be> 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:HMerrill@dhcr.state.ny.us]
Sent: donderdag 4 maart 2004 15:25
To: dbi-users@perl.org; brian.barto@spectrum-health.org
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
>>> <brian.barto@spectrum-health.org> 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
- Next message: Martin Moss: "Questions about connectivity"
- Previous message: Bjorn Naessens: "RE: Accessing oracle from windows 2000"
- Maybe in reply to: Brian Barto: "Accessing oracle from windows 2000"
- Next in thread: Hardy Merrill: "RE: Accessing oracle from windows 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
