Microsoft KB Archive/95060

{|
 * width="100%"|

PRB: Connection Not Open Error Message
'Article ID: Q95060

Creation Date: 31-JAN-1993

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0 and 1.1

SYMPTOMS

You receive the following error message:

Connection not open. CAUSE

The most likely cause of this error message are missing, damaged, or incorrect versions of the SQLSRVR.DLL or ODBC.DLL files.

Other situations may indirectly cause this error message. For more information, query on the following words here in the Microsoft Knowledge Base:

debugging and troubleshooting and tips and Q102437 RESOLUTION

To solve this problem, verify the following:


 * Single copies of SQLSRVR.DLL and ODBC.DLL both exist in your Windows SYSTEM directory.
 * You have the correct versions of these two files. The SQLSRVR.DLL file installed by Microsoft Access version 1.0 is dated 10-16-92 and has a size of 135792 bytes. The ODBC.DLL file installed by Microsoft Access version 1.0 is dated 10-16-92 and has a size of 44736 bytes.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00 1.10

KBCategory: kbusage kberrmsg kbtshoot

KBSubcategory: ObcOthr