SmartConnect 2021 Error With Excel Data Sources: “Data source name not found and no default driver specified”

We’ve recently upgraded a client from SmartConnect 2018 to SmartConnect 2021 and mosstly had no problems. One issue which came up is when users tried to run an integration which had a Microsoft Excel file as the data source. Each time they tried the integration, and on several machines, they always received the same error:

Connection could not be validated

ERROR [IM002] [Microsoft][ODBC...

Continue Reading azurecurve’s Article on their blog

SmartConnect 2021 Error With Excel Data Sources: “Data source name not found and no default driver specified”

We’ve recently upgraded a client from SmartConnect 2018 to SmartConnect 2021 and mosstly had no problems. One issue which came up is when users tried to run an integration which had a Microsoft Excel‎…

Blog Syndicated with azurecurve’s Permission