New
#1
Windows 7 - MySQL ODBC System DSN creation
Hello and thank you for reading my post.
My software creates MySQL ODBC System DSNs...
... except it doesn't work with Windows 7.
It used to work with the previous Windows OSes including XP, Vista.
I've been struggling the whole day trying to find a solution.
*** I believe UAC (User Account Control) has something to do with this.
But I can't disable it as my customers have it usually enabled.
How can my application be allowed to create MySQL ODBC System DSNs and as a "normal" user?
*** The MySQL ODBC connector I have installed is:
mysql-connector-odbc-3.51.30-win32
and I have installed it logged as "Administrator".
(I also installed my application logged as "Administrator").
*** The MySQL server is on localhost for now... (that is to say on the same host as the application).
*** I've already updated the "Target" in the "Shortcut" tab in "Data Sources (ODBC) Properties" to "%windir%\syswow64\odbcad32.exe"
so that the "Drivers" tab is properly populated, including "MySQL ODBC 3.51 Driver".
*** Logged as "Administrator" (which shouldn't be of course: this account is disabled by default, I enabled it for testing reasons), MySQL ODBC DSNs are created but they are empty:
- only the "Data Source Name" field is not;
- the "TCP/IP Server", "User", "Password" and "Database" fields are empty.
*** In my application it results in the message: "No database selected".
*** If I'm logged as a "normal" user, MySQL ODBC System DSNs are not created at all
(or maybe they are but they do not appear in the "System DSN" tab).
I read something like: the application should be "elevated" but I don't know if it would solve the problem nor how to do it. Apparently UAC prevents applications from creating ODBC System DSNs... ! There has to be a way around!
Actually a solution is proposed on this website: http://kb.avecto.com/articles/how-to...dsn%E2%80%99s/
but I do not wish to buy this product especially if there exists a solution without it.
I really don't know what to do now...
can you help me?
Thank you and best regards.