Nice catch Richard, I totally missed that in my reply. -Steve
At 11:39 AM 07/19/2010, you wrote: >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 > > [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.
