Accessing SQL Server 7 over internet 1

[cvuodi]

I will be using SQL Server 7 on my web site (the site is written in ASP) and want to be able to connect to it remotely using Visual Foxpro 6 via ODBC to perform a SELECT query of row additions/amendments in 3 tables (using a timestamp column). I have a cable modem connection to the internet (512k speed). Would using VFP 6 to perform this form of one-way 'replication' be fast enough? The reason for using VFP is that I'm developing an VFP program to connect to my web SQL database, copy additions/amendments to a local VFP database for offline processing, then delete records over a certain age on the SQL database, and then finally to process emails to new users etc offline. This will mean I don't need to use SQL replication with the system resource overhead that it entails. Any suggestions/feedback gratefully appreciated.

 

[fluteplr]

Depending on the amount of data you are hauling over the line it should work just fine. A tip only retrieve the rows and fields you actually need, don't just code a select * from mytable (unless it is a small table).

If you do not need to update back to sql server, use a sqlexec command rather than creating a remote view, there is a lot less overhead.

I have created several application that use a vfp front end to a sql server backend, once the connection speed gets over 256kbps (dsl speed) I rarely have a problem.