>>first of all i feel great that i finally found something that is letting me define my problem in details. so here it goes
>>We are currently working on ERP solution in Visual fox pro 6 and its incomplete. the main reason of this post is simple.
>>i want to create a setup file that installs application on a local computer but connects to sql 2008 for database operation. i do NOT want to save data in local dbf . i want my data to be stored in sql 2008 r2. awaiting respones.
>
>I use an ODBC connection to the sql database and VFP's remote views.
>http://msdn.microsoft.com/en-us/library/aa975682(v=vs.71).aspx

thank you the website you gave is pretty good.