Hello!

We are currently running Sql Server 7.0 with databases in 6.5-compatibility
mode for DB-Library.
The customer is starting to think about an upgrade of their systems.

- Will db-library still be supported in Sql Server 2005?
- If so, is the behaviour exactly the same as before or has anything been
changed?
- and, what features will we be "missing out of" by continuing to use
DB-Library to communicate with Sql Server?
- Any informatin regarding how long the support for DB-Lib will continue for
future releases of Sql Server?

Thanx

Hi

No work has been done by Microsoft on DB Library since SQL Server 6.5. It is
still in the MDAC stack, so your applications will continue to work.

You are 3 technologies behind the current access methods (Managed Providers,
OLE DB and ODBC, in reverse order).

Microsoft has said that DB library may not be supported in future versions
after SQL 2005.

DB library does not support any of the datatypes introduced with SQL Server
7.0 and 2000 and you loose out on connection pooling.

Move your application to OLE DB, the latest technology that is not .NET
based (Managed Provider).

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]