SQLSRV & SQL Native Client 2008

Question

Hi,

I'm working on a windows 2008 server with SQL 2005 SP3 with a bunch of classic ASP sites that are using SQLOLEDB to connect.

I have a new application that requires SQL Native Client 2008 installed because it is using the SQLSRV PHP Driver. SQL Native Client 2005 is already installed.

If I install SQL Native Client 2008 will I still be able to connect using SQLOLEDB? Are there any breaking changes between the 2005 client & 2008?

Can the 2008 client be uninstalled back to 2005?

Cheers

Stuff

Answer 1

The SQL Native clients are all separate, you can install all versions at the same time.

You can still use SQLOLEDB with the Native Client 2008 installed.

Installing Native Client 2008 will not affect any of your existing software.

You can also uninstall the 2008 Native Client, and it won't mess up your system.

---

Rob