Typo below... 'now sure' should be 'not sure'
L -----Original Message----- From: Mitchell, Louise M Sent: Friday, December 30, 2005 12:03 PM To: Kong, Alan Cc: dbi-users@perl.org Subject: RE: :Oracle - with ora10g oci.dll I can connect via sqlplus and sqlplusw. We don't use tnsnames.ora because we run nameservers. We only have sqlnet.ora files which contain nameserver info. I was an oracle dba for a number of years, so am familiar with configuring and setting up the oracle client and so far as I can tell the 9.2.0 client is set up correctly. But the DBD:Oracle is using the 10g oci/client files. So now sure how it's getting it's configuration information. L -----Original Message----- From: Kong, Alan [mailto:[EMAIL PROTECTED] Sent: Friday, December 30, 2005 12:02 PM To: Mitchell, Louise M; dbi-users@perl.org Subject: RE: :Oracle - with ora10g oci.dll Check to see if you can connect to sqlplus in the command prompt. You should also check the tnsnames.ora entry. -----Original Message----- From: Mitchell, Louise M [mailto:[EMAIL PROTECTED] Sent: Friday, December 30, 2005 2:57 PM To: dbi-users@perl.org Subject: DBD::Oracle - with ora10g oci.dll Hi, I am having some issues with the DBD::Oracle. I'm running Perl 5.8.7 build 813 from active state on a win2k3 server. I installed Oracle 9.2.0 client. I then installed DBI and DBD::Oracle (1.16), which installs the oci.dll as well as oraociei10.dll. I can connect using sqlplus manually from the command window, but my connection through the dbi fails with the following error: ******************************* DBI connect('irmops.prod.irm','batchrun',...) failed: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at D:\apps\test\test.pl line 9 ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at D:\apps\test\test.pl line 10. ************************ This would indicate an sqlnet configuration error. We use nameservers, so I have my sqlnet.ora file properly set up in my 9.2.0 installation under the /network/admin directory. I'm guessing that the 10i oci is not properly configured to understand how to get to our nameservers. I'm a little puzzled and not sure how to handle this error, since the 10g installation is really just a few files in the /perl/bin directory. Any help is appreciated. Thanks, LouiseM