5 มีนาคม 2555 4:35
i have a project which i have to install at the client end. it is done in VB.net and SQL 2008R2(SQLEXPRESS). My problem is when i make a setup file including All the necessary files (.mdf, .ldf, etc) and try to install at the clients end. the installation is complete, but when i try to run, it gives an error of SQL, coz the client machine does not have SQL, i do not want to install the whole SQL server coz it is a very small project, what are the alternatives for it please
thanks and regards
- ย้ายโดย Bob BeaucheminMVP 6 มีนาคม 2555 6:14 Moving to a more relevent forum for better results (From:.NET Framework inside SQL Server)
5 มีนาคม 2555 15:16
If you would like to use your database made in SQL Express, you need to install it on your client's machine. If you do not want to install it, you may look for another data store, like xml or SQL CE. The latter is just a bunch of DLL files afaik.
Another option is to install another editon than express on a central server and connect the app for that instance from every machine.
I hope it helps.
There are 10 type of people. Those who understand binary and those who do not.
- เสนอเป็นคำตอบโดย Zoltán Horváth 9 มีนาคม 2555 14:56
5 มีนาคม 2555 16:41hello,
thanks for your input, but how can i make an inventory control system work with XML or SQL CE. is it feasible.
If yes then i will do my research. but kindly let me know if it is feasible or not
thanks for your advice
7 มีนาคม 2555 7:04ผู้ดูแล
Hi Hari vaag,
For SQL Server compact you can refer to this reference: http://support.microsoft.com/kb/920700/en-us
I suggest you to use SQL Server localDB, LocalDB is created specifically for developers. It is very easy to install and requires no management, yet it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express. In effect the developers that target SQL Server no longer have to install and manage a full instance of SQL Server Express on their laptops and other development machines. Moreover, if the simplicity (and limitations) of LocalDB fit the needs of the target application environment, developers can continue using it in production, as LocalDB makes a pretty good embedded database too.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- ทำเครื่องหมายเป็นคำตอบโดย Hari Vaag 7 มีนาคม 2555 12:18