Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I force processing on the server
Message
 
 
To
25/09/2000 14:41:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00420574
Message ID:
00420578
Views:
18
Hello Denise,
Probably the best way to do this is using DCOM. Write a small VFP Exe that has an OLEPUBLIC class defined in it. Then use CREATEOBJECTEX() to instantiate the object on the Server. You will probably have to mess with DCOMCNFG.EXE to configure the VFP COM server with the right permissions, etc.
Regards,
Houston.

>I'm trying to optimize these queries that someone else wrote because they take abso-freakin-lutely forever when the remote offices are accessing the program. I'm wondering if there is any way that I could make Fox run the sql on the server and just send the resultset across the wire?
>
>Or is that what it already does when they're running the exe off the server?
>
>Thanks.
censored.
Previous
Reply
Map
View

Click here to load this message in the networking platform