Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

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!
0
HSI_guelph
Asked:
HSI_guelph
  • 3
  • 3
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
HSI_guelphAuthor Commented:
I have found out that it is possible but now I just don't understand why I'm getting errors.
0
 
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
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now