Programming FAQ
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.