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, mysql@stripped wrote:
> myodbc@stripped.
>
> 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
