Index
2016-10-11 10:36mbsoftwaresolutions@mbsoftwaresolutions.com: Connection Strings for SQL SERVER
2016-10-11 10:52Paul Hill : Re: Connection Strings for SQL SERVER
2016-10-11 12:04Stephen Russell : Re: Connection Strings for SQL SERVER
2016-10-12 05:13Laurie Alvey : Re: Connection Strings for SQL SERVER
2016-10-12 05:15Dave Crozier : RE: Connection Strings for SQL SERVER
Back to top
Connection Strings for SQL SERVER

Author: mbsoftwaresolutions@mbsoftwaresolutions.com

Posted: 2016-10-11 10:36:05   Link

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?

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/b9db3b8425067bb0f6dc6e5cf3a81ec7@mbsoftwaresolutions.com

** 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.

©2016 mbsoftwaresolutions@mbsoftwaresolutions.com
Back to top
Re: Connection Strings for SQL SERVER

Author: Paul Hill

Posted: 2016-10-11 10:52:47   Link

On 11 October 2016 at 16:36,

<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?

2016 is the latest...

--

Paul

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CADwx0+KAZXPFig1U+Wu6==xDGsMEoJN_vcPMw1+vcUtc55SRMg@mail.gmail.com

** 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.

©2016 Paul Hill
Back to top
Re: Connection Strings for SQL SERVER

Author: Stephen Russell

Posted: 2016-10-11 12:04:59   Link

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]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAJidMYK8wcerUsPGMf9rQf5V514fa8y9EDebg07Kfa==F8HxQQ@mail.gmail.com

** 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.

©2016 Stephen Russell
Back to top
Re: Connection Strings for SQL SERVER

Author: Laurie Alvey

Posted: 2016-10-12 05:13:45   Link

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]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAMvTR9cQwbp=8JuncDYDye6J_svmj01pbvwZ=rh29ZvF2Jn_nA@mail.gmail.com

** 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.

©2016 Laurie Alvey
Back to top
RE: Connection Strings for SQL SERVER

Author: Dave Crozier

Posted: 2016-10-12 05:15:40   Link

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]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/18725B8CD2D5D247873A2BAF401D4AB2A431956C@EX2010-A-FPL.FPL.LOCAL

** 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.

©2016 Dave Crozier