Export (0) Print
Expand All

Programming FAQ

SQL Server 2000

Does SQL Server 2000 come with a new version of DB-Library?


No. DB-Library has not been enhanced for SQL Server 2000. SQL Server 2000 includes the same features contained in the SQL Server 6.5 and 7.0 DB-Library.

Can ODBC 6.5 drivers be used to connect to SQL Server 2000?


SQL Server 2000 is designed to be backward compatible with earlier versions of ODBC applications. The following can be accomplished:
  • An application written to connect to SQL Server 6.5 that uses ODBC 6.5 drivers can connect to SQL Server 2000.

  • The SQL Server 2000 ODBC drivers can connect to SQL Server 6.5.

  • A legacy application that must connect to SQL Server 2000 can be flagged as a 6.5-compatible ODBC application using the odbccmpt utility. For more information, see odbccmpt Utility Utility.

For information about exceptions, see Level 1: Handling Discontinued Functionality.

Where can I find the MDAC redist file with SQL Server 2000?


A copy of Mdac_typ.exe is included on the SQL Server 2000 compact disc in the \MSEQ\x86\odbc folder.

Is it possible to attach properties/variables to the SQL-NS statement?


No. SQL-NS only provides access to the dialog boxes. You cannot preset values for the dialog boxes.
© 2015 Microsoft