Ok, this is is a new experience for me.
In the past I have used text and csv files to store data that gets used in a desktop app. Now I am migrating an app to use a SQL database.
If I want to export the compiled app, Do I need to make sure the user has SQL installed on his machine? Or will the compiled app grab the necessary files to run the app with the datafile?
I am working with VS 2010.Thursday, March 15, 2012 2:58 AM
Will there be multiple instances of your application, all accessing a single instance of the database, or will the configuration be something different?
The best solution to your question will depend on the details of the configuration, so please supply the details.
In any case, your application will require that the host system have SQL Server installed. This can best be accomplished by adding a check for SQL Server in your deployment project and a conditional install of SQL Server (Express, I would think) if not found.
If you have further questions or need detailed help, the forum dedicated to your topic is here:Thursday, March 15, 2012 4:13 PM
An SQL database exist from two thinks, the lorry and the trailer. The lorry is the SQL database software and the DBF file the trailer, you can supply that one in VB Express with using the special connections string for a file. (In real SQL servers the DBF has to be added to the database using the tool for that).
The end user can use SQL Express software for free but every end user has to download and to register it himself.
CorThursday, March 15, 2012 4:16 PM
basically what i want to do is use a SQL dbf as a data file for my desktop app. This app will be ran from a stand-alone machine that at this time does not have any SQL engine installed. Is this possible without installing a standalone SQL install? Or do I need to go back to the idea of using a sequential flat file instead?
What if a client doesn't have any database engine installed? No Access, Excel or SQL? Can I still make calls to a data file? Other than a .csv or .txt?Thursday, March 15, 2012 5:31 PM