I had forgotten about that URL. I checked and there is an example of something like what I'm looking for. I'll test it when I visit the client this week.
Thank you Rafael ----- Original Message ----- From: "Stephen Russell" <[email protected]> To: <[email protected]> Sent: Wednesday, February 04, 2009 10:03 PM Subject: Re: remote access with sqlserver express 2005 > 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 > [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/001701c9877e$8f25d4a0$6401a...@rafaelpc ** 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.

