Do you have PSTORA01 set up in Oracle's TNSNAMES.ORA? (the error appears to imply you have not) Does "sqlplus uid/[EMAIL PROTECTED]" work?
-- Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool ________________________________ From: Paul Griffin [mailto:[EMAIL PROTECTED] Sent: 04 July 2006 22:47 To: dbi-users@perl.org Subject: DBI:ORACLE with Oracle XE I can connect to an Oracle XE database with dbi:ODBC using : $dbh = DBI->connect("dbi:ODBC:PSTORA01", "uid", "pwd") or die DBI::errstr; But am unable to connect with dbi:ORACLE using : $dbh = DBI->connect("dbi:Oracle:PSTORA01", "uid", "pwd") or die DBI::errstr; Each time I get the following error : DBI connect('PSTORA01','system',...) failed: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at C:\Projects\PST-Repository\Perl\oracle_01.pl line 10 ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at C:\Projects\PST-Repository\Perl\oracle_01.pl line 10. *** Process "C:\Perl\bin\perl.exe" terminated. Return code=255 med> I'm using XP SP2 with Perl v5.8.8 and DBD-Oracle v1.17. Any suggestions/help appreciated. Regards Paul.
