By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

MSDE Database deployment problem

P: n/a
Hello friends
I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve this. I am facing the following problems

I am deploying the database by copying to .MDF and .LDF files in destination folders using deployment package. The problem is that I am not able to attach the database to the MSDE instance as a part of setup process
currently I am using connection string to attach the database file to the MSDE instance as soon as the application starts. I am doing this by using "Initial File name=<DB file path>". Is there any other way of doing this programatically (where user intervention is not required). Can I use -osql utility to do this automatically as a part of my setup program? If yes, how

Although my current setup program works for the fisrt time, I am not able to uninstall my app properly, becase the uninstall process fails as the database file is still attached to the MSDE instance and therefore cant be removed.

I am not sure if I am following correct steps to install my MSDE database with VB.NET application. Please suggest me the correct solution for this. Also I need to know is, where can I find a final release version (not candidate) of MSDE, which I can use in production environment.

Thanks in advance.
Jul 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I do what you describe and it works. But I only deploy the .mdf since the
..ldf causes problems. You may want to try that way.

Luis C. Uribe
"DB developer" <an*******@discussions.microsoft.com> wrote in message
news:F5**********************************@microsof t.com...
Hello friends,
I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment
toolkit (release candidate) to achieve this. I am facing the following
problems.
I am deploying the database by copying to .MDF and .LDF files in destination folders using deployment package. The problem is that I am not
able to attach the database to the MSDE instance as a part of setup process. currently I am using connection string to attach the database file to the MSDE instance as soon as the application starts. I am doing this by using
"Initial File name=<DB file path>". Is there any other way of doing this
programatically (where user intervention is not required). Can I use -osql
utility to do this automatically as a part of my setup program? If yes, how?
Although my current setup program works for the fisrt time, I am not able to uninstall my app properly, becase the uninstall process fails as the
database file is still attached to the MSDE instance and therefore cant be
removed.
I am not sure if I am following correct steps to install my MSDE database with VB.NET application. Please suggest me the correct solution for this.
Also I need to know is, where can I find a final release version (not
candidate) of MSDE, which I can use in production environment.
Thanks in advance.

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.