DBI:ORACLE with Oracle XE

Tue, 04 Jul 2006 14:47:50 -0700

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…

Reply via email to