We help IT Professionals succeed at work.
Get Started

Connection String while Publishing

Last Modified: 2012-04-19
I have an application that I have been developing over the last couple months in Visual Basic, using Visual Studios 2010 Ultimate. I have completed and linked all forms together and now it is time for me to begin linking objects, such as my DataGridView to my SQL database. No problems with connecting to my SQL server, or using SQL commands to SELECT, UPDATE, etc. But trying to be proactive and look at the future, I can see the issue of when I publish and implement the program on someone elses computer, they would be able to connect to my SQL server. How do I set up the project so that when a client installs my application, they can use there SQL server? Do I need to have an installer that would install not only my application but SQL server 2008 and replicate the original database that I had worked with when creating my application, I.E. dataset, SqlTableAdapter, etc.?

Still a bit new to programming and SQL(<3 months), so if it doesnt make sense, please let me know and I will attempt to reword it or provider additional information.
Watch Question
Most Valuable Expert 2012
Top Expert 2014
This problem has been solved!
Unlock 2 Answers and 3 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE