|
|
5. Set up Web.config to access the database
Standard Time for the Web uses a file named Web.config to access the database. This one-time setup will enable all users of Standard Time to access the database.
First, locate Web.config in your c:\program files\standard time\Web directory on your web server. This is a text file and can be edited with Notepad. Get Properties on this file and turn off the Read-only attribute. Warning: make a backup of this file before editing it.
Near the top of the file is a section named "appSettings" that contains several keys, each with a value. The meaning of each value is listed below. Web.config controls access to SQL Server. Simply fill in each of the fields for the type of database you are using.
| Key |
Description |
| Database Type |
Enter "SQL". This will indicate that wish to access a SQL Server database. |
| Server |
Enter the name of the SQL Server database machine name, or its IP address. If your SQL Server database is located on the same machine as the web server, then enter "localhost". |
| Database |
Enter the name of the SQL Server database name. This is the name of the database shown in Enterprise Manager. Normally this is "Standard Time". |
| Filename |
Leave this field empty. |
| Username |
Enter a user name to be used to access SQL Server. This user must have rights to fully administer the database, including adding and removing tables and columns. For SQL Server you can use "sa" to get started. |
| Password |
Enter a password for the user of the database. |
| Custom Connection |
If you wish to ignore all the settings above, and use a custom database "connect string", you may enter it here, otherwise leave this value blank. OLE DB uses connect strings that contain the server, database name, user name, password, and other information to access the database. |
When finished editing this file, save it and make another backup, and you will be ready for the next step. Warning: Web.config will be replaced with a default file when you download and install Standard Time for the Web the next time, therefore a backup is necessary.
Previous Next Overview
|
