Not very clear on what you want to do. Is your database going to be on the same machine as the application? In that case all you'll need to do is the connection string setting to point to the local machine instance.
Thread: Deploy SQL Server App to SQL Server Express?  |
|||||||||||||
|
Started 1 month, 2 weeks ago by WillieMakit
I have a winforms app developed using VB .Net 2008 and a SQL Server 2005 database. I want to deploy the app as a stand-alone using an included SQL Server Express DB. However, I have never done this before and would like some help in configuring and publishing the app.
Any help would be most appreciated.
Thanks in advance
Will
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
rjv_rnjn replied 1 month, 2 weeks ago
Size: 215 bytes
Customize: 
WillieMakit replied 1 month, 2 weeks ago
I have built the application using a SQL Server database, but I now want to publish it with an embedded SQL Server Espress database so it will run on a client machine.
In the App Properties/Prerequisits, I have set the checkbox to SQL Server Express. When I run the application from another machine, it gives me an error that the database is not found. So I guess you are right about the ...
Size: 1,272 bytes
Customize:
rjv_rnjn replied 1 month, 2 weeks ago
For any type of connection string, the site to look to is: http://www.connectionstrings.com/sql-server-2005 (scroll down a bit to see the strings for SSE)
Your first connection string looks good to me, except that the path of Ilean.mdf is not specified.
Also, will all the users have instance of SSE pre-installed on their machines or will you be installing them? I am not sure on this one ...
Size: 597 bytes
Customize:
WillieMakit replied 1 month, 2 weeks ago
By the path not being specified, I take it you mean that it should be ...AttachDBFilename=Path\Ilean.mdf... ?
I guess that is my problem. I don't know what the path to the database is if it is embedded in the application. Is the path the same as the installed directory? Or is there a new database set up separately? How do I determine what the path should be?
It is my understanding that ...
Size: 826 bytes
Customize:
rjv_rnjn replied 1 month, 2 weeks ago
I'm not sure I understand what you mean by "embedded database" but assume that you are placing it in the Data folder of the solution. In that case the path should be like
Code:
AttachDbFilename=|DataDirectory|\Ilean.mdf
This path has got nothing to do with the SSE install directory. All .Net does is use the mdf file to attach to the SSE.
Installing the SSE should be with setup.exe ...
Size: 938 bytes
Customize:
WillieMakit replied 1 month, 2 weeks ago
That is about the clearest explanation I have seen yet. So how do I buncle the SSE installer with the app?
Sorry for all the questions, but I really have not done this before. Thanks again.
Will
Size: 228 bytes
Customize:
rjv_rnjn replied 1 month, 2 weeks ago
You can use the .Net Setup & Deployment project (available in Other Project Types) to create an installer for your application. When you right click on the project and open the property pages, you will see a Prerequisites button. Click on that and you'll find the .Net version is auto selected and towards the end you will find the SQL Server Express. Select that and you should be fine. Just to let...
Size: 742 bytes
Customize:
|
Top contributing authorsRelated threads on "VBForums - Visual Basic and VB .NET Discussions and More!":Related threads on other sites: |
||||||||||||
Thread profile page for "Deploy SQL Server App to SQL Server Express?" on http://www.vbforums.com.
This report page is a snippet summary view from a single thread "Deploy SQL Server App to SQL Server Express?", located on the Message Board at http://www.vbforums.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.