Problem in database dataset....

Question

1.00/5 (1 vote)

See more:

currently i been working on University project, i make my database in sql server 2008. in C# side i call the database through dataset (virtual database), when ever i try to run my project on another PC it's give error that no database connected. while i have paste the backup copy of database to the other PC...what is the solution. i dont understand.. thanks in advance.

Posted 25-Jun-13 23:32pm

Nauman Barki

Add a Solution

4 solutions

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)

**Nirav Prabtani** · Accepted Answer · 2013-06-26T20:10:00

Solution 4

Check your ConnectionString.
You have to change ConnectionString
e.g.
the SQL server name, and database Name with Systems Server Name and dbName.

Regards,

Nirav Prabtani.

Posted 26-Jun-13 20:10pm

Nirav Prabtani

ErBhati · Accepted Answer · 2013-06-26T01:44:00

Solution 3

Plz Check your connection string.
The connection string to connect to the SQL server instance needs to be changed - i.e. the SQL server name, and database Name metch with Systems Server Name and dbName.

Posted 26-Jun-13 1:44am

ErBhati

**Zoltán Zörgő** · Accepted Answer · 2013-06-26T00:00:00

You can't "copy" SQL Server, you need to have it installed on the other machine and to have your connection string set up accordingly.
If you have used SQL CE, than you need to deploy all the SQL CE engine in one or the other way.
Please check following links:
http://msdn.microsoft.com/en-us/library/vstudio/bb546200(v=vs.100).aspx[^]
http://msdn.microsoft.com/en-us/library/vstudio/aa983326(v=vs.100).aspx[^]
http://msdn.microsoft.com/en-us/library/bb522540(v=sql.105).aspx[^]

OriginalGriff · Accepted Answer · 2013-06-25T23:41:00

Two major possibilities spring to mind:
1) (Simple to fix) The connection string to connect to the SQL server instance needs to be changed to fit the new environment - i.e. the SQL server available from this machine has a different name, or access details.
2) (Rather harder) The new PC does not have access to any SQL server instance. This means either installing SQL server somewhere where the PC can access it, or changing you software to use a single user database system instead.

Problem in database dataset....

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0