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
Description: Digital signature
