ACC97: "Data Source Name Not Found" Err Msg Opening Web Page

• Microsoft Access 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

After you use the "Publish to the Web" Wizard to create Dynamic HTX/IDC or Dynamic ASP (Microsoft Active Server Pages) file formats on your Web server, you may receive the following error message when you try to view those files with your Web browser:

   Data source name not found and no default driver specified

CAUSE

You did not create a System DSN data source on the server, or your Web page file contains an incorrect reference to the System DSN data source name.

RESOLUTION

Follow these steps on your Web server computer to add a new System DSN or check the name of an existing data source:

1. Double-click the ODBC icon in Control Panel on your Web Server.

2. In the Data Sources dialog box, click System DSN.

3. Click Add if you do not see the name of the System DSN you used as the Data Source Name in the "Publish to the Web" Wizard.

4. Select Microsoft Access Driver, and then click Finish.

   NOTE: If the Microsoft Access Driver does not appear, it is not installed on your Web server. For information about installing the driver on your Web server, search the Help Index for "Microsoft Access Desktop driver," or ask the Microsoft Access 97 Office Assistant.

5. Complete the ODBC Microsoft Access 97 Setup dialog box. The name you type in the Data Source Name box is the name you will use in the Data Source Name box in the "Publish to the Web" Wizard.

6. Click OK to close the ODBC Microsoft Access 97 Setup dialog box.

7. Click OK in the ODBC Data Source Administrator dialog box.

8. If the Data Source Name in the System DSN on your Web server is different from the one you used when you created your web pages, start the "Publish to the Web" Wizard in Microsoft Access and recreate your web pages using the correct Data Source Name.

MORE INFORMATION

Dynamic HTX/IDC and Dynamic ASP file formats are Web pages that use ODBC to display updated information from your database each time you open or refresh the page in your Web browser.

NOTE: Dynamic HTX/IDC and Dynamic ASP files require specific Web server software, and in some instances specific Web browser software. For information about the requirements to use ASP files, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q159325
   TITLE     : ACC97: Server and Browser Requirements for Publish To Web
               Wizard

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.

2. On the File menu, click Save As HTML to start the "Publish to the Web" Wizard.

3. In the wizard's first dialog box, click Next.

4. In the "What do you want to publish?" dialog box, click the Customers table, and then click Next.

5. In the "What HTML document do you want to use as a default template?" dialog box, click Next.

6. In the "What default format type do you want to create?" dialog box, click Dynamic ASP, and then click Next.

7. In the "What are, or will be, the setting for the Internet database?" dialog box, type MyDSN in the Data Source Name box, and type the server URL of the location where you will store the ASP file in the Server URL box. Click Next.

8. In the "I want to put my Web publication in this folder" box, type the full path to the folder on your Web server where you will store the ASP file. Click Finish.

   NOTE: If you do not have write permissions for the destination folder on your Web server, you receive the following error message:

         Microsoft Access can't save the output data to the file you've
         selected.
   

9. Start your Web browser, and type the URL for the Customers_1.asp file you just created, for example, http://MyServer/MyFolder/Customers_1.asp. Note that you receive the error message:

         Data source name not found and no default driver specified
   

REFERENCES