Export (0) Print
Expand All

Programming FAQ

SQL Server 2000

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

Answer:

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?

Answer:

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?

Answer:

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?

Answer:

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