MSQuery: SQL Data Source Connection Limit

 Last reviewed: September 12, 1996
Article ID: Q108827
The information in this article applies to:
  • Microsoft Query for Windows, version 1.0
  • Microsoft Query for the Macintosh, version 1.0

SUMMARY

The number of connections to SQL servers is limited under Microsoft Query. Attempting to make more than 14 connections to SQL servers will result in the following error message: 

   ConnectionOpen (sopen()).
   Unable to connect to data source
Connecting to 14 SQL servers and then making a connection to a dBASE source and adding a table will result in the following error message: 

   Can't access table <path\filename>
Choosing OK to this error message and again attempting to connect to a dBASE data source will result in another error message: 

   Data source not found and no default driver specified

MORE INFORMATION

The above error messages result from a limited number of Microsoft Query connection handles. There are no settings in either the application or the ODBC drivers to correct this. Connections to SQL server take one connection handle each. Attempting to make a fifteenth (15th) connection will result in an error.

KBCategory: kbusage kberrmsg kbtool
KBSubcategory: xlquery

Additional reference words: 1.00 5.00 file handles



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" 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.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.