Development of ASP + SQL Server or development of ASP + access platforms

1. First, Windows Server 2003/window Server 2000 must be commonly used on Windows servers.

For the developed platform, you can select Windows XP and other professional systems.

But there are load restrictions (I am afraid the system will not be used for installation)

2. You must install IIS after you have the system.

Control Panel --> add or delete programs --> add or delete window components

You can directly view the interest service information (IIS) in Window XP)

On the window 2003 Application Server --> interest service information (IIS)

This process requires your System Disk

IIS is a success if it is XP.

But if it is 2003, you have to continue.

3. Window 2003 is disabled by default by ASP.

Then you open your IIS and enter Web Service Extension

Enable your Active Server Pages

Perform a small test in this process.

Put index. asp in the default path C:/inetpub/wwwroot of the system site

The Code is as follows:

<% = Now () %>

After saving

Enable http: // localhost/index. asp. If the display time is normal

Congratulations!

Your IIS can run ASP programs

4. Database

This platform is applicable to small and medium-sized enterprises or small and medium users.

SQL Server & access is the most common

Access can be directly stored in the site path.

Connection DRIVER: provider = Microsoft. Jet. oledb.4.0; Data Source = "& server. mappath (db)

DB is the relative path of the database

Server. mappath converts the DB path to the physical path.

SQL Server 2000

& Is an ASP Connector

Check whether you have installed the SQL Server 2000 database.

If

Check whether your user can log on.

You can use the query analyzer to try

Connection DRIVER: provider = sqloledb; user id = "& sqlusername &"; Password = "& sqlpassword &"; initial catalog = "& sqldatabasename &"; data Source = "& sqlhostip &";