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