troubleshooting Question

Connection String while Publishing

Avatar of ShannonCallahan
ShannonCallahan asked on
Visual Basic.NET
3 Comments2 Solutions322 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros