Re: DBI:ORACLE with Oracle XE

On Tue, 4 Jul 2006 17:47:15 -0400, Paul Griffin wrote:

Hi Paul

> I can connect to an Oracle XE database with dbi:ODBC using :
>
> $dbh =3D DBI->connect("dbi:ODBC:PSTORA01", "uid", "pwd") or die
> DBI::errstr;

user =3D uid.

> But am unable to connect with dbi:ORACLE using :
>
> $dbh =3D DBI->connect("dbi:Oracle:PSTORA01", "uid", "pwd") or die
> DBI::errstr;

user =3D uid.

> Each time I get the following error :
>
> DBI connect('PSTORA01','system',...) failed: ORA-12154: TNS:could

user =3D system? Why is that?

> I=92m using XP SP2 with Perl v5.8.8 and DBD-Oracle v1.17.

Did you compile DBD::Oracle yourself?

--
Cheers
Ron Savage, ron@savage.net.au on 5/07/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company