MS Query??

From: Cynthia Mumford <cindy_at_dprmpt.dataprompt.com>
Date: 19 Oct 94 14:18:02 GMT
Message-ID: <902_at_dprmpt.dataprompt.com>


  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.
  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.   Any information would be appreciated.

  • Client ** MS-DOS 6.2 Windows for Workgroups 3.11 Frontier Technologies SuperTCP/NFS for Windows 4.0 (Windows Sockets Version 1.1 Compliant) Oracle's ODBC driver 1.1.0.0 for Version 7 MS Access 2.0 SQL*Net 2.0.15.0.3 TCP/IP Protocol Adapter 2.0.15.0.4
  • Server ** Sun Sparcstation 20 Solaris 2.3 Oracle 7.1.3 SQL*Net 2.1.3
-- 
*********************************************************************
*           Cindy Mumford      (301) 622-0900 ext 304               *
* Internet:   cindy_at_dataprompt.com     UUCP: ...!uunet!dprmpt!cindy *
*********************************************************************
Received on Wed Oct 19 1994 - 15:18:02 CET

Original text of this message