Project with local database on another pc not working

Question

0.00/5 (No votes)

See more:

Hi. I have a project with local database perfectly working on my PC but when I copy it on another PC it is not working. I have installed SqlLocalDb.msi file on another PC but still it is not working. This is my connection string:

What I have tried:

C#

<>string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ProfessorDb.mdf;Integrated Security=True;User Instance=True";

Can you please help me?

Posted 21-Feb-16 22:10pm

PeMaCN

Updated 21-Feb-16 22:29pm

v2

Add a Solution

Comments

Richard MacCutchan 22-Feb-16 4:21am

What does "not working" mean?

PeMaCN 22-Feb-16 4:27am

The error comes up but it is cought in try and catch so I cant tell you the text of error. Can you tell me how the connection string should look like if I want to use project on another PC?

CHill60 22-Feb-16 4:32am

If the error is caught in a try/catch then you should be able to tell us the text - unless your catch block is empty - don't do that.
Use your debugger and let us know what the error is, otherwise we cannot possibly help you

Richard MacCutchan 22-Feb-16 4:54am

Then your catch block is written incorrectly. Why do you think try/catch exists?

1 solution

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)

OriginalGriff · Answer 1 · 2016-02-21T22:29:00

First off, if you want to share data, then don't proliferate SQL instances: use a single instance that is visible to all machines that need to share the data, and don't attach a database - create it in the SQL server instance and use that. Attaching is a different process entirely, and it creates a "local copy" for your app's use only: Bad habits : Using AttachDBFileName - SQL Sentry[^]
If you don't want to share data, then don't use SQL Server: use Access, SQLCE, or SQLite instead as they require no server installation.