Publishing a VS2010 Project to run on a different PC

Question

0.00/5 (No votes)

See more:

, +

OK, this might be a stupid question, but I have written a program on my PC and tested it on my PC & I now want to test it on my son's laptop before I send it to the person who I have written it for.

However, when I install it & run it on his PC it fails with SQL Server errors, and I guess that this is down to the fact that the program has a hard coded Connection in it that says "Data Source=MEDESKTOP;Initial Catalog=KAELC;Integrated Security=True" ... his PC is obviously not called MEDESKTOP, and I have no idea what the end user's PC will be called ...

How do I get around this problem ?!?

Posted 24-Feb-12 7:16am

Gary Heath

Add a Solution

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)

Shameel · Accepted Answer · 2012-02-24T07:37:00

Solution 1

Store your connection the application's configuration file and read it using the ConfigurationManager class in the System.Configuration assembly. This[^] link might be of use to you.

Posted 24-Feb-12 7:37am

Shameel

Comments

Gary Heath 24-Feb-12 18:55pm

Still confused, I'm afraid Shameel. My database is created by SQL Server Data Centre edition, does that mean that a similar "level" of SQL Server will need to be installed on the recipient's PC ?

I suppose I am wondering if I should ignore this all-singing, all-dancing version of SQL Server & just use SQL Server Express ?!?!?

[no name] 25-Feb-12 1:36am

If it is a standalone program that does not access the SQL Server database from a different server, then yes, you should go for the Express Edition.