Click here to Skip to main content
15,911,896 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I wrote C# application that use sql database after building it work well. but When I make an install(msi) from that resulting (exe). It doesn't work on other computer on which sql server or visual studio is not installed. In connection String I used Data Source as(.\SQLEXPRESS).I want to know detail steps in building database driven application
Posted

You need to install a copy of SQL Server. You may want to install SQL Server on a computer within your LAN and share the data between all installed instances of your software. You can also choose to install a local copy of SQL server which enables you to keep your application data private.

If you want to install SQL Server on a local computer you may want SQL Server Express which is a light version with limited capabilities, but perfect for storing application data.

Hop it helped!

Eduard
 
Share this answer
 
Comments
Kyaw Zin Soe 23-Mar-11 2:22am    
Thank you very much for your advice.
Have a look at this White Paper: http://msdn.microsoft.com/en-us/library/bb264562(v=sql.90).aspx[^]. It's targeting SQL Server Express 2005 but 2008 version is quite similar if you use that.
 
Share this answer
 
Comments
Kyaw Zin Soe 23-Mar-11 2:22am    
Thanks alot.
Wendelius 23-Mar-11 2:24am    
No problem :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900