Re: ERwin 4.0 and Oracle.
Date: Wed, 25 Apr 2001 17:56:17 -0700
Message-ID: <teesht4a3c43ff_at_corp.supernews.com>
Hello, Van!
Thanks for the ideas! I got a suggestion to check my tnsnames.ora file to make sure that the database entry is in there. I'll likely try that out first then check your ideas.
Thanks again! :-)
John Peterson
"Van Messner" <vmessner_at_bestweb.net> wrote in message
news:Q_GF6.5044$Uu6.465988_at_monger.newsread.com...
> This is a pretty vague answer cause it's been awhile since I used ERwin
> rather than Designer. It used to be that ERwin lagged Oracle in terms of
> supplying drivers. Do you have drivers to connect to databases as recent
as
> whatever version of Oracle you're using? And it used to be that when
ERwin
> was installed on the same machine as the database there was some odd
connect
> string perhaps _at_2: or something similar.
> There's also a database design newsgroup where you might run into people
> using ERwin4.
>
> Van
>
>
> "John Peterson" <johnp_at_azstarnet.com> wrote in message
> news:tee1tmn0n1ep55_at_corp.supernews.com...
> > (Oracle 8.1.7 EE on Win2K)
> >
> > Hello, all!
> >
> > I have a call in at Computer Associates to help me with this problem,
but
it
> > might be a day or two before I hear back from them and I thought I'd
solicit
> > any opinions in this forum in the hopes that it'd be faster. ;-)
> >
> > I am trying to "Reverse Engineer" a schema from my Oracle database using
> > ERwin 4.0. I'd like to be able to use the Oracle-specific features of
ERwin
> > as much as possible. I am trying to connect to the database and I am
> > prompted for three fields: User, Password, and Connect String. I don't
> > quite know what to put in for the Connect String. I have tried to put
in
> > the service name (<server>;1521;<SID>), the instance name
> > (orcl.mydomain.com), the server name; but so far, all my attempts have
> > failed. I'm able to connect to the Oracle database through a variety of
> > other means (SQL*Plus, etc.), but not through ERwin.
> >
> > Any suggestions and ideas would be *very* welcome and appreciated! :-)
> >
> > John Peterson
> >
> >
>
>
Received on Thu Apr 26 2001 - 02:56:17 CEST