Making a C# Program connected to SQL server that can be installed on any computer

Question

0.00/5 (No votes)

See more:

Hello,
I have a big problem. I made a C# program that connects to a SQL-Server database that is found on the local system (on the same computer) but my problem is that I want to publish my project so that it will be installed on any computer without having to install the full version of SQL-Server and also without having to change the connection line which is hard coded. Is there a way to do this ????? Thanks in advance .

Posted 30-Aug-13 13:09pm

Sammy FCI

Add a Solution

Comments

Boipelo 30-Aug-13 19:49pm

You can still create a config file so you are able to change the connection string at will. I dont see another way. At least you have learn not to hard code the connection string in your application.

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)

Dave Kreskowiak · Answer 1 · 2013-08-30T15:03:00

Solution 1

Move your connection string to the app.config file. You can then change the connection string to put the server name or IP address that the SQL Server is on in that. I usually use easily replaceable tags in the connection string to put in a username and password for the application to use. These values was either be entered by the user or encrypted and stored separate from the connection string.

Posted 30-Aug-13 15:03pm

Dave Kreskowiak

Comments

Sammy FCI 31-Aug-13 15:43pm

Ok but does this mean that the user of the program must have SQL - Server application installed on his computer if he wishes to work on the local host or is there a kind of lite SQL that can be placed in the published pacakage of the program so that when the program is installed a lite version of sql server is installed too ?? If there is a lite version please give me the link to it. Thanks in advance

Dave Kreskowiak 31-Aug-13 16:31pm

SQL Server Express. Google it.