Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 181656 - Last Review: December 1, 2000 - Revision: 1.0
FP98: Data Source Name Not Found Error When Previewing ASP Page
This article was previously published under Q181656
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.
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.
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:
- On the Windows Start menu, point to Settings, and then click
Control Panel.
- Double-click the 32bit ODBC icon (Windows 95) or the ODBC icon
(Windows NT).
- Click the System DSN tab.
- Click Add.
- Select the driver you want to use. For example, select "Microsoft
Access Driver (*.mdb)." Click Finish.
- 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.
- Click Select.
- Select the database file you want to use.
- 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:
- On the Windows Start menu, point to Settings, and then click
Control Panel.
- Double-click the 32bit ODBC icon (Windows 95) or the ODBC icon
(Windows NT).
- Click the System DSN tab.
- Note the name of your system DSN.
- Start or switch to FrontPage Editor and then open the page that contains
the database region.
- Right-click any of the database column values and then click Database
Region Properties on the menu that appears.
- Click Back.
- Type the name of the system DSN you noted in step 4 and then click
Finish.
For additional information, please see the following articles in the
Microsoft Knowledge Base:
175770Â
(http://kbalertz.com/Feedback.aspx?kbNumber=175770/EN-US/
)
FP98: How to Post Information to a Database Using ASP
175771Â
(http://kbalertz.com/Feedback.aspx?kbNumber=175771/EN-US/
)
FP98: How to Display Contents of a Database Using ASP
182122Â
(http://kbalertz.com/Feedback.aspx?kbNumber=182122/EN-US/
)
How to Remove or Customize the "No Records Returned" Message
APPLIES TO
- Microsoft FrontPage 98 Standard Edition
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please