Re: Perl coredump when using ora_dbh_share to connect to Oracle DB's

[email protected] ("Peter J. Holzer") Thu, 1 Apr 2010 10:08:32 +0200

Newsgroups	perl.dbi.users
Message-ID	<[email protected]>

On 2010-04-01 09:43:32 +0200, Wesley Schwengle wrote:
> On 01.04.10 03:02 John Scoles wrote:
>> Hard to say exatly are you sure you are connecting to oracle corretly??
>>
>> use DBI;
>>
>> my $dsn = 'DBI:Oracle:host=localhost;port=1527;sid=XXX';
>>
>> is a rather odd dsn
>
> I always the the method above, although I don't define the host and port part,
> since it is known in tnsnames. But the dsn part looks normal to me :)

If you want to use tnsnames, shouldn't that be:

   my $dsn = 'DBI:Oracle:XXX';

instead of

   my $dsn = 'DBI:Oracle:sid=XXX';

?

        hp

-- 
   _  | Peter J. Holzer    | Auf jedem Computer sollte der Satz Ludwigs II
|_|_) | Sysadmin WSR       | eingeprägt stehen: "Ein ewig Rätsel will ich
| |   | [email protected]      | bleiben, mir und andern."
__/   | http://www.hjp.at/ |    -- Wolfram Heinrich in desd

signature.asc (application/pgp-signature, 189 B)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iD8DBQFLtFSAMdFfQa64PCwRAvfHAJ9Ghkbd6ip7htjDsTExENcnlJSB4QCeO8TP
wyzrUhnkrmMVP7QjVR/dgko=
=wTQa
-----END PGP SIGNATURE-----