I got away from the NC drivers a long time ago. Currently using 17 for pretty much everything.
-- rk -----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of António Tavares Lopes Sent: Wednesday, April 8, 2020 11:12 AM To: [email protected] Subject: Re: SQL Server 17 - ODBC or Native Client? Frank, With SPT, there is no big feature difference between NC and recent ODBC drivers. If you're using NC, you can safely migrate to the more recent drivers. You may find bigger differences between the old "SQL Server" driver and the following versions because of the way they handle SQL datatypes, and how they are mapped into VFP. But if you're already using NC then you won't face new issues. On Wed, Apr 8, 2020 at 3:40 PM Frank Cazabon <[email protected]> wrote: > Hi, > > I'm testing a VFP app against a SQL Server 2017 database. I use > "DRIVER=SQL Server Native Client 11.0" in my connection string for SQL > Server 2012 and 2014. I don't think there is a newer version of Native > Client than 11. Should I be using the "Driver={ODBC Driver 17 for SQL > Server}" instead? > > -- > > Frank. > > Frank Cazabon > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/mwhpr1001mb2144e3477dcbb5658def322fd2...@mwhpr1001mb2144.namprd10.prod.outlook.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.
