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 = DBI->connect("dbi:ODBC:PSTORA01", "uid", "pwd") or die
> DBI::errstr;
user = uid.
> But am unable to connect with dbi:ORACLE using :
>
> $dbh = DBI->connect("dbi:Oracle:PSTORA01", "uid", "pwd") or die
> DBI::errstr;
user = uid.
> Each time I get the following error :
>
> DBI connect('PSTORA01','system',...) failed: ORA-12154: TNS:could
user = system? Why is that?
> Im using XP SP2 with Perl v5.8.8 and DBD-Oracle v1.17.
Did you compile DBD::Oracle yourself?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 5/07/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
