Hi Steve,

You will need to upgrade the client machines to the SQL Server Native Client 11 driver.  We didn’t do testing with the older driver against later versions of SQL Server and there may well be compatibility issues (syntax, etc.).  As well, the newer driver affords performance benefits over the older one, as well as bugs fixes.  One caution: there is a similarly named driver that is *not* compatible with TMS -- “ODBC Driver 11 for SQL Server” – you must continue to use the “Native Client” family of drivers.

Another consideration is version of SQL Server itself.  We deprecated SQL Server 2008 R2 starting with TMS 2012, so for TMS 2016 we support SQL Server 2012 and 2014.

Hope this helps.  Let me know if you have any further questions.

Best,
Ethan

---
Ethan Kalfus | Director, Development
[log in to unmask] | 646.733.2239 x232
GallerySystems | www.gallerysystems.com<http://www.gallerysystems.com/>


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Moore, Steven
Sent: Thursday, June 2, 2016 8:54 AM
To: [log in to unmask]
Subject: SQL Server Native Client


Does anyone know if it is OK to use SQL Server Native Client 10 (ie, the one we use with TMS 2012) for TMS 2016?  Just wondering if I can keep that in place or need to change it to v11 as part of installs.  Thanks!
Steve

Steven Moore
Database Administrator
The Museum of Modern Art (MoMA)
11 West 53 Street ~ New York, NY ~ 10019
[log in to unmask]<mailto:[log in to unmask]>
Phone:  011.33.62.782.1223

[http://thinkbeforeprinting.org/struct/signature-1.gif]
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.