Skip to Content
author's profile photo Former Member
Former Member

Acess Denied while reading more than 1000 records

While drill down to detail , if the no of records are more than 1000 , after few seconds (60-80) I got below error

'Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SQL State: 08001 Native Error: Error in File C:\WINDOWS\TEMP\

<<Text removed by moderator>>

Edited by: Matt on Dec 7, 2010 8:16 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 03, 2010 at 02:35 PM

    Assuming this is .NET app so moved your post to .NET forum.

    Not much info to go on so I'll ask.

    What version of CR are you using?

    What patches are installed?

    is this an application?

    What dev language did you write it in?

    Is it a WEB or Windows app?

    Can you duplicate the problem consistently?

    Thank you


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 18, 2010 at 03:45 PM

    If it doesn't work in CR Designer it won't work in an app either. Post your question to the Report Designer forum to get the report working first.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.