Re: Database designer config

Richard Campbell wrote:

> Hi oracle users .
>
> I would like to use sqlnet to reverse engineer a schema using the
> Oracle database Designer (ODD) tool.
> I have read that ODD needs 16 bit Odbc and SQLnet versions
> (or 32 bit thunking odbc , which the Oracle odbc drivers I have do not
> support).
>
> I am using a PC with windows 95 and have tried installing Oracles ODBC
> 16 bit driver ( for 7.3 client software ) and various SQLnet 2
> versions (from windows 3.1 software and therefore hopefully 16 bit).
>
> Unfortunately , I cannot make any successful connections even from ODBC
> test.
>
> Can anybody recommend a working combination of odbc and SQLnet for the
> designer ?
>
> Thanks in advance
>
> Richard
>
>
> ------------------------------------------------------------------------
> Richard Campbell
> Database Administrator SERCo (On site ESA/ESRIN)
> EMAIL Richard.campbell_at_mail.esrin.esa.it
> ------------------------------------------------------------------------

 I would recommend to check 3 things:

1. The listener on the server side is started ?
2. Do you use the same config files on both your server and client side ?
   • You can copy those 2 files from the server to the client side.
     • sqlnet.ora
     • tnsnames.ora
3. Make sure your connect string is configured in tnsnames.ora.

I succeed to make a connection with sql*net2.2.2.0.3A (for Windows3.1 : 16 bits) and Database Designer1.0.0.17.0 (16 bits) on Windows95.

But, I have another problem. The only object that Database Designer allow me to reverse engineer is TABLESPACE!

Does anyone has any clues how to reverse engineer all the other objects like TABLE and INDEX ?

Thanks in advance!

--
Pierre Cyr      Analyste-programmeur (Oracle)
École des Hautes Études Commerciales (HEC)
3000 chemin de la Côte-Sainte-Catherine
Montréal QC Canada H3T 2A7
pierre.cyr_at_hec.ca                   Tel: (514) 340-6527
                                                Fax: (514) 340-5637