Skip to content
+1-888-319-3663

COMMUNITY FORUM

This driver has not been installed

john.ellis@tribridge.com asked 9 years ago
Hello:

Our client has created several maps in SmartConnect 2012, using a wide variety of data sources.

Now, when trying to create a map using any Excel data source, they get a "Data source name not found and no default driver specified".

Also, they get a SmartConnect error that says "This driver has not been installed" when they try to create a map with an ODBC connection to Excel.

They have used these data sources, before.  Why is this happening all of a sudden?  More importantly, what's the remedy, especially since Excel drivers are indeed installed on this box?

John
Answers
Best Answer
ken.hepworth answered 9 years ago
Hi John,

Could you just check whether they have installed the 32-bit or 64-bit driver? If it is the 64-bit driver this is why they will get this error and they will need to install the 32-bit driver instead.

Regards,
Ken
john.ellis@tribridge.com replied 9 years ago

Hi There, Ken:

Thanks, for your prompt reply!  I have had a very crazy/busy day and have not had the chance to update the Forum.

Yes, this worked perfectly!  This AM, we had put in a support request and this was the successful resolution!  🙂

Thanks, again!

John

jim.slinn@dtm.ca replied 8 years ago

so where does one get the 32 bit driver to install.  i have a client with the same problem.
Do i need to load on each workstation and the server or jst the workstations

Lorren Zemke Staff replied 5 years ago

Jim,

You can download the 32-bit Access ODBC Drivers as well. https://www.microsoft.com/en-us/download/details.aspx?id=13255, which are basically the JET database drivers used by excel as well.

Lorren

Lorren Zemke Staff replied 5 years ago

Sorry, they need to be installed on any machine where you want to read data from excel with SmartConnect.


If you would like to submit an answer or comment, please sign in to the eOne portal.