Microsoft KB Archive/108827

= SQL Data Source Connection Limit =

Article ID: 108827

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Query 2000

-



This article was previously published under Q108827



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 

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.

Additional query words: 5.00 file handles MSQuery

Keywords: KB108827

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.