As a newbie in the use of VFP as a front end with a SQLServer Express database as a backend, I managed to establish a connection locally and read, update, delete, etc. a test database.
All of this is done on my notebook, where I have sqlserver express 2005 installed. The connection is done via ODBC. But the whole point of my self training is to be able to move an existing application's database to sqlserver, using VFP 9 as a front end. The client has a head office, where the sqlserver would be installed on a Windows 2003 server, and the idea is that access to the data is done remotely from the different branches of the company (nothing new here; I am sure that 90 % of the SQLServer apps work this way). Using Logmein I can install modifications to the application exe remotely. (the exe would be residing in every one of the branches, 5 so far). But in my ignorance, I have no clue on how to establish an IP connection from the branches to SQLServer. In the head office there is of course a router which provides internet access to the server. I understand that I have to open ports 1433 and 1434 (I got this from reading an article in the Internet). So I set up the above ports in the router and directed them to the server PC. But how do I connect from any of the branches to the server instance of SQLServer? As a test, I just want to update a customer table in the database with a new record. The SQL statement is straightforward, so no problems there. It is just the connection that baffles me. Any help (with a code snippet please) would be greatly appreciated. TIA Rafael Copquin _______________________________________________ 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/14f9626556624e06923a52b2d85ec...@rafael ** 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.
