• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6700
  • Last Modified:

VB.NET Application / SQL Server 2005 Express Set up project Deployment

I have created a windows forms VB.NET application with a Sql server 2005 Express back end. I would like to get this application packaged and am having some issues...

1) If I use the Publish Wizard in VS2005, I install sql server express fine by adding it as a prereq for my applications, but the application can't find the instance of the sql server to run the app and it errors out

2) if I create a setup project, I don't know how to add sql server express as a prereq....(and have heard you can't have nested msi packages anyway)

Could someone please lead me in the right direction please.
0
DAMAdmin
Asked:
DAMAdmin
  • 5
  • 4
1 Solution
 
AkisCCommented:
On the Solution explorer-->right clic your project and select properties
On the window opened cleck Publish
Click Prerequisites and scroll down till you find SQL express  ;-)
0
 
DAMAdminAuthor Commented:
I've done that as denoted by number 1..
What happens when I do that is sql server express installs fine, but when that installation finishes, I get an error when my application tries to start because I'm guessing it's not connecting the database to my application..

Should I see the application itself and files associated somewhere on the acual hardrive of the machine I'm installing to after it's been installed? Does it install everything to the temp directory? Can I determine where the install is placed?
0
 
DAMAdminAuthor Commented:
The error I get is "An attempt to attach an auto-named database for file C:\documents and settings..... failed. A database with the same name exists, or specified file can not be opened, or it is located on the UNC share..

I navigate the path that's in the error, and the mdf file isn't even there..
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
DAMAdminAuthor Commented:
if I click the quit button the application pops up, but the records for the application are not there (because the databse isn't loaded)

0
 
AkisCCommented:
You have to do a little reading on typed and untyped databases with VS2005
Maybe someone else can help you more
0
 
DAMAdminAuthor Commented:
the solution to this was create a setup project and click on properties. There's a prerequisite button there.. Select Sql Express as one of the prerequisites and compile...

Worked like a charm... No issues.. The publish wizard didnt' work, so I went back to number 2 and found the prereq button.. That was the key...
0
 
AkisCCommented:
Isn't it what I wrote at http://20409838# ?
0
 
DAMAdminAuthor Commented:
no.. you told me to right click on the project of the application and go to properties then publish.. I tried that and got the errors...

What solved the problem was I created a SETUP PROJECT.. Right clicked on that, went to properties, and there was a prerequisites button on THAT... Then I selected SQL Express and everything worked fine..

It was the difference of going to the properties of the setup project instead of the application's project iself and not using the publish menu..
0
 
AkisCCommented:
Yes, I assumed that you have already created a SETUP PROJECT, because you wrote 2) if I create a setup project,...

Anyway nice that you found your solution :)

Have fun coding...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now