Bug #82731 Bugs when connecting C++ Builder application with My SQL Data Base server
Submitted: 25 Aug 2016 20:22 Modified: 29 Sep 2016 5:47
Reporter: Алексей Татаринов Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.3.6 OS:Windows (7 (x64))
Assigned to: CPU Architecture:Any
Tags: C++ Builder 2010, Coinnection string, MySQL, Windows 7 (x64)

[25 Aug 2016 20:22] Алексей Татаринов
Description:
I transferred Rad Studio C++ Builder 10 and MySQL server 5.5, I used some years on Windows XP (x86), to Windows  7 (x64).  I had no troubles to install as an x86 application and to check that all works good (separately). Then I have to connect them by means of  Corel MySQL ODBC Driver. On dev.MySQL.com I find 2 installation files: mysql-connector-odbc-5.3.6-win32.msi and mysql-connector-odbc-5.3.6-win64.msi. 
When I start the first, I have no possibilities to control the destination folder for driver, but the process  is going as usual without error messages/ Meanwhile, I can not build the data source with this driver because  ControlPanel\Administration\DataSources(ODBC) can not find this driver.
When I start the second, the process of creating the Data Source is going without difficulties and connection with MySQL Data Base is tested OK/ But when I try to make a connection string with this Data Source for TADOConnection element in C++ Builder I find that the name of that good Data Source is invisible in C++ media/
What can be done to debug this situation? 

How to repeat:
You need to have on your PC with Windows 7 (x64)
MySQL Comunity server 5.5 with any data base. For check 32 bit driver you have to start the  mysql-connector-odbc-5.3.6-win32.msi, than find the page ControlPanel\Administration\DataSources(ODBC)\Drivers and check if MySQL ODBC driver is visible.
To check the 64 bit driver you have to do the driver installation with 64 bit installation file, than to create a Data Source for your MySQL Data base on page ControlPanel\Administration\DataSources(ODBC)\System DSN and to check connection. Then you need to start new progect with Embarcadero Rad Studio C++ Builder 2010, to put the ToolPalette\dbGo\TADOConnection element on the Main form of your progect, to find a Connection String property on the ObjectInspector for that elemend and to try to build the Coinnection string.
You will find no prepared Data Source.
[1 Sep 2016 11:53] Chiranjeevi Battula
Hello Алексей Татаринов,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps/sample project, MySQL version, create table statements/database etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[7 Sep 2016 8:31] Алексей Татаринов
Hello Chiranjeevi Batula

I added 4 files to my bug report: 
1. SQL script to create Data Base with 1 table ana some data,
2. C++ bulder project to work with this base,
3. and 4. Screenshots while building Data source.
My Windows is Windows 7 (x64) Build 7601 professional Service pack 1 
Embarcadero C++ Builder 2010 Professional 14.0.3593.25826 Update 5.
Akexey Tatarinov
[7 Sep 2016 11:30] Chiranjeevi Battula
Hello Akexey Tatarinov,

Thank you for the bug feedback.
I could not find any attachments for this bug. Can you please attach the files/Screenshots/SQL script to confirm this issue at our end?

Thanks,
Chiranjeevi.
[7 Sep 2016 17:31] Алексей Татаринов
Dear Mr Battula!
I do not understand where is my error. I  entered "Files", found all files I prepared to you, found filenames with OK at thr right of find file field? added the corresponding text, entered the check number and submitted my message. I do not understand what was wrong.
Would you like to send me e-mail address to upload my files.
You send your letter to my home address.. You can write me to my office e-mail abtat@gsi.ru. I am present in my office 3 days per week? from Tuesday till Thursday and I an absent from town the last part of a week.
[7 Sep 2016 17:41] Алексей Татаринов
7zip archive with all files about this bug

Attachment: No coonection MySQL-C++ Builder on Windows 7 (x64).7z (application/octet-stream, text), 2.64 KiB.

[8 Sep 2016 6:22] Chiranjeevi Battula
Hello Akexey Tatarinov,

Thank you for the bug feedback.
In .7z file having only one word document and its having bugs description only.
Could you please send us proper files to confirm this issue at our end?

Thanks,
Chiranjeevi.
[8 Sep 2016 18:04] Алексей Татаринов
Zip archive with all files

Attachment: No coonection MySQL-C++ Builder on Windows 7 (x64).7z (application/octet-stream, text), 100.58 KiB.

[22 Sep 2016 11:26] Bogdan Degtyariov
Hello Алексей,

All 64-bit versions of Windows have two versions of ODBC Administrator (one is 32-bit for 32-bit ODBC drivers and another is 64-bit version for 64-bit drivers). Each version is showing only 32-bit or only 64-bit drivers and DSN's.

Note that through the Control Panel you can only run 64-bit version.
The easiest way to run the 32-bit version is through the command line:

%windir%\SysWOW64\odbcad32.exe
(32-bit version is inside SysWOW64, that's correct)

(64-bit version is inside System32, a bit strange logic, but that's what it is):
%windir%\System32\odbcad32.exe

Please let me know if this resolved your problem.
[28 Sep 2016 21:19] Алексей Татаринов
Thanks, Bogdan. 
Your proposal to start odbcad.exe from SysWOW64 helped. MySQL server is conected with C++ Builder 2010 in Windows 7 (x64) environment.

Еще раз спасибо!
С уважением,
Алексей Татаринов
[29 Sep 2016 5:47] Chiranjeevi Battula
Hello Akexey Tatarinov,

Thank you for the bug feedback.
I'm glad that you resolved your problem by using start odbcad.exe from SysWOW64. 

Thanks,
Chiranjeevi.