Mark,
I currently use a connect like this :
my $dbh = DBI -> connect ("dbi:Oracle:", $ENV {ORAPWD}) ;
The environment variable $ORAPWD is a standard Oracle connect string. That
is, either username/password for a 'direct' connection, or
username/password@alias for a SQL*Net connection. You need to have SQL*Net
properly configured on both boxes. That is, an entry in the listener.ora on
the Sun box for your DB sid, and in the tnsnames.ora on the Linux box. Once
the configuration is OK, you need to start the SQL*Net listener on the Sun.
(Apologies if I'm teaching you to suck eggs here).
Hope this helps,
Steve
-----Original Message-----
From: Mark A. Werner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 27 June 2001 7:58 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Help Please DBI/ODBC/ORACLE
How do I tie the DBD:ORACLE to the SQL*NET ?
In other works, if I install the client and SQL*NET, how do I tell my
program to use it ?
Currently I just say
my $dbh = DBI->connect( "dbi:Oracle:SDADATA", "username", "password"
)
-----Original Message-----
From: Steven Baldwin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 5:53 PM
To: Mark A. Werner; '[EMAIL PROTECTED]'
Subject: RE: Help Please DBI/ODBC/ORACLE
Couldn't you install the Oracle client on the linux box, and access the
Solaris box via SQL*Net - using DBD::Oracle on the Linux box exactly as you
do on the Sun box ?
-----Original Message-----
From: Mark A. Werner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 27 June 2001 7:39 AM
To: '[EMAIL PROTECTED]'
Subject: Help Please DBI/ODBC/ORACLE
Hello:
I know this should bea simple question but I have chased it through manuals
and FAQ's
and WEB pages for 3 days.
Any help woule be GREATLY appreciatted.
I have an ORACLE database on a Solaris 2.7 system that I am accessing via
the PERL DBI
inteface Just Fine.
But I need to be able get to it vai the PERL DBI from a LINUX 7.2 box.
The perl DBI book from O"REELLY makes it seem like a piece of cake, just use
DB Proxying.
But each step in this seem like it requires 2more steps , and so on and so
on till I Lost!
Here's where I am
- On LINUX I tied to install DBD::ODBC
- This requires you to tell it where your ODBC Driver
Manager IS
- This requires you specify a driver (which I am
clueless on)
Have I headed down a wrong path ?
Is the a SIMPLER, EASIER way to do this ?
Again, I aplogize in advace for the "basic" nature of the question, but I
have tried
to look everywhere before wrting.
THX IN Advance
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
