Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
MyODBC connectors for MySQL (Read 3481 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
MyODBC connectors for MySQL
21.04.10 at 10:04:47
 
MyODBC connectors for MySQL
 
When connections to MySQL do not succeed, look at the error message (to the far right in the connection dialog). When the error message is
 
Data source name not found and no default driver specified
 
then you do not have a driver installed for MySQL. The ODBC driver for MySQL is called MyODBC. I have given install instructions for MyODBC below.
 
The following MyODBC releases are mainstream:
 
  • MyODBC 5.2 Does not work with SQL*XL.  
  • MyODBC 5.1
    Download: http://dev.mysql.com/downloads/connector/odbc/5.1.html
    Two types of installers are provided
    • msi installer
      • Installer worked fine on Windows 8.1 x86
      • Installer failed on Windows 7 x64
      • The 32bits msi installer complains on windows XP.  
        Error 1918: Error installing ODBC driver MySQL ODBC 5.1/5.2 Driver, ODBC error 13: Could not load the setup or translator library. Verify that the file MySQL ODBC 5.1 Driver exists and that you can access it.
         
        I have not been able to fix this problem. It is probably best to try again with all service packs (SP3?) applied to windows XP.

      • zip file
        The 32bits zip installer complains on windows XP.
        This application has failed to start because MSVCR100.dll was not found. Re-installing the application may fix this problem.

        I have not been able to fix this problem. It is probably best to try again with all service packs (SP3?) applied to windows XP.

    • MyODBC 3.51
      Download: http://dev.mysql.com/downloads/connector/odbc/3.51.html
      • Installs fine on windows 7 x64

    • MyODBC 2.5

     
    See also:
    MyODBC at Wikipedia (it includes download links as well)
    http://en.wikipedia.org/wiki/MyODBC
Back to top
 
« Last Edit: 06.11.14 at 16:17:31 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1