Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing SQL Server Data with WC
Message
General information
Forum:
Visual FoxPro
Category:
West Wind Web Connection
Miscellaneous
Thread ID:
00757757
Message ID:
00758380
Views:
13
I think you found your solution. <g> Keep in mind that with WC you have lots of options of how you want to persist connections, although ASP style connection caching is not one of them.

The best way IMHO, is to use wwSQL, hang a reference off the server object (call it oSQL) load it in SetServerProperties with a connection string from the INI file, then forget about it. In your process code you simply reference Server.oSQL.Execute() or whatever you need.

You can take this a step further if you use business object by passing that SQL object (or the SQL handle property if you choose) to the bus object so you can use that single connection trhoughout any SQL access.

It's very flexible because you can decide how you want to deal with the connections...


+++ Rick ---



>Hi Michael:
>
>When the three COM instances instantiate I would like to make a connection to SS and have connection available to Process method where code executes. Where is a good place to do so? I have tried INIT method of WebProjectconfig (comments say it hold props for life of server) class, but prop values seems to change when I reach Process class where my code is supposed to execute.
>
>Thanx,
>Charlie
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Reply
Map
View

Click here to load this message in the networking platform