From: mysql Date: February 6 2012 2:03pm Subject: Re: ODBC 5.1.10 -- Issues on Windows-7 after installation List-Archive: http://lists.mysql.com/myodbc/11722 Message-Id: MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit Thanks, we finally grasped what you were saying. The confusion on our part was, we did not understand installing 32-bit 'driver(s)' (opposed to a 32-bit application), which can be used in compatibility mode on a 64-bit OS. myodbc@stripped After doing so (installing the 32-bit ODBC), it is available for use from within 'Access 2007', but when we create a 'New' file Data Source, for use with importing or linking (Access2007= front end, MySQL= back end), the following dialog(s): Import Objects or Link tables, respectively, are totally empty; this is not the case on our 32-bit install of win-7 whereby the 'import Objects' and 'link Tables' dialog are populated. Your continued assistance on this issue would be appreciated. Thank you. Hi, On 03.02.2012 19:06, mysql@stripped wrote: > 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? I am quoting my 1st reply "If you use 32bit applications on 64bit OS you will still need 32bit odbc driver. " Please install 32bit driver. "64" and "32" in packages names means that they contain 64bit or 32bit binaries. In many cases(if not in most) people use 32bit application on 64bit windows. lawrin > ----------- > > 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 > > > > > -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc