How do I get Active Server Pages to work?

[cj001]

I have Windows 2000 Server with all latest patches.
I have IIS installed along with Front Page extensions.
But, I still cannot get my ASP pages to work. I'm trying to connect to a database.

What am I missing?
Anyone have any suggestions?

THANKS!
CJ

 

[hewissa]

Have you the the ODBC connection?

If not try this,

You need to make a database connection using ODBC and assigning it to PWS.

Click Start>Run>ODBC The ODBC manager opens. Or within Frontpage you should have the option to define/connect a database.

Select the SYSTEM DSN tab. Don't bother with the USER DSN is it can only be used by connections on this machine. In your situation you will post to an ISP so use the SYSTEM DSN.

Click Add to open the Create New Data Source. Your using Access so click Access>Finish

The ODBC MS Access Setup Window opens. Use this to point to your database. In the Source name put in the name of your databse - exactly. Add a description if you choose. Leave System Database set to none. Under Database click select.

The directory browse sceen open and you map your way to your website database - C:\

http://wwwroot\yoursite\database

(however and wherever it is located....). Click Ok.

For a Connection Name the same name as the source in the previous step. For Data source (DSN) selct your DSN you just created.

If you are using Frontpage:

Start the Database Results Wizard (on the Insert menu, point to Database, and then click Results).
Click Use a new database connection, and then click Create.
Click Add, and then type a name for the new database connection in the Name box.
Under Type of connection, choose one of the following types of connections:

File or folder
System DSN
Database server on a network
Database using a custom connection

Follow my instrunction at the beginning of the post from here.... Hewissa

MCSE, CCNA, CIW

 

[cj001]

Hewissa, thank you for your response!

I have checked and I do have my ODBC connections. It is linked, but when I the ASP page in the browser I receive the message:

The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.

I have reinstalled IIS and the front page extensions a few times.

Any other thoughts?

Thanks!
CJ

 

[salsanta]

Goto Control Panel/Administrative Tools/Internet Services Manager
Click on the + sign to expand the details on the Website name
Right click on the 'Web site' details and select properties.
Under the Home Directory Tab, ensure the Execute Permissions
is set to Scripts and Executables.
Hope this helps.

 

[Sleigher]

Also, make sure under the home directory tab that your application name has an entry. 'default application' is fine.

Sleigher