Have you set TWO_TASK or ORACLE_SID? What's the exact error you're
getting from the test suite?
________________________________
From: April Blumenstiel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 05, 2007 3:37 PM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Subject: Re: Installing DBD::Oracle on Cygwin/Windows XP 32 bit.
Make test not resolving TNS
Oh, actually, just tried it again and sqlplus is working fine. I
just had to pass it the connection string to the remote DB when I ran
it.
On 3/5/07, April Blumenstiel <[EMAIL PROTECTED]> wrote:
That was a good tip, because I just tried sqlplus and I
get 'ORA-12560: TNS: protocol adapter error"
So there's a clue.
The client is working, and I tried tnsping and it was
fine. It used the TNS file that I have in my TNS_ADMIN var. And I've
been using Toad. So it's intersting that slqplus and OCI don't seem to
be working. Still hunting...
On 3/5/07, Garrett, Philip (MAN-Corporate) <
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote:
April Blumenstiel wrote:
> Hello,
>
> I have downloaded the instant client and the
header files for Oracle
> 10g, and DBD::Oracle is compiling without
error, but the make tests
> are failing. The TNS is failing to resolve. I
have set my TNS_ADMIN
> var to the location of the file. I know it's a
good TNS file, because
> it works fine on my old system.
Does SQL*Plus work? If not, get that working
first, then try
DBD::Oracle.
If I recall correctly, you can't use an
environment variable for Oracle
stuff on Windows -- you have to use a registry
setting instead. But
don't have any facts to back that up :-)
- Philip
