FP98: Data Source Name Not Found Error When Previewing ASP Page

Last reviewed: March 18, 1998
Article ID: Q181656
The information in this article applies to:
  • Microsoft FrontPage 98 for Windows

SYMPTOMS

When you preview a page that contains a database region, you may see the following message in the Web browser:

   Database Error: [Microsoft][ODBC Driver Manager] Data source name not
   found and no default driver specified.

CAUSE

This behavior occurs when the system data source name (DSN) you specified in the database region does not exist. This message most often appears when you mistype the DSN name in the system DSN properties or in the Database Region Wizard.

RESOLUTION

To resolve this behavior, use one of the following methods:

Method 1: If you have not yet set up your system DSN

If you have not set up your system DSN, you must set it up. To do this, follow these steps:

  1. On the Windows Start menu, point to Settings, and then click Control Panel.

  2. Double-click the 32bit ODBC icon (Windows 95) or the ODBC icon (Windows NT).

  3. Click the System DSN tab.

  4. Click Add.

  5. Select the driver you want to use. For example, select "Microsoft Access Driver (*.mdb)." Click Finish.

  6. In the Data Source Name box, type the name you specified in the Database Region Wizard.

    NOTE: The DSN name should not include any spaces.

  7. Click Select.

  8. Select the database file you want to use.

  9. Click OK three times.

Method 2: If you have already set up your system DSN

If you have already set up your system DSN, you must verify the name of the DSN and specify the DSN name in the database region. To do this, follow these steps:

  1. On the Windows Start menu, point to Settings, and then click Control Panel.

  2. Double-click the 32bit ODBC icon (Windows 95) or the ODBC icon (Windows NT).

  3. Click the System DSN tab.

  4. Note the name of your system DSN.

  5. Start or switch to FrontPage Editor and then open the page that contains the database region.

  6. Right-click any of the database column values and then click Database Region Properties on the menu that appears.

  7. Click Back.

  8. Type the name of the system DSN you noted in step 4 and then click Finish.

MORE INFORMATION

For additional information, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q175770
   TITLE     : FP98: How to Post Information to a Database Using ASP

   ARTICLE-ID: Q175771
   TITLE     : FP98: How to Display Contents of a Database Using ASP

   ARTICLE-ID: Q177082
   TITLE     : FP98: "No Records Returned" Received When Posting to
               Database


Additional query words: front page
Keywords : fpedit fpodbc fpactive kbdta
Technology : internet odbc
Version : WINDOWS:98
Platform : WINDOWS
Hardware : x86
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.