Setup and Deployment of Database Project without server
-
Hi Can anyone tell is it possible use/store data to a sql database without having database server running itself. I mean do you need to have sql installed onto your machine if you want to use application program that stores/retrieves data from databases. Or is just driver enough? For example. I made an application program that has a GUI, connects to sql database file. So is it enough to install to client machine 1-)Exe 2-)Database Driver 3-)Database file(for example .mdb) to make it run correctly (no connection to server)? Thanks...
-
Hi Can anyone tell is it possible use/store data to a sql database without having database server running itself. I mean do you need to have sql installed onto your machine if you want to use application program that stores/retrieves data from databases. Or is just driver enough? For example. I made an application program that has a GUI, connects to sql database file. So is it enough to install to client machine 1-)Exe 2-)Database Driver 3-)Database file(for example .mdb) to make it run correctly (no connection to server)? Thanks...
as a stand alone program? the program was a database attached? yes if you have to connect the a database, the server as to be on.
nelsonpaixao@yahoo.com.br trying to help & get help
-
Hi Can anyone tell is it possible use/store data to a sql database without having database server running itself. I mean do you need to have sql installed onto your machine if you want to use application program that stores/retrieves data from databases. Or is just driver enough? For example. I made an application program that has a GUI, connects to sql database file. So is it enough to install to client machine 1-)Exe 2-)Database Driver 3-)Database file(for example .mdb) to make it run correctly (no connection to server)? Thanks...
SQL Server needs to be running somewhere, not just exist as an MDB file. If you are embedding a SQL Express file then (I think) it need to be installed. You should have 2 deployment packages, 1 for the DB and 1 for the app.
Never underestimate the power of human stupidity RAH
-
Hi Can anyone tell is it possible use/store data to a sql database without having database server running itself. I mean do you need to have sql installed onto your machine if you want to use application program that stores/retrieves data from databases. Or is just driver enough? For example. I made an application program that has a GUI, connects to sql database file. So is it enough to install to client machine 1-)Exe 2-)Database Driver 3-)Database file(for example .mdb) to make it run correctly (no connection to server)? Thanks...
The functionality you described is possible with SQL Server Compact Edition. It needs no installing and the database is included in to the project and deployed with it. However in CE you have few restrictions including: - only one user can use it (not suitable for multi-user environments) - no locking is possible Hope this helps, Mika
The need to optimize rises from a bad design