The following few requirements must be met in order to use ODBC Driver for SQL Server:
If you work with SQL Server Compact Edition, the server itself should be installed on the client computer.
- Support for some features of SQL Server 2005 like MARS requires Microsoft SQL Server Native Client. If you need to use these features, you should download and install Microsoft SQL Server Native Client.
- Important condition is that only one ODBC Driver for SQL Server version can be installed on the PC in order to avoid incompatibility.