database-readme.txt

ASP.NET Web Forms Techniques

----------------------------------------
----------------------------------------
Notes for sample files
----------------------------------------
----------------------------------------

Contents:
* Creating the Database
* Database Connection Strings

----------------------------------------
----------------------------------------

* Creating the Database
-----------------------
You need to create the sample database in SQL Server (based on version
7.0) using the scripts provided in the "database" directory of the samples.

To use the SQL scripts:

- Using Enterprise Manager create a new empty database named "XroxCars"
- Open SQL Server Query Analyzer from the Tools menu
- Make sure you select "XroxCars" from the drop-down list
- Open the file "make-tables.sql" and execute it
- Open the file "insert-data.sql" and execute it

Or use the backup file and restore it into your database:
In Enterprise Manager:
- Create a new Logon named anon with a blank password
- Create a new empty database named "XroxCars"
- Select the new database and right-click on it
- Select All Tasks then Restore Database
- Select From Device and click Select Devices
- Click Add and select the sample file "XroxCarsDatabase.bak"
- Click OK twice, then open the Options page in the dialog
- select "Force restore over existing database" and click OK

After installing the database:

- Go the the Security | Logins section and double-click "anon"
- In the Database Access page, check that it has access to the
  XroxCars database. You may need to edit permissions for this.


* Database Connection Strings
-----------------------------
The web.config file stored in the root folder of the samples contains
the connection string for the XroxCars database. The default for this
is:

<appSettings>
  <add key="XroxCarsConnectString"
       value="server=localhost;database=XroxCars;uid=anon;pwd=;" />
</appSettings>

You can edit this to point to your server. The user "anon"
is created by the scripts above and automatically given full access.
If you encounter problems, you can experiment by replacing the
"uid" and "pwd" with the details of the "sa" account of your SQL
Server if it is configured for Mixed Mode security.