>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 --- _______________________________________________ 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.
