Re: ERwin 4.0 and Oracle.

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 @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 Wed Apr 25 2001 - 16:05:52 CDT