General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
Craig
At the end of the day I want VFP to connect to SQL Server 2005, to retreive a dataset, I want to then modify the data with VFP (tied to data fields on a form), then I'd like SQL Server 2005 to handle everything else. The only other thing I need to do is to be able to record lock SQL Server 2005 record(s) within VFP to allow me to perform validation and back-process updates.
I want the code to be as simple and as transparent as it can be, and ultimately I'll move the SQL commands themselves through to SQL Server 2005 at some point.
So, ODBC with SQL-pass-through?
Previous
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