That did it. Many thanks.
byron
--- "M.W. Koskamp" <[EMAIL PROTECTED]> wrote:
>
> ----- Original Message -----
> From: "Byron Wise" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 12, 2001 5:44 AM
> Subject: Trouble connecting to Oracle!
>
>
> > I need help!! I'm running Personal Oracle8i and
> > ActiveState's perl on the same win98 machine. All
> I'm
> > trying to do is make a connection. If anyone
> would
> > please help me do this I'd appreciate it.
> >
> [...]
> > my $dbh = DBI->connect('DBI:Oracle:MyDB2',
> $username,
> > $passwd, {RaiseError => 1, AutoCommit => 0}) ||
> die
> > "Unable create database handle: $!\n";
> >
> > Error(STDERR):
> >
> > C:\WINDOWS\Desktop>perl oracle.pl
> > DBI 1.14-nothread dispatch trace level set to
> 1
> > -> DBI->connect(DBI:Oracle:MyDB2, SYS, ****,
> > HASH(0x176f13c))
> > -> DBI->install_driver(Oracle) for
> perl=5.006001
> > pid=1782017 ruid=0 euid=0
> > install_driver: DBD::Oracle loaded (version
> > 1.06)
> > <- install_driver= DBI::dr=HASH(0x1809518)
> > !! ERROR: 12541 'ORA-12541: TNS:no listener
> (DBD
> > ERROR: OCIServerAttach)'
> > <- connect= undef at DBI.pm line 408.
> > <- errstr= 'ORA-12541: TNS:no listener (DBD
> ERROR:
> I think here is your error. You dont have a Oracle
> listener running on your
> PC.
> Either start the oracle listener (using lsnrctl) or
> dont connect trough sql
> net.
> See the DBD::Oracle documentation for examples using
> a local connection.
>
> Maarten.
>
>
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
