Native Client 10 or 11 seem to work with all but the earliest of Databases and seems to be the most stable with VFP.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Laurie Alvey Sent: 12 October 2016 11:14 To: ProFox Email List profox@leafe.com Subject: Re: Connection Strings for SQL SERVER
The driver I use for SQL Server Express 2014 is SQL Server Native Client 11.0. Works fine.
Laurie
On 11 October 2016 at 18:04, Stephen Russell srussell705@gmail.com wrote:
The CLIENT hasn't changed but the backend engine you attach to has.
Server=myServerName\SQLExpress;Database=myDataBase;User Id=myUsername; Password=myPassword;
Make sure you get the correct instance on that SQL Express. Not sure if the db came from a vendor or you just spun up an Express server.
On Tue, Oct 11, 2016 at 10:36 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
https://www.connectionstrings.com/sql-server/
Interesting that it's not updated past SQL Server 2012. I'm trying out
an
instance of SQL Server 2014 Express (with tools).
Wonder who updates this site?
[excessive quoting removed by server]