Re: Setting up MS Query to reference Personal Oracle 7.3 tables

Tom Home wrote in message <34da11eb.16051647_at_news.mindspring.com>...
>Can I use MS Query to reference Personal Oracle 7.3 tables? I assume
>that I have to set up ODBC settings, but am having no luck doing so.
>Could someone please give me detail instructions on what to install
>and how to do it? (Sorry for such a general question ...)

After having installed Personal Oracle (PO), configure SQL*Net (use Easy Config) and make sure that your connectivity works. I think you can also make a local connection (bypassing SQL*Net) if you only specify the Oracle userid and password and leave the connection string/hostname blank/spaces.

After the connectivity is working, install the Oracle ODBC driver and configure it to use the SQL*NET alias (in TNSNAMES.ORA) that you have configured with Easy Config. If the blank/spaces connection work, use the same thing in ODBC by making the database/host to connect to blank/spaces.

Good luck! :-)

regards,
Billy Received on Fri Feb 06 1998 - 00:00:00 CET