You my friend, are lost. You need to set up an independent SQL server that everyone can connect to. Then when you publish your application, the user doesn't need to have SQL installed because the app connects to the central SQL server. If you don't want them to install SQL, which is what you stated, then SQL is the wrong solution for you, because you seem to NOT want them to connect to the server(?). In that case, I would use XML to provide data storage function, but the data will not be shared (It can be but its too much work to justify using XML over SQL).
On Wed, Jul 22, 2009 at 11:47 AM, WWPCJustin <[email protected]> wrote: > > Hello. > > I have a program that i have written in vb.net with links to sql > tables on a server. My question is.. How can i make this program > stand alone? > > I want to be able to share it with people that do not have sql > installed on their computer. Right now, if i publish the program, it > can be installed anywhere and ran, but errors will be thrown because > it can obiviously not find the connection to the tables. I do not > want to connect back to the original tables here on the server. I > don't need that. I just want to be able to give the app to someone, > and they will have a app with no data, but will be able to add data to > there version of the app. > > There has to be an easy way right? I have installed many programs, > that data is kept, and no sql server is installed. > > I dont want to make users install sql server, and then install my > database instance in sql, and then change the connection strings to > make the connection to it. That seems like a huge hassle, expescially > if they aren't very computer illiterate. > > I would appreciate any pointers in the right direction. > > Thanks! > > Justin >
