I set ORACLE_USER and it seems to be using that. Here is anerror:
t/40ph_type.............DBI connect('','ork_xxx/[EMAIL PROTECTED]',...) failed: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at t/40ph_type.t line 29 Unable to connect to Oracle (ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)) Tests skipped. Unable to connect to Oracle (ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)) I x'd out some of the connection info here... just to be nice and paranoid. On 3/5/07, Garrett, Philip (MAN-Corporate) <[EMAIL PROTECTED]> wrote:
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]> > 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 > > > >