473,569 Members | 2,598 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDE Database deployment problem

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
1 1887
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*******@disc ussions.microso ft.com> wrote in message
news:F5******** *************** ***********@mic rosoft.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1490
by: David | last post by:
I have a database application running on my development machine and now want to distribute the application to a third party. Would someone mind please explaining how I can modify the Setup Solution to distribute MSDE with the application. And, doe sthe third party need to then manually install MSDE and create the same instance or will the...
2
5057
by: Rosy Moss | last post by:
I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals (Each running 2000) logging in each day. Four of these terminals access the server via Citrix. Currently the database is about 60MB, but it grows...
4
1569
by: Jozef | last post by:
I'm just wondering if anyone here uses MSDE, and if so, do you use ODBC or is there a better way to connect? I'd like to start using it just because of it's scalability if nothing else, but would like to know more about it from experienced developers. Any help is appreciated. Thanks! Jo
2
1578
by: Jozef | last post by:
Hello, I was wondering if anyone here has experience deploying MSDE database with Access as the front end? My issue is this; I'd like to deploy an MSDE back end on a remote machine that I may or may not be attending. I'd like the program (or at least A program) to see if the instance of the database (let's say ABC.mdf) exists, and if it...
3
2528
by: Paul Aspinall | last post by:
Hi I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user. I want to create an MSI or Installshield (prefer MSI), to setup my C# app, together with MSDE (if not already installed), and the MSDE application DB. How can I detect if MSDE is already installed?? Has anyone does this?? How??
2
1140
by: Corobori | last post by:
I need to create a setup project where I am installing MSDE if it's not installed and create a database if it doesn't exist. I read a bunch of document on MSDN but let's face I don't have a good picture on how to do this from inside my deployment project on vb.net. Any help welcome jean-luc
1
1957
by: Sebastian Santacroce | last post by:
Is it posible to package MSDE with VB .net so that its part of the installation? If so, is there documentation somewhere? What about packaging the .net framework with the application as well? Thanks ss
1
321
by: DB developer | last post by:
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...
13
2423
by: Matt Fielder | last post by:
First off, if this is better posted in another group that qualifies as a manged group, please let me know. I currently have an application written in VB.Net using MSDE as the database. Current install is via InstallShield. As I've just found out that MSDE is not supported under Vista, I need to migrate to SQLExpress. I am also...
0
7700
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7614
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7676
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5513
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5219
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3642
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
938
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.