Industrial Automation
Industrial Automation | Europe


Main > Product Type > Software
Minimize Text   Default    Enlarge Text


How To Add Missing ODBC Data Sources

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.

Comments (View All Comments / Add Comment)

Related Articles
No related articles found.
Created 2017-07-28
Modified 2017-07-28
Views 4661


You are not logged in.