Rafael, Yes, server name is either the IP address or the name in a domain of the PC holding the SQL Server and you are correct in that specifying the login name and password means that you can set up a user within the SQL Server. I used sa simply as an example as obviously you wouldn't want to give a user administrative rights to everything!
Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: 19 July 2010 16:05 To: ProFox Email List Subject: Re: [spam] RE: VFP and SQL (was Large Data Tables) Thanks Dave I guess cServer_Name="192.168.1.1" below would have to be changed to the HO server address. Now, is it the router address alone or a combination of the router address and the Windows Server 2008 machine address? If so, how do you write it? ie. router address = 192.168.1.1 server address 192.168.1.100 How do you initialize the variable cServer_name ? Also, I noticed you set Trusted_connection to NO. Is this because you use a user and password or what? Rafael El 19/07/2010 11:47, Dave Crozier escribió: > Rafael, > This will work on SQL Server 2008 and if you make the cServer_Name > "192.168.1.1\SQLEXPRESS" then it will work for SQL Express servers. > > cUser="sa" > cPassword="sa" > cServer_Name="192.168.0.1" > cDB_Name="Data" && DBC Container Name Here > > cConnection_String="Driver={SQL Server};" ; > +"Pwd="+cPassword+";" ; > +"Persist Security Info=True;" ; > > +"UID="+cUser +";" ; > +"Database="+cDB_Name+";" ; > +"Server="+cServer_Name+";" ; > +"Trusted_Connection=No" > > Dave C > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Rafael Copquin > Sent: 19 July 2010 15:24 > To: ProFox Email List > Subject: VFP and SQL (was Large Data Tables) > > >> 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.
