Introduction
When using ODBC data sources and deploying your solution to target machines you may find the Operating System does not include all ODBC data sources by default. Also the driver versions may be different, or named differently if they are installed in a different language. This can cause application errors like the following:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 2.[Microsoft][ODBC Microsoft Access Driver] Syntax error
in FROM clause.[Microsoft][ODBC Excel Driver] '(unknown)' is not a
valid path. Make sure that the path name is spelled
correctly and that you are connected to the server
on which the file resides.
Viewing ODBC drivers
You can view the ODBC drivers installed on a PC by launching the "Data Sources (ODBC)" shortcut and selecting the Drivers tab:
Installing ODBC drivers
The required drivers are normally installed as part of the software client. For example SQL, Access or Excel ODBC drivers are normally installed as part of your SQL Server, Microsoft Access or Microsoft Office installation respectively. You can also download and install the appropriate ODBC driver pack. You can find the drivers for Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files on Microsoft Access Database Engine 2010 Redistributable page.
