Re: How To Connect to Oracle From WO 5.2
Re: How To Connect to Oracle From WO 5.2
- Subject: Re: How To Connect to Oracle From WO 5.2
- From: email@hidden
- Date: Thu, 12 Feb 2004 12:41:56 -0500
- Priority: normal
Oh man that is embarrassing.
It was indeed the colon after thin! Thanks everyone!
A. Shiraz
44 Executive Boulevard
Elmsford, NY 10523
(914) 592- 4203 x268
----- Original Message -----
From: Ricardo T Saito <email@hidden>
Date: Thursday, February 12, 2004 1:28 pm
Subject: RE: RE: How To Connect to Oracle From WO 5.2
> Hi,
>
> The format is jdbc:oracle:thin:@host:port:sid, so you're missing
> the ":"
> just before the "@". :-)
>
> Try:
> jdbc:oracle:thin:@dbtest2.lhric.org:1521:orcl.osdbtest.lhric.org
>
> -----Original Message-----
> From: email@hidden
> [email@hidden]On Behalf Of
> email@hidden
> Sent: Thursday, February 12, 2004 2:14 PM
> To: email@hidden; email@hidden
> Subject: Re: RE: How To Connect to Oracle From WO 5.2
>
>
> Thanks everyone,
>
> I downloaded the classes12.zip (although they do exist in
> D:\Oracle\ora\jdbc\lib\ but apparently they are not in the
> classpath) so
> that error is gone, thanks.
>
> Now the error I get is "Invalid Oracle URL specified".
>
> Please not the tnsnames.ora file I included and the url I am using
> from the
> file :
>
> jdbc:oracle:email@hidden:1521:orcl.osdbtest.lhric.org
>
> (isnt the url jdbc:oracle:thin:@host:port:sid) please see the
> tnsnames.ora(that I can use to connect just fine using sqlplus.
>
> I looked at wodeveloper and I have not come into anything similar.
>
> A. Shiraz
> 44 Executive Boulevard
> Elmsford, NY 10523
> (914) 592- 4203 x268
>
> > -----Original Message-----
> > From: email@hidden
> > [email@hidden]On Behalf Of
> > email@hidden
> > Sent: Thursday, February 12, 2004 1:03 PM
> > To: email@hidden
> > Cc: email@hidden
> > Subject: How To Connect to Oracle From WO 5.2
> >
> >
> > Morning everyone,
> >
> > I was trying to connect to an instance of our Oracle DB. We have
> > Windows2000 advanced server WO 5.2 and Oracle 8i (8.1.7)
> >
> > Here is the tnsnames.ora entry:
> >
> > LOGIN =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = dbtest2.lhric.org)(PORT =
> > 1521)) )
> > (CONNECT_DATA =
> > (SERVICE_NAME = orcl.osdbtest.lhric.org)
> > )
> > )
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.