Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error in connecting HDP 2.3.4 and SSRS

Error in connecting HDP 2.3.4 and SSRS

While connecting HDP and Microsoft SQL Server Report Builder, while doing settings in the Data Source Properties.

i get the following error:

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

2921-capture.png

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

While clicking on Build, shown in the image above, I get connecting successful inside connection Properties:

But when I do test on Data Source properties I get the error mentioned above, what am I missing here?

Following is my Hortonworks Hive ODBC Driver Connection Dialog:

2922-capture1.png

1 REPLY 1
Highlighted

Re: Error in connecting HDP 2.3.4 and SSRS

Super Guru

Can you access Hive by any other means? Is it working in Excel or another tool?

Did you restart the machine and try again? Also who owns the driver? Can you turn on ODBC Tracing to see more details.

Don't have an account?
Coming from Hortonworks? Activate your account here