General information
Category:
The Mere Mortals Framework
Hi Paul,
SQL server upsize is possible, sorry what's MM & TS??
Cheers,
Blair
>If it's a MM's app, could you upsize it to SQL Server, then have your clients log into the TS site and use the app? Then it's not necessary for them to give any access to their local network at all. All that's necessary is for them to allow SQL traffic between the TS box and the SQL Server box (this could all be locked down pretty well). This might be the easiest way to go.
>If that won't work, I would probably lean more towards a fat-client app (eg. VFP front end) that uses something like Web Services to expose functionality to your remote application. Your web service would expose methods your desktop app. could call - it's easy to use things like XMLTOCURSOR() and CURSORTOXML() to pass cursors between the client and web server. But, it would require a change in the way data was retrieved and saved on the client side. The other issue you have to deal with is reports. In a lot of web apps I'll either redo the report so it's a native HTML report, assuming that's possible, or just return the report as a PDF file. PDF's are normally an easier way to go with existing applications. If you want to go this route, I'd highly recommend looking at something like WebConnect. It includes a ton of functionality that makes doing this kind of stuff easier.
-Paul
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only