Marek
Posts: 24
Joined: Mon Dec 28, 2009 9:25 am

MySQL Connector/ODBC Data Source Configuration

I build my setup in AI 9.9 which must create ODBC connection.
I used 'MySQL Server Connection' how to do this (http://www.advancedinstaller.com/user-g ... ction.html).
Below my configuration pages:
ODBC page
ODBC page
ODBC.png (162.03 KiB) Viewed 6193 times
SQL scripts page
SQL scripts page
SQLscripts.png (177.37 KiB) Viewed 6193 times
However, the result of which get an after installation is to me incomprehensible.
MySQL Connector
MySQL Connector
mysqlconnector.png (150.11 KiB) Viewed 6193 times
What am I doing wrong?
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: MySQL Connector/ODBC Data Source Configuration

Hello,

Please keep in mind this is the normal behavior. If you want to configure the description, user, password, etc. fields for your data source, then you can add their corresponding attributes in the "Attributes" section. You can find out the required attributes for the selected driver in two ways:

1. you can install your data source on your local machine using Administrative Tools - ODBC. Then use Registry Editor to see the registry keys and values from HKLM-Software-ODBC-ODBC.INI key. Under this location there is a key for every datasource installed on your computer. Identify the registry key corresponding to the datasource you want to install on the target machine. Note the name and values from that key. These are the attributes you have to add in your package (not necessary all - some of them might get a default value from the driver).

2. you can install your datasource on your local machine as a File DSN - and then find out the attributes names and values from that file (on Windows XP you can find it in Program Files\Common Files\ODBC\Data Sources)

Also, please note that the connection parameters added in our "SQL Scripts" page will not be added to your data source. The above connection will be used only when you want to run SQL scripts during installation.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Marek
Posts: 24
Joined: Mon Dec 28, 2009 9:25 am

Re: MySQL Connector/ODBC Data Source Configuration

Thank you, Daniel, for your answer.
It has helped me better understand the subject, which I read in the user guide.
I wanted to use a method described in the first way. But the problem arose from the incomplete description in the user guide (http://www.advancedinstaller.com/user-g ... rties.html).
In the section 'Registration' is written that "You can set the data source to be installed on the target machine as a System DSN or as a User DSN". It's true. I set the data source as User DSN.
The below is written "Then use Registry Editor to see the registry keys and values from HKLM-Software-ODBC-ODBC.INI key". It's not true if you set the data source as User DSN.
Correct key is HKCU, not HKLM. For this reason, I could not find a way to enter the correct data.
In my opinion, you should slightly clarify the description in the user guide.

All the best,
Marek
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: MySQL Connector/ODBC Data Source Configuration

Hello Marek,

Indeed, when a data source is installed as a User DSN you should search the registry keys and values from HKCU-Software-ODBC-ODBC.INI key.

Also, we'll update our "Data Source Properties" article in a future version of Advanced Installer. Thank you for bringing this to our attention.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”