Re: ODBC 5.1.10 -- Issues on Windows-7 after installation
[email protected] Fri, 3 Feb 2012 12:06:44 -0500
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
After further research it appears that 'Access 2007' is using '%windir%\SysWOW64\odbcad32.exe' which does not show the installed ODBC driver. When we manually browse our HDD to %windir%\System32\odbcad32.exe and "run as administrator" we are able to see the driver in the listing. This leaves us with the following question: Why is this driver not available in 'Access 2007'? Telling us we are using the wrong this or that is not helping us. How do we correct this? ----------- This is starting to become beyond ridiculous. After installing the 64-bit odbc we are unable to select it from a list of drivers within Access 2007 on this 64-bit install of windows-7. We are attempting to use MicroSoft Access 2007 on a 64-bit install of windows-7 to connect via ODBC to our mysql install on a unix variant machine. The 64-bit ODBC installs with no errors; but we cannot see the driver/listing within the "Create New Data Source" dialog window. Which means we cannot connect to the mysql server (machine). :-) Hello, I guess you need to use %windir%\System32\odbcad32.exe to see 64bit drivers and create DSN's. %windir%\SysWOW64\odbcad32.exe will show you 32bit drivers. If you use 32bit applications on 64bit OS you will still need 32bit odbc driver. But from your letter I got an impression that your application is 64bit, that is only that you use wrong ODBC administrator. Regards, lawrin On 03.02.2012 15:50, [email protected] wrote: > [email protected]. > > OUR NOTES: > The following is true on an windows-7 (64-bit) install: > > mysql-connector-odbc-5.1.10-winx64: Currently is not working or > otherwise > listed in the "Create New Data Source" dialog window. The resulting file > size reported by Win 7's add/remove programs= 21.2MB > > Dwnlded from -- > http://dev.mysql.com/get/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.10-winx64.msi/from/http://mysql.mirrors.pair.com/ > > mysql-connector-odbc-5.1.10-win32: Currently, will get listed within the > "Create New Data Source" dialog window; but of course nothing beyond > that > will function. resulting file size reported by Win 7 add/remove > programs= > 11.0MB. > > Dwnlded from -- > http://dev.mysql.com/get/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.10-win32.msi/from/http://mysql.mirrors.pair.com/ > - > > > Installing and using "mysql-connector-odbc-5.1.10-win32" on a 32-bit > install of windows-7 appears to work fine. What are we missing that is > causing us to have issues with the 64-bit ODBC connector on a 64-bit > install of windows-7? There continue to be 'no errors' during the 64-bit > ODBC connector installation. > > We are able to repeat the above all day/night long. > > > > > -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc