On Wed, Jun 9, 2010 at 7:35 AM, Rafael Copquin <[email protected]> wrote: > 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? -----------------
You have to define the SERVER properly. SERVER=RAFANUEVA\SQLEXPRESS will fail if connecting through the internet. You will need to have the server in the DMZ, a dangerous place for it, or behind the firewall where outside users will need a VPN to gain access to that network. Your client may have their network set up that everyone sees properly through the network an AAA.BBB.CCC.123 can be pinged. As a heads up I would change the PORT number for SQL Server communications as well. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
