DB-Library is a Call Level Interface that allows C applications to access Microsoft® SQL Server™ 2000. DB-Library was the original application programming interface (API) that allowed applications to access SQL Server, and remains specific to SQL Server.
The DB-Library API has not been enhanced beyond the level of SQL Server version 6.5. All DB-Library applications can work with SQL Server 2000, but only as 6.5 level clients. Features introduced in SQL Server 2000 and SQL Server version 7.0 are not supported for DB-Library applications.
SQL Server 2000 does not include a programming environment for DB-Library for Microsoft Visual Basic®. Existing DB-Library for Visual Basic applications can run against SQL Server 2000, but must be maintained using the software development tools from SQL Server version 6.5. All development of new Visual Basic applications that access SQL Server should use the Visual Basic data APIs such as Microsoft ActiveX® Data Objects (ADO) and Remote Data Objects (RDO).
While the DB-Library API is still supported in Microsoft SQL Server 2000, no future versions of SQL Server will include the files needed to do programming work on applications that use this API. Connections from existing applications written using DB-Library will still be supported in the next version of SQL Server, but this support will also be dropped in a future release. When writing new applications, avoid using DB-Library. When modifying existing applications, you are strongly encouraged to remove dependencies on DB-Library. Instead of DB-Library, you can use ADO, OLE DB, or ODBC to access data in SQL Server.