MSDE 2000 Install problem from Merge Modules

MSDE 2000 Install problem from Merge Modules

Post by Kevi » Fri, 14 Feb 2003 11:36:46

cnfgsvr file says "Data source name not found and no
default driver specified".  I noticed that ODBC DSN
Administrator shows NO ODBC drivers.  I installed MDAC
2.7, still no ODBC.

1.  Am I on the right track thinking that the missing
Drivers is the source of the MSDE2000 install problem?
2.  If so, how do I install them?  I thought they were
installed with MDAC.



1. MSDE 2000 merge modules on machines where MSDE is already installed

I have created a Windows Installer package (with InstallShield for Windows
Installer) which includes the MSDE 2000 merge modules.

For a new installation of my company's product, everything works fine.

However, if I create an updated package, containing a new version of the
product, and try to install this on a machine, where MSDE is already
installed, then I run into problems.

At first, I was getting the error message "The instance name specified is
invalid". I have got rid of this by removing the custom action
"DetectInstanceClash" from SqlBase.msm. (Of course, this may have side
effects which I am not aware of!)

I am specifying an instance name.
I have a custom action which detects if my instance of MSDE is installed,
which I can easily extend to set properties etc.

I have tried setting the properties SqlUpgrade/SqlUpgradeUser, also setting
the property SQLMSDEInstalled and clearing the property SQLMSDESelected, but
so far have not found any combination which works.

Has anybody managed to create a package which would update their own product
without affecting an existing MSDE installation?


2. database access in JSP

3. MSDE 2000 SP1 Service Manager Shortcut Not Installed from Merge Modules

4. @@Servername problem

5. MSDE 2000 merge module install (MSI/InstallShield)

6. Compacting/repairing database through ADO interface in a VC++ project

7. MSDE service stops during install - using MSDE merge modules

8. sys password and dbmsstdx.sql?

9. MSDE 2000 SP2 Merge Modules Problem w/ ODBC Data Source

10. MSDE 2000 SP3a merge modules - upgrade problem

11. MSDE 2000 Merge Module installation problem

12. MSDE 2000 installation on Windows 2000 SP2 Professional using Windows Installer Merge Modules from SP1

13. SP3 won't install on MSDE installed from Merge Modules