Setting the Connection String

The connection string is used to connect to your application database. You must set the connection string variable conStr in two files:

• tbkTrackerRead.ASP

• tbkTrackerWrite.ASP

 

To modify the conStr variable:

1. Uncomment (remove the apostrophe from) the "conStr =" assignment corresponding to your provider (SQL Server or JET).

2. Delete or comment out (put apostrophe's in front of) the "conStr =" assignment corresponding to the other provider.

3. Modify the necessary values in the connection string. The values vary depending on which provider you use. See below for details.

 

SQL Server

 

If you're using SQL Server, the conStr assignment should look similar to the following:

 

conStr = "Provider=SQLOLEDB;" _

     & " Data Source=(local);" _

     & " Initial Catalog=SportsSample;" _

     & " User ID=Admin;" _

     & " Password=tbk"

 

You need to modify the following values in the above conStr assignment to correspond to your database settings:

• Data Source

• Initial Catalog

• User ID

• Password

 

JET

 

If you're using JET, the connection string should look similar to the following:

 

conStr = "Provider=Microsoft.Jet.OLEDB.4.0;" _

     & " Data Source=C:\Inetpub\wwwroot\sportsSample\data\sportsSample.mdb;" _

     & " User ID=Admin;" _

     & " Jet OLEDB:Database Password=tbk"

 

You need to modify the following values in the above conStr assignment to correspond to your database settings:

• Data Source

• User ID

• Jet OLEDB:Database Password