Skip to content
+1-888-319-3663

COMMUNITY FORUM

SC map data checks sql validation task modify query error

sid.jayawardena@tmx.com asked 8 years ago
I am on SC 20.13.0.49

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?

 

Answers
Best Answer
Chris answered 8 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.

H
Lyn Barr replied 6 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 20.15.0.47.


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