Install MyODBC

[Wervis]

I want to install myODBC Drivers during installation. When i include a setup executable installation fails with the message "other installation in progress". I downloaded the dll/exe files form myodbc.com. Can anybody help me how to insert these files in my installation file?

[gigi]

Hi,

When i include a setup executable installation fails with the message "other installation in progress"

You get this error message because two msi packages can't run at the same time.

The best practice in this case is to install myODBC Drivers as prerequisites. In order to do this go to "Media" page, "Prerequisites" tab and add myODBC Drivers as new prerequisite.

You can learn more about how to use prerequisites in Advanced Installer from the following link:
http://www.advancedinstaller.com/user-g ... sites.html

Regards,
Gigi
________________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com

[Wervis]

The MySQL ODBC installer is not an msi package.

I added the installer as prerequisite the result is the same. An error message. The drivers are not installed.

I downloaded the driver files from the mysql website. I tried to install the odbc-drivers by adding them to the "ODBC page", "Drivers". Didn't work either.

There's a 'bat file included. The installer needs to perform the same actions.

ECHO OFF
REM #########################################################
REM
REM \brief Install myodbc.
REM
REM This exists for those working with the Windows source
REM distribution.
REM
REM \sa README.win
REM
REM #########################################################

ECHO ****
ECHO * Copying myodbc libraries and executables to install dir...
ECHO ****
copy lib\myodbc3S.dll \Windows\System32
copy lib\myodbc3S.lib \Windows\System32
copy lib\myodbc3.dll \Windows\System32
copy lib\myodbc3.lib \Windows\System32
copy bin\myodbc3i.exe \Windows\System32
copy bin\myodbc3m.exe \Windows\System32
copy bin\myodbc3c.exe \Windows\System32
copy doc\*.hlp \Windows\System32

ECHO ****
ECHO * Registering driver...
ECHO ****
myodbc3i -a -d -t"MySQL ODBC 3.51 Driver;DRIVER=myodbc3.dll;SETUP=myodbc3S.dll"

[gigi]

Hi,

Yo can create this type of package very easy with Advanced Installer. Here how you can do this: Go to "Files and Folders" page and add those files below under the "\Windows\System" folder.

Code: Select all

copy lib\myodbc3S.dll \Windows\System32
copy lib\myodbc3S.lib \Windows\System32
copy lib\myodbc3.dll \Windows\System32
copy lib\myodbc3.lib \Windows\System32
copy bin\myodbc3i.exe \Windows\System32
copy bin\myodbc3m.exe \Windows\System32
copy bin\myodbc3c.exe \Windows\System32
copy doc\*.hlp \Windows\System32

Switch to "ODBC" page and add new Driver. In the "File" field browse for "SystemFolder\myodbc3.dll" and in the "Setup File" field browse for "SystemFolder\myodbc3S.dll"

Regards,
Gigi
_______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com