Re: Visio and Oracle?

Henrootje wrote:
> Can anyone tell me how I can reverse engineer an Oracle database from
> Visio Professional 2003?
>
>
> I am running a Oracle 9 database, just installed the 10g Oracle Client
> on Vista but I simply cannot connect....
>
> Oracle keeps whining about the tnsnames.ora file which it keeps
> telling me it can't parse.................
>
> Suggestions?

Unless your database contains nothing but heap tables and B*Tree indexes it can not be done. Visio is a brain-dead tool barely able to support SQL Server. Try to get Visio to recognize a sequence object, or an object view, or just about anything else and you are doomed to failure.

PS: There is no such thing as "Oracle 9." Is it 9.0.1 or 9.2.0.8? It matters in almost all cases.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org