how to store the connection strin in Microsoft Visual Studio 2008 using VB.NET as front end and SQL SERVER 2005 as Backend

Question

0.00/5 (No votes)

See more:

i m using Microsoft VS 2008 and in that VB.NET as the language
the problem is i m not able to store connection string every time machine changes have to keep on changing the connection string

i have searched browsed, surfed done everything but still not able to find the proper answer

please help!!!

thank you.

Posted 7-Sep-11 4:00am

Nazneen s

Add a Solution

3 solutions

Solution 4

You could save it to My.Settings, just add a field and just type:

VB

My.Settings.NewField = "Something..."

Or

VB

Something = My.Settings.NewField

Posted 11-Sep-11 3:16am

jerryeagle

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)

Abhinav S · Accepted Answer · 2011-09-07T04:04:00

Solution 1

You can put the connection string in an external file (say app.settings or even a text file).
Make sure this is installed along with the product on the client.

Once that is done, you should quite easily be able to change the string.
Remember, if you are going to change the database server, you will need to change the connection string.

There is no way to avoid this change.

Posted 7-Sep-11 4:04am

Abhinav S

Comments

Wendelius 7-Sep-11 12:39pm

Moved from OP's answer: "please elaborate a little i should add a text file in my project and store my machine's connection string in that?"

Nazneen s · Accepted Answer · 2011-09-07T04:29:00

Solution 3

please elaborate a little i should add a text file in my project and store my machine's connection string in that?

Posted 7-Sep-11 4:29am

Nazneen s

Comments

Wendelius 7-Sep-11 12:40pm

Instead of adding a new answer, use "Have a Question or Comment" link in the bottom of each answer to send a comment. This way the author of the comment gets notified.