Bug #3813 Adding MyODBC Installer to Install Sheld ErrorsOut
Submitted: 18 May 2004 15:56 Modified: 28 Jun 2004 21:23
Reporter: James Neighbarger Email Updates:
Status: Closed Impact on me:
Category:Connector / ODBC Severity:S2 (Serious)
Version:MyODBC-standard-3.51.07-win OS:Microsoft Windows (Win95,98,2000,ME,XP)
Assigned to: Peter Harvey CPU Architecture:Any

[18 May 2004 15:56] James Neighbarger
We use Install Shield to install our products, which uses the Windows installer.  We support MS Access, MS SQL, and MySQL database platforms.  MySQL makes up most of our client base.  The problem is when incorporating the latest MyODBC installer into our installs, the windows installer gives an error saying that it is already in use and can only install one program at a time.  My question is, do you have a merge module that I can incorporate into my setup, or do you have a list of files installed by the MyODBC installer so that I can incorporate those files directly into my install?  Another problem that I have is that we use Install Shield Express 4.1, this version does not allow me to add an .msi to the project, and I can only add .exe files as custom actions.  I would like our install to be a one step, user proof process.  As it is now, we would have to have our users run 2 setups, and knowing our client base they do not follow instructions.  

How to repeat:
Create a new install project that uses the Windows installer.  Add the MyODBC-standard-3.51.07-win.exe to the install so that it is called during the new install.  Run the new install and you will get the error when the MyODBC try’s to run.

Suggested fix:
Release a Merge Module that can be incorporated into other project that use the Windows Installer, or release the files that are installed with the MyODBC Installer with documentation so that these files can be added directly into another project.
[24 Jun 2004 18:48] Peter Harvey
removing from PGalbraith
[28 Jun 2004 21:23] Peter Harvey
I suggest that you install myodbc then include the resulting files in your install process.

The 3 files you need to include in your install are;

- myodbc3.dll
- myodbc3.lib
- my3dsn.hlp

Keep in mind that you will want to "register" myodbc3.dll as an ODBC driver at some point in your install.