MS Query??
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