Microsoft KB Archive/252475

From BetaArchive Wiki
Knowledge Base

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


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.


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


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