Microsoft KB Archive/252475

= PRB: ODBC Admin Displays Only a Certain Number of DSNs =

PSS ID Number: 252475

Article Last Modified on 3/4/2004

-

The information in this article applies to:


 * Microsoft SQL Server 2000 (all editions)
 * Microsoft Data Access Components 1.5
 * Microsoft Data Access Components 2.0
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6

-



This article was previously published under Q252475



SYMPTOMS
The ODBC Administrator will not display more than 4096 characters worth of data source names (DSNs). The data sources may be entered correctly (physically present in the registry) and still work correctly but not all of them display.



WORKAROUND
Use DSNless connections. For more information, please see the following two articles in the Microsoft Knowledge Base for information on DSNless connections to SQL Server:

155392 HOWTO: Creating a Connection to SQL Server Without a Datasource

-and-

194641 HOWTO: Make A Trusted SQL Server DSNLESS Connection

You can also use the SQLDataSources API function to obtain the list of DSNs.

Keywords: kbBug kbpending kbprb KB252475

Technology: kbAudDeveloper kbMDAC150 kbMDAC200 kbMDAC210 kbMDAC250 kbMDAC260 kbMDACSearch kbSQLServ2000 kbSQLServ2000Search kbSQLServSearch

-

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

© 2004 Microsoft Corporation. All rights reserved.