Microsoft odbc text driver unknown is not a valid path

Even 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. The only difference is how you are able to query the data which is a topic for another time.

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.

I am sure you are wondering how do I know what drivers are installed on the machine. 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.

To verify the drivers that are installed, we can use Microsoft PowerShell to get the list of drivers and their versions. 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.

If the currently logged in user does not have the necessary rights, you will need to contact the IT administrator to get the proper access or run the following commands. Since SmartConnect is a bit application, it will only work with bit ODBC drivers, so we can add a parameter to look for just bit drivers.

You can use this file on a machine that is running SmartConnect successfully to compare it with a list from a non-working client machine. This shows the function in SmartConnect, the driver and version used and what type of data for the connection. When the Access Drivers are not installed or the bit version only is installed we will get an error regarding the data source not found.

An invalid odbc query syntax will generate a generic error regarding parameters or missing command. Make sure the column names are referenced correctly within the query since SmartConnect removes the spaces when displaying the data. After restarting Excel, we are again able to open it until the next time the error shows up.

It seems like Excel is acting up and not closing some of the exclusive locks as explained nicely here. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

Learn more. Ask Question. Asked 7 years, 3 months ago. Active 6 years, 5 months ago. Viewed 3k times. Fill dt ; dataGridViewFileContents. Dispose ; conn. Close ; conn. Fill dt ; " line I'm getting: System. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

What am I doing wrong or failing to do here? Search related threads. Remove From My Forums. Answered by:. Archived Forums. NET Managed Providers. NET managed providers, especially System. SqlClient, System. Odbc and System. Sign in to vote. OS is Vista. If anybody know pls reply. Thursday, January 17, AM. Since you're using impersonation and integrated Windows authentication I would suspect that you're being denied on the hop to the remote server, where the database is located.

Basic authentication would probably work but with integrated Windows authentication credentials cannot be forwarded to the remote machine unless Kerberos is enabled to provide the authentication from the web server to the remote server. Essentially it's not an issue with your code but with the security configuration of your network.

Tuesday, December 23, PM.