SQL Reporting Services Error - Ad Hoc Query Error

Posted on 2011-10-11
Last Modified: 2012-05-12
Hello Experts,
I'm changing up a recent question a little bit to see if I can make any headway on this issue.

I'm getting an SQL reporting error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'GoldMine'. (rsErrorExecutingCommand)
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

My SQL Reporting Services Server is remotely connecting to my SQL 2005 Server. Is there any error log which could give me a little more information on the real failure???
Question by:ottobock
    LVL 5

    Accepted Solution

    LVL 3

    Assisted Solution

    Seems like your datasource is not working..

    Why are you using "OLE DB provider "Microsoft.Jet.OLEDB.4.0" as datasource??

    Have you tried "Microsoft SQL Server (SqlClient)"??

    LVL 25

    Assisted Solution

    I second srm74 idea. Just check whether your report can connect to the server and fetch the data. I perfer doing if form BIDS.
    LVL 7

    Author Comment

    Thanks for the ideas. The datasource is a simple XLS spreadsheet. What I now believe is the connection string (that I cannot find!) is looking for a drive rather than a share. (\\server\e$\share\xls instead of \\server\share\xls). I've gone back to the developer of this process to investigate further, as I've spent a ton of time trying to find where this connection is defined.

    Side note: I can run this query successfully, and return the spreadsheet contents:
    SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\\server\share\file.xls', 'SELECT * FROM [Sheet1$]')

    This is why I was hoping there could be some log file I missed that may help me out. I'm a few hairs less after getting this problem. :-)
    LVL 7

    Author Comment

    Issue found.

    Nearly the same query as above was embedded into the reports themselves. Problem was that the query was looking for the XLS using a UNC with was no longer valid...

    So the creator of the reports had to drudge through each individula report and fix the query.

    Thanks everyone!

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Introduction Earlier I wrote an article about the new lookup functions ( that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now