[ODBC Driver Manager] Data source name not found
ERROR [IM–2][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Any suggestion to resolve this ASAP?
This is fresh install of SmartConnect and had not been imported from any other environment. In reality source file which are .txt or .csv is working fine and imported without any errors into GP. This is when I try to open Excel 2000 or higher version of Excel that I face this error.
Is the client running 64bit Office? It needs the 32bit Office drivers.
To summarize, first you must download the 32-bit version of the accessDatabaseEngine file at http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255 and run this from the command line using the ‘/passive’ flag to allow GP to connect to the spreadsheet.
1- Download 32-bit version of AccessDatabaseengine
2- Place download in your desired directory
3- Install 32bit driver in passive mode
3A- You will get an error if you try to install the 32 bit driver by double clicking it
3B- You need to open the command line (Start–>Search–>cmd)
3C- type in the path to the AccessDatabase Engine you downloaded then space /passive
4C- Example: C:GPSharedSmartConnectAccessDatabaseEngine.exe /passive
I had to do some testing to get the proper command line prompt and wanted to share with everyone. Thanks for pointing me in the right direction DHomes.
If you would like to submit an answer or comment, please sign in to the eOne portal.