#Odbc excel connection string install#
#Odbc excel connection string drivers#

NOTE: Make sure you have the correct rights to run PowerShell scripts before attempting to run these commands or get the network administrator to execute them.

#Odbc excel connection string drivers#

To verify the drivers that are installed, we can use Microsoft PowerShell to get the list of drivers and their versions. Each workstation where SmartConnect is running will have its own set of ODBC Drivers installed so while a map pointing to Excel on one machine works, it is possible that another machine does not have the same set of drivers loaded and the connection cannot be made. I am sure you are wondering how do I know what drivers are installed on the machine.

NOTE: SmartConnect is a 32-Bit application so it requires the 32-Bit version of any ODBC driver to be able to make the proper connection to the ODBC Data Source.

#Odbc excel connection string install#

The first step on fixing this issue is to determine what connection is being made and then determine which ODBC driver to install or valid on the current machine or machine that is producing the error. The most common error received when connecting to a data source that uses an ODBC Driver is вЂњData Source Name not found and no default driver specifiedвЂќ, which means the specific ODBC driver required is not installed on the current machine.

The only difference is how you are able to query the data which is a topic for another time.

Selecting Excel 2013 from the ODBC Connections window will require the same driver as selecting Excel 2013 Data Source drop down list. The same goes for using the ODBC Connection type and selecting an option during the Connection String setup. To make connecting to these files quicker and easier, SmartConnect contains a list of Excel versions that can be selected or we can just pick Text File from the source list and pick our file.Д®ven though we can select from a pre-defined list, it does not mean the ODBC Driver that is used for making the connection is installed on a machine that needs to run the integration. One of the most common methods of integrating data using SmartConnect are Microsoft Excel Files or flat files such as comma or tab delimited.