Access Denied Error With IDC Files Created Using FrontPage

ID: Q192933

The information in this article applies to:

SYMPTOMS

When you create an Internet Database Connector (IDC) file in FrontPage 98, use the IDC Wizard to add your query, and then run the query in conjunction with the HyperText Extension (HTX) file, you receive the following error:

[Access Denied]


CAUSE

This message appears when FrontPage parses the data and switches the Template line with the SQLStatement line.

For example, a normal IDC file looks like this:

Datasource:Volcano
Template: something.htx
SQLStatement: Select * From Tablename
After parsing the data, the IDC file may look like this:
Datasource:Volcano
SQLStatement: Select * From Tablename
Template: something.htx


RESOLUTION

To fix your IDC file, follow these steps in FrontPage Explorer:

  1. Right-click the IDC file.


  2. Click Open With.


  3. Double-click Notepad.exe (text editor).


  4. Move the Template line above the SQLStatement line so that your data looks like this:
    Datasource:Volcano Template: something.htx SQLStateMent: Select * From Tablename


  5. On the File menu, click save.


(Either describes the workaround, indicates the path name, or list the revision number of the product that resolves the issues.)


MORE INFORMATION

For additional information about database connectivity with Active Server Pages (ASP) or IDC/HTX, please see the following articles in the Microsoft Knowledge Base:

Q155255 IDC Queries to Access Fail from IIS 2.0

Q160810 FP: IDC Wizard Creates IDC File on Non-IDC Server

Q174407 FP98: How to Create IDC/HTX Files in FrontPage 98

Additional query words: idc pws htx database 1.0 bug front page 


Keywords          : kbdta KbDirectX kbInternet 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: July 30, 1999