I assume therefore the tnsping does not work. Talk to your DBA/system admins.
Perl DBI can not possibly work if the underlying database does not work. Lincoln -----Original Message----- From: Powell, Bruce [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 3:05 PM To: '[EMAIL PROTECTED]' Subject: Connection troubles on HP-UX I am using dbi to connect to an Oracle database on a HP-UX (HP-UX 11.0) database. When I attempt to connect to the database I receive the following error: DBI->connect(prd1) failed: ORA-12154: TNS: could not resolve service name (DBD Error: OCIServerAttach) at ./tryDBI.pl This happens when we use a service name as the connect string. But is we fully qualify the connect string we get a connection. The problem comes about in an application we use, it does not like the fully qualified connect string. Can some one help me out here? -Bruce ___________________________________________________________________________ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
