Re: Microsoft Access to Oracle via ODBC - What am i doing wrong??

Hi, folks

i receive this message when no TNS for this DSN (data source) exists ... when I add a tns under ....\oracle_home\network\admin\tnsnames.ora ('cause is a 7.3.x, if it was a 8.0.4 the directory where ....\oracle_home\net80\admin) the problem disappear. In addition I've heard that version 2.3.3 of sqlnet make some problems sometimes, if you have a 2.3.4 it goes a little better ..

bye

Richard Platt wrote:
>
> Hi
>
> First thing I always try i SQL*Plus, and test the connect that way. If this
> works most of the work is done. You don't say what network protocol you
> installed with the SQL*Net.
>
> Richard Platt
>
> Wag-Man wrote in message <3641609e.4138368_at_news.supernews.com>...
> >Help!
> >I installed the Oracle 7 ODBC drivers 2.5.3.1.0b for SQL*Net 2.3 on an
> >NT Workstation. I tried to connect to the Oracle DB via the 32bit test
> >program included and through Microsoft Access, but I keep getting a
> >Error 3121 - No interface driver connected. I also tried installing
> >the Microsoft Oracle ODBC driver. The 16bit drivers work and connect
> >fine. I'm trying to get an Microsoft Access 97 database to look at a
> >few of the tables on the Oracle DB. Everything looks like it's
> >installed correctly. I checked the log file, and it says everything is
> >installed. Any Ideas??
> >
> >Thanks
> >
Received on Thu Nov 12 1998 - 12:59:53 CET