Download sample
This sample provides the code for the ATL Server Tutorial.
Demonstrates Web access to a database for a simple online store. When you run the application, a Web page prompts you for a username and password. You can either enter a username and password for an existing customer in the database or create a new account, in which case the application will write the new username and password to the database.
Building and Running the Sample
To build and run this sample
-
Open the solution file, Tutorial.sln, in the Visual Studio development environment.
-
Build the solution. This will also deploy the solution to the local Web server.
-
Configure the data link to connect to the Tutorial.mdb database. In the sample's Tutorial\Tutorial\bin directory, double-click Tutorial.udl.
The Data Link Properties dialog box appears.
-
On the Provider tab, select Microsoft Jet 4.0 OLE DB Provider.
-
On the Connection tab, click the Ellipsis (...) button to specify the Tutorial.mdb file in the Tutorial\Tutorial\bin directory. Leave the username and password blank.
-
Ensure that Tutorial.mdb is not read-only. Right-click the file and select Properties. On the General tab, ensure that the Read-only check box is cleared.
-
Change the NTFS security settings on the Tutorial.mdb file to allow read-write access by the Internet Guest Account, IUSR_Machine. To do this:
-
Right-click the Tutorial.mdb file and select Properties on the shortcut menu.
-
In the Properties dialog box, select the Security tab and click Add.
-
The Select Users or Groups dialog box appears; in that dialog box, set the following:
Object Types to Users.
Locations to the local machine.
Check Names to IUSR_Machine.
-
Select the Internet Guest Account that you just created. In the Permissions box, select the Read and Write boxes if they are not already selected.
Note |
|---|
| See ATL Server Security for information about the accounts used by a typical ATL Server application running in IIS. |
-
Change the NTFS security settings on the folder containing Tutorial.mdb to allow only write access by IUSR_Machine, using the procedure described in Step 7.
-
Change the NTFS security settings on the Tutorial.udl file to allow read access by the IUSR_Machine account, using the procedure described in Step 7.
-
Use a Web browser to view http://localhost/tutorial/login.srf.
For more information, see ATL Server Tutorial.
See Also