Skip to content


SC map data checks sql validation task modify query error asked 9 years ago
I am on SC

I am trying to add a map data checks sql validation task
I select the same connection I use for the map which works fine in preview
I select No Data Exists in the Valid If dropdown
I select the RM20101 table and click modify
Smartconnect Query comes up with an unhandled exception error

ERROR [IM002] [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver speciifed

nothing works afterward

Is this resolved in a later service pack?


Best Answer
Chris answered 9 years ago
Do you receive the same error if you don't use a saved connection, and rather type in the connection info using the Custom Connection? I don't think anyone else has reported that so it is unlikely it has been addressed at this point.

Lyn Barr replied 7 years ago

FYI, two years after the original post, I’m having the same issue. The error occurs whether I use a saved connection or a custom connection. I’m using GP2015 R2 (14.00.0898) and SmartConnect

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