Thanks for the response Drew. Everything was up but I've since added the port number
to the dsn string and that seems to have done the trick.
Thanks again
Chris
---------------------------------------- Message History
----------------------------------------
From: "Hamilton, Andrew Mr RAYTHEON 5 SIG CMD" <[EMAIL PROTECTED]> on
25/06/2001 12:10 ZE2
To: Chris Saunders/DMGIT/DMG UK/DeuBa@DMG UK; [EMAIL PROTECTED]
cc:
Subject: RE: Oracle
Chris,
I usually get this when my database is not running. Or if the listener is
down. Check your host and sid, make sure the listener is up.
Regards,
Drew
-----Original Message-----
From: Chris Saunders [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 11:50 AM
To: [EMAIL PROTECTED]
Subject: Oracle
Hi,
I'm having some problems connecting to a Oracle db. The syntax I'm using
is..
$dsn = "DBI:Oracle:host=$host;sid=$sid";
$dbh = DBI->connect($dsn, $user, $password) or die "Error...$DBI::errstr\n";
but I keep getting the error
ORA-12203: TNS:unable to connect to destination (DBD ERROR: OCIServerAttach)
This is my first attempt at using DBI so I apologise in advance if I've
missed something obvious.
Chris
--
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
