MSDE Database deployment problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
Hello friends,
I am trying to create a deployment project to distribute my VB.NET
Click to expand...
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
Click to expand...
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
Click to expand...
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
Click to expand...
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
Click to expand...
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.
 
Back
Top