having problem in running report in client system

Question

0.00/5 (No votes)

See more:

.NET3.5

I have developed a software for my client. Every thing is working correctly. I have created report using report wizard in visual studio 2010. When i am running the reports page in client's system i am getting an error as "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist access denied."

How, can i resolve this problem and run report form in my client's system?

Posted 28-Oct-13 1:27am

sam9918

Add a Solution

Comments

thatraja 28-Oct-13 7:30am

reports? which one? crystal? ssrs?

sam9918 28-Oct-13 7:35am

reports

thatraja 28-Oct-13 8:08am

are you kidding? which reporting tool you're using?

sam9918 28-Oct-13 8:10am

the one what comes with visual studio 2010 inbuilt. I don't why i am getting error in client's system. Its working fine in my system.

thatraja 28-Oct-13 8:17am

:'(
what's the extension of report files? Always include complete details in your question for quick response.

sam9918 28-Oct-13 8:20am

.rdlc

sam9918 28-Oct-13 8:21am

.rdlc is the file created from report wizard and i have displayed my report.rdlc in report viewer as well.

thatraja 28-Oct-13 8:28am

check my answer

sam9918 28-Oct-13 9:03am

what could be the main problem of this error according to you? connection string or sql server? or any other thing?

thatraja 28-Oct-13 9:05am

Did you check those links in my answer? There explained things clearly.

sam9918 28-Oct-13 9:07am

yes. checked every link and found "problem regarding rdlc" link useful. But, my other form's content is running with the same connection string. But, why my report is not working with that connection string. Rest, i have checked the tcp/ip port all are fine.

thatraja 28-Oct-13 9:09am

How do you bind your report? ObjectDataSource? include the code in your question & tell me

sam9918 28-Oct-13 9:10am

with object data source.

thatraja 28-Oct-13 9:14am

Check updated answer

sam9918 28-Oct-13 9:17am

i am reading the connection string of my client's system from a file. i.e., i have created a code to read connection string from con1.txt which is present with the code. we, just need to change the server name of connection string and then can used to work in any system with any server name. can their be a problem in reading connection string from file for reports?

sam9918 28-Oct-13 9:19am

what i want to say is that in app.config file of my application i have removed the connection string and tried to change the connection string at run time but that didnt worked as well. i was facing the same problem.

thatraja 28-Oct-13 9:04am

I can't & I won't. And no one won't.

2 solutions

Solution 1

This error is related to database(SQL server).
Here similar question which's solved
problem regarding rdlc[^]
also check this
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exit or access denied..[^]
Nice tutorial on RDLC
How to do a simple RDLC report using Visual Studio[^]
EDIT
-------------------------
I think your ObjectDataSource's connectionstring is wrong(or it's not changed), so you have to change the connection dynamically. Check this
Changing the connectionstring of a wizard generated TableAdapter at runtime from an ObjectDataSource[^]

Posted 28-Oct-13 2:28am

thatraja

Updated 28-Oct-13 3:13am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sam9918 · Accepted Answer · 2013-10-28T03:20:00

Solution 2

here's is how i have added my rdlc report and presented in my application
this is link from where i took the help.

Create RDLC report in visual 2010[]

Posted 28-Oct-13 3:20am

sam9918

Updated 28-Oct-13 3:23am

v3