Web Connection supports creation of SQL Server tables to hold logging, session and async request information. Using SQL Server can be useful for systems that are otherwise using SQL Server for data access, to remove any dependencies to local VFP tables. This may be especially important for large installations that are running on load balanced systems where multiple servers must share these session and log files.
To add SQL server sessions and logs you need to:
WWC_USE_SQL_SYSTEMFILEScompiler flag in
- Create the SQL Server tables in a database
- Set a Connection string in
The Create SQL Server Tables Wizard in the Web Connection Console takes you through creating a database or using an existing one to add the
wwSession table to. Once the tables are created additional manual steps are required to actually configure the Web Connection application to use those tables, which is described in the last steps of this topic tree.
This feature is not available for shareware version users, since the implementation requires a recompile of the classes. You can create the databases, but the actual tables will never be accessed or read from.
Note that you don't have to run the Wizard described in this walkthrough. You can create the database using the script that can be found at:
To do this:
- Open SQL Server Management Studio (or whatever tool you like to use for SQL)
Westwind.sqland copy the SQL text
- Select or create a database
- In SSMS open a new Query Window in the database you want to add the West Wind Tables
- Paste the SQL script and execute
What is created:
- WebRequestLog Table
- wwSession Table
- Two stored procedures for wwSession to add and retrieve a session value
Comment or report problem with topic