Microsoft KB Archive/280392

= FP2002: Cannot Select a System DSN When You Try to Add a Database Connection in Your Web =

PSS ID Number: 280392

Article Last Modified on 3/27/2001

-

The information in this article applies to:


 * Microsoft FrontPage 2002

-



This article was previously published under Q280392



SYMPTOMS
When you try to add a System DSN database connection to your Web, the Browse option and the text input box are unavailable (dimmed).



CAUSE
When the ListSystemDSNs registry key is set to 0 (zero), the option to list or choose a System DSN is turned off (unavailable):

HKEY_Local_Machine\Software\Microsoft\Shared Tools\Web Server Extensions\All Ports\ListSystemDSNs

Many Internet Service Providers may choose this setting, so that users cannot view the connection names of other users.



WORKAROUND
To work around this behavior, you can type a system DSN, even when ListSystemDSNs is set to 0. To do this, follow these steps:
 * 1) On the Tools menu, point to Web Settings, and then click the Database tab.
 * 2) Click Add to add a new database connection.
 * 3) Click Custom definition.
 * 4) Click the Advanced button.
 * 5) In the Connection string field, type the DSN (for example, DSN=ECDCMusic;DRIVER={Microsoft Access Driver (*.mdb)} ).
 * 6) Click OK twice, verify the connection, click Apply, and then click OK again.

Additional query words: prb FP2002

Keywords: kbprb KB280392

Technology: kbFrontPage2002 kbFrontPage2002Search kbFrontPageSearch

-

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

© 2003 Microsoft Corporation. All rights reserved.