I'm developing an application that must support connecting to SQL
Server 2005 as well as SQL Server 2000. Which driver should I use for
the connection?

1. Use SQL Native Client driver for both 2005 and 2000.
2. Use SQL Server driver for both 2005 and 2000.
3. Use SQL Native Client driver for 2005 and SQL Server driver for
2000.

My experimentation has shown that option #3 gives the best performance
for my application but it introduces some extra complications during
setup.

Any thoughts? Any documentation that details the differences between
these drivers?

Mark
Atlanta GA