RE: ORACLE with Oracle XE

Do you have PSTORA01 set up in Oracle's TNSNAMES.ORA? (the error appears to
imply you have not)
Does "sqlplus uid/pwd@PSTORA01" work?

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

________________________________

From: Paul Griffin [mailto:pgriffin@PrincetonSoftech.com]
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.