MS Query??

• Quoting Cynthia Mumford to All dated 10-19-94 ***
  > Help! I need a way to test whether ODBC is installed/working properly
  > on my PC, and have received a couple of suggestions to check out
  > the connection with MS Query. However, we've looked around a little and
  > can't find out what MS Query is or where to find it. Could anyone enlighten
  > me? Could anyone offer any other suggestions for testing out the
  > connection? I have no other Oracle products on the PC, so can't test it
  > out with SQL*Plus or SQL*DBA.
  

You couldn't anyway, because the current production releases of SQL*Plus and SQL*DBA do not support ODBC (nor do I personally expect them to in the future. The ODBC performance drain is simply too large for these products, and it makes little sense to connect SQL*DBA to anything other than an Oracle database.)

You have MS-Access, that's usually the BEST thing to check with, as non-Microsoft programs will often crash when attaching to intelligent SQL servers via ODBC for inexplicable reasons.

> I've been trying to connect from MS-Access to an Oracle 7 database.
> Below are the particulars for client and server. I've read through most of
> the suggestions and hints which have been posted here recently for MS
> Access and ODBC, and tried the ones which seemed relevant. When trying to
> attach a table withing MS Access, I receive a very generic error from MS
> Access that basically says "It didn't work"; I get this same message if I
> use a TCP/IP product that is unsupported by Oracle. SQL*Net appears to be
> up and running properly on the server, so I believe that the client is the
> problem.

At first glance, your problem seems to be with TCP/IP. The first basic question is, can you ping the server? If you cannot, your problem is very basic.

If so, you need to delve deeper into your TCP/IP configuration on both sides. Although my experience with SuperTCP/NFS has been a good one, I have seen many unsupported implementations simply fail to properly connect. Received on Sun Oct 23 1994 - 14:56:18 CET