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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.