Typical messages will state the driver has not been installed. We have tested this method, and could not get it to work in the UI. Latest Additions Most Popular. 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. Email Required, but never shown. Categories Recent Discussions Activity Unanswered.
|Date Added:||7 December 2013|
|File Size:||57.40 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
The only difference is how you are able to query the data which is a topic for another time. March edited March in – XESame. Entering a number in Excel will automatically default it to a number value, while the ODBC connection only supports alphanumerical values.
Troubleshooting ODBC Data Source Errors in SmartConnect
Latest Additions Most Popular. Forum Software Powered by Vanilla.
Make sure the object exists and that you spell its name and the path name correctly. We had the same problem. Nevertheless, it doesn’t work.
The Microsoft Jet database engine could not find the object
If the file does not exist the folder specified, the error will point to the missing file name. Sign up using Email and Password. If you want to get involved, click one of these buttons! We have tested this method, and could not get it to work in the UI.
When I run this test, here is the error I get: If this does not help, you could try to use the name you gave to the ODBC connection as table name in the from.
For example, if you are currently editing the spreadsheet, and testing it in the UI, it will fail, and give the following ecxel message: Welcome Guest Login Register. An invalid odbc query syntax will generate a generic error regarding parameters or missing command. The excel file is in the root folder of the project.
I am sure you are wondering how do I know what drivers are installed on the machine.
Troubleshooting ODBC Data Source Errors in SmartConnect | eOne Solutions
It is already opened exclusively by another user, or you need permission to view its data. In my example here, it is the DefaultDir. When using the column in a query, the actual name should be used from the Excel column header. Make sure the object exists and that you spell its name and the path name correctly.
For more information on troubleshooting this error, see “Troubleshooting Data-Driven Unit Tests” http: Make sure you have the correct microsovt to run PowerShell scripts before attempting to run these commands or get the network administrator to execute them. Not sure if this is viable in your case.
You can use this file on microsort machine that is running SmartConnect successfully to compare it with a list from a non-working client machine.
The unit test adapter failed to connect to the data source or to read the data. I had the same problem when deploying my tests with mstest. While SmartConnect uses ODBC for connecting to many different data sources the drivers required for those connections are going to be specific to the environment and may even differ per user machine and server.
The file name is displayed in the Query window.