OK,OK I hear you all guys. Stop thrashing me,please....(:->) Seriously now
No opening of the router port. No violation of the firewall. Use a VPN. I got that. How about Hamachi, from LogMeIn? Rafael Copquin El 09/06/2010 9:35, Rafael Copquin escribió: > As always, very informative and to the point. Thank you. > > Now, I guess my next question (should it be labeled [NF]?) is the following: > > Suppose you have to link two stores, one with the SQL Server installed > and the other one, just a branch, with a local LAN. > > The idea is that the branch can access the SQL database on line in real > time, to retrieve or update information in the database. > > Now, according to SQL Server help, I should open ports 1433 and 1434 in > the head office router to enable the branch to access the database. > > But what would be the connection string at the branch? > > Locally, the connection string looks like this: > > > cConnString=[DRIVER=SQL Server Native Client > 10.0;SERVER=RAFANUEVA\SQLEXPRESS;UID=;Trusted_Connection=Yes;APP=Microsoft > Visual FoxPro;WSID=RAFANUEVA;DATABASE=mytestdb;LANGUAGE=Español;] > > and the command to obtain the handle is: > > nHandle=sqlstringconnect(cConnString) > > The question is: > > How should I modify the above commands at the branch, to obtain a remote > connection handle? > Should I do anything else? > > > Rafael Copquin > > > > > El 08/06/2010 20:45, Rick Schummer escribió: > >> Rafael, >> >> >> >>>> I am beginning to use VFP9 as a front end and SQL server as a backend. I >>>> >>>> >> wonder if any of you can help with examples of code to use ADO with VFP.<< >> >> During my remote data session (presented at Southwest Fox 2009 and German >> Devcon 2009) I tested the performance of each of the VFP data access >> techniques and technologies. For the most part remote views, SQL >> Passthrough, and CursorAdapters using ODBC were about on equal footing >> performance wise. These tests were done from my desktop to a MySQL database >> on a server somewhere in Arizona. The tests were run over and over and while >> each of the technologies took their share of wins, the differences were not >> all that significant. One thing was for sure though, ADO access was normally >> between 25 and 100 percent slower than the native technologies. >> >> Please note that the performance will depend on several factors though >> including but not limited to the backend server, the server itself, the >> wires in between, and the way the queries are programmed. My recommendation >> is to balance the performance with the ease of use and maintainability, and >> how the access fits the existing applications if appropriate. Try and test >> to find the balance. >> >> One of the easiest ways to learn how to use ADO and CursorAdapters though is >> through the VFP 9 (or Sedna) Data Explorer. Create an ADO connection to the >> data. Drill down to a table, and drag it to a PRG. It will create the code >> to open a cursor in VFP that you can use all the native XBase commands to >> manipulate the data, and a simple TABLEUPDATE() to post it back to the >> backend. It is simply magic. >> >> Rick >> White Light Computing, Inc. >> >> www.whitelightcomputing.com >> www.swfox.net >> www.rickschummer.com >> >> >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/4c0fbf16.70...@ciudad.com.ar ** 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.
