INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SSRS 2012 with MS Excel ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found an

SSRS 2012 with MS Excel ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found an

SSRS 2012 with MS Excel ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found an

(OP)
I'm hoping someone here can help me sort this out. I've got an Excel spread sheet that I built a report in using VS2010. The shared datasource is set up as an 32-bit ODBC DSN. It runs fine on my development machine (win 7 Pro 64-bit). I deploy the report to my SSRS 2012 report server and everything is there, Datasource, dataset, report. I'm getting an error when I run it and when I test the datasource within SSRS. The error is "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

The server is Windows Server 2008 64-bit, has MS Office 2007 installed and the MS Office Access database engine 2010. I have triple checked that the ODBC DSN precisely matches the one on my Development machine, both created from C:\Windows\SysWOW64\odbcad32.exe. The authentication for the odbc dsn and datasource are configured to use Windows Authentication, so I could understand an error for some users who tried to run it but in all tests I'm using a domain admin account which has full permissions on the network folder where the Excel spread sheet is stored. All other reports on the report server are running perfectly, but are all using SQL db datasources. This is my first attempt at deploying a report with an Excel DS.

I've been through a number of posts on Technet, SQLServerCentral, and others but can't seem to find a solution that works for my case. The only difference I'm seeing between the two environments is that on my dev machine SSDT is installed and for some reason it wasn't on the SQL Server. Could that be the problem, considering the datasource is actually an excel spreadsheet and not a SQL DB?

Thank you, in advance, for any insight you can offer.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close