Hi Rafael, You say the server is Windows 2008 but don't specify the version of SQL installed.
For testing purposes, can you create an ODBC connection using the ODBC Administrator to verify that you can connect to the server on the internal network? The first thing that pops out at me is that you most probably can't use a trusted connection for the stores as that expects you to be on the same network/domain. You will need to configure the SQL Server to support SQL Server logins instead of just Windows authentication. You will also then need to add the user and password strings to the connection string. rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: Monday, July 19, 2010 10:24 AM To: [email protected] Subject: VFP and SQL (was Large Data Tables) 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 _______________________________________________ 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/df1eef11e586a64fb54a97f22a8bd04418fd44e...@ackbwddqh1.artfact.local ** 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.
