We have several different SQL Server versions in our datacenter, with
SQL Native Client 9.00.1399.06 on our Citrix servers.

The above SQL Native Client goes with our Great Plains app client,
it's possible we will have a new, higher-level SQL Native Client
installed by another application client...

Can different Native Clients exist on the same server, can newer
Native Clients accommodate older SQL Server versions and
applications???

Issues or 'gotchas' I should know about??

Thank you, Tom

tom12010 (tlyczko (AT) gmail (DOT) com) writes:
Yes.

Yes. With the one restriction that if you want to connect to
SQL 6.5, SQLOLEDB is your only option.

Note also that to use the new version of SQL Server Native Client, you need
to change your connection string.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Later I found this:

"Microsoft SQL Server Native Client 10.0 is installed when you install
SQL Server 2008 R2 or the SQL Server tools. If the SQL Server 2005
version of SQL Server Native Client is also installed on the computer,
SQL Server Native Client 10.0 will be installed side-by-side with the
earlier version. SQL Server 2008 R2 Native Client will overwrite SQL
Server 2008 Native Client."

Thank you, Tom

On Aug 6, 4:55*pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote: