Using SQL Server Tables
There's a wwSQLAsyncWebRequest method that can be used with SQL Server tables instead of Fox Tables. To utilize SQL Server tables you need to:
- Run the West Wind Management CONSOLE and use the Create SQL Server Tables option to create the SQL schema for the Aysnc Event table
- Use the wwSQLAsyncWebRequest class to create your object
- Use the Connect() method to assign either an existing wwSQL object/connection or pass a SQL connectionstring.
In the following example, the Web Connection server has been set up with a SQL connection in the oSQL member (you can do this simply by setting the WWC_USE_SQL_SYSTEMFILES in WCONNECT.H to .T. and specifying the connection string in the application's INI file and the SQLConnection key).
loAsync = CREATEOBJECT("wwSQLAsyncWebRequest") loAsync.Connect(SERVER.oSQL)
Alternately you can connect on every hit by using a connection string:
loAsync = CREATEOBJECT("wwSQLAsyncWebRequest") loAsync.Connect("dsn=wwstore_new;uid=sa;pwd=")
Comment or report problem with topic