On Wed, Feb 4, 2009 at 6:53 PM, Rafael Copquin <[email protected]> wrote: > 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. ------------------------------------
What is the SQL Server version that they are using today? What are the installed ODBC drivers for the clients? this will layout what you can use as for your connection strings: covers 7 & 2000 <http://www.connectionstrings.com/sql-server#7> for 2005 http://www.connectionstrings.com/sql-server-2005#109 You will use a userid/PW to connect and you can have a different one for each branch. <better for who is doing what from their IT POV. -- Stephen Russell Sr. Production Systems Programmer First Horizon Bank Memphis TN 901.246-0159 _______________________________________________ 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.

