SSRS sql reports accessing data from both excel and database

Is it possible to pull data from excel and a database within the same report if excel has not been installed on the server computer?  I have tried adding it in ODBC following a couple examples but its not working.
'The specified DSN contains an architecture mismatch between the Driver and the Application'

Thank you!
HSI_guelphAsked:
Who is Participating?
 
ScriptAddictCommented:
The error message you are getting relates to different numbers of bits being used.

Chances are you are using a 64 bit driver when you should be using a 32 bit driver, or vice versa.  

I'm going to guess your on a 64 bit machine trying to access a 32 bit program using the 64bit odbc drivers.

-SA
0
 
ScriptAddictCommented:
I don't see why not, in crystal reports you can access an unlimited number of connections.  I assume in SSRS there is similar functionality.  

Perhaps try a different connection type then ODBC such as a DAO connection.
0
 
HSI_guelphAuthor Commented:
What I've found says it needs to be ODBC and when I go looking for the .xls file I can't seem to find it, its like it doesn't exist within the browse explorer (when opening files).

Oh I forgot to mention I'm using MS SQL Server 2008 R2 and Visual Studio 2008 with Sharepoint foundations.  Perhaps it's only possible in a more expensive version?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ScriptAddictCommented:
I'm not very familiar with SSRS since I'm a crystal guy.  

If that doesn't work, could you use a subreport?

I'd request additional attn see if you can get an SSRS guy to offer better advice.

-SA
0
 
HSI_guelphAuthor Commented:
I have found out that it is possible but now I just don't understand why I'm getting errors.
0
 
HSI_guelphAuthor Commented:
When I create the DNS I can choose Excel 12 but in BIDS I only get up to Version Excel 97-2000, could this be the problem?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.