Microsoft KB Archive/252475

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:15, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

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