MSDE Database deployment problem

[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.

 

[Luis C. Uribe]

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

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.