Monday, February 20, 2012

Is ntwdblib.dll freely distributed by Microsoft?

We have just installed SQL 2005 on a brand new server and have installed our software for our business solution. When I attempt to run the program, it says that it cannot find "ntwdblib.dll" Where is this file? Am I missing a file from the install or what?

The error indicates that your application uses the DB-Library API. SQL Server 2005 does not include the files needed to do programming work on applications that use these APIs.

The recommended alternatives are captured in SQL Server 2005 Books Online in section "Deprecated Database Engine Features in SQL Server 2005", which can also found at MSDN at http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx:

Other

DB-Library

Embedded SQL for C

Although the SQL Server 2005 Database Engine still supports connections from existing applications using the DB-Library and Embedded SQL APIs, it does not include the files or documentation needed to do programming work on applications that use these APIs. A future version of the SQL Server Database Engine will drop support for connections from DB-Library or Embedded SQL applications. Do not use DB-Library or Embedded SQL to develop new applications. Remove any dependencies on either DB-Library or Embedded SQL when modifying existing applications. Instead of these APIs, use the SQLClient namespace or an API such as OLE DB or ODBC. SQL Server 2005 does not include the DB-Library DLL required to run these applications. To run DB-Library or Embedded SQL applications you must have available the DB-Library DLL from SQL Server version 6.5, SQL Server 7.0, or SQL Server 2000.

|||

I'm running into a similar problem, and was wondering if the NTWDBLIB.DLL file is a freely distributable file from Microsoft? If it is, then the file could be distributed with our application to ensure that it works with SQL Server 2005 database engine.

I understand that this would be a short-term solution, until the next build of Microsoft's SQL Server engine comes out, which will not support connections from DB-Library APIs.

No comments:

Post a Comment