The only change would be the SERVER= section of your connection string. You would change that to the name of the remote sql server hosting the box. You may need to set some security settings on W2008, but since I don't have W2008 I can't assist with that.
-Steve At 10:23 AM 07/19/2010, you wrote: > >Alternatively you could consider hosting the SQL server at your own > >company or by 3rd party remotely and have each client hit that one > >server ( or partition into several if one would be overloaded ), and > >simply have the application use different databases for each client > >to insure data security. > >I am still trying to learn how to connect the head office with a remote >store, WITHOUT USING A VPN. (I know this is not a sound alternative >because of the security issues, discussed already many times in this forum. > >However, I wish I new how to make the connection and what to set up in >the server to enable the store to enter its daily sales info into the >SQL Server directly. > >Can anybody change the following local connection string to enable a >remote connection? > >[DRIVER=SQL Server Native Client >10.0;SERVER=RAFAEL\SQLEXPRESS;UID=;Trusted_Connection=Yes;APP=Microsoft >Visual FoxPro;WSID=RAFAEL;DATABASE=mytest;LANGUAGE=Español;] > >Details: > >The head office SQL Server is installed in a Windows 2008 server >The W2008 server is accessed internally through a LAN >The VFP app is Client/server > > >The store also has a Windows 2008 server. The local LAN serves a number >of Windows 7 machines, running a VFP application based on DBF's > >The need is to have the store connect at certain intervals (ususally >every two hours) with the HO and dump its sales data into the HO SQL Server > >How should the above connection string be rewritten. Please do not refer >me to www.connectionstrings.com. I have been there, and can't make their >examples work > >Thank you all > >Rafael Copquin > > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
