<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    546 MySQL Technical Reference for Version 4.0.3 8.3  MySQL ODBC Support MySQL provides support for ODBC by means of the MyODBC program.  This chapter will teach you how to install MyODBC, and how to use it.  Here, you will also nd a list of common programs that are known to work with MyODBC. 8.3.1  How To Install MyODBC MyODBC is a 32-bit ODBC (2.50) level 0 (with level 1 and level 2 features) driver for connect- ing an ODBC-aware application to MySQL. MyODBC works on Windows 9x/Me/NT/2000/XP and most Unix platforms. MyODBC is in public domain, and you can nd the newest version at http://www.mysql. If you have problem with MyODBC and your program also works with OLEDB, you should try the OLEDB driver. Normally you only need to install MyODBC on Windows machines.  You only need MyODBC for Unix if you have a program like ColdFusion that is running on the Unix machine and uses ODBC to connect to the databases. If you want to install MyODBC on a Unix box, you will also need an ODBC manager.  MyODBC is known to work with most of the Unix ODBC managers.  See Section 1.6.1 [Portals], page 22. To install  MyODBC  on Windows,  you should download the appropriate  MyODBC  `.zip' le, unpack it with WinZIP or some similar program, and execute the `SETUP.EXE' le. On Windows/NT/XP you may get the following error when trying to install MyODBC: An error occurred while copying C:\WINDOWS\SYSTEM\MFC30.DLL. Restart Windows and try installing again (before running any applications which use ODBC) The problem in this case is that some other program is using ODBC and because of how Windows  is  designed,  you  may  not  in  this  case  be  able  to  install  a  new  ODBC  drivers with Microsoft's ODBC setup program.  In most cases you can continue by just pressing Ignore  to copy the rest of the MyODBC les and the nal installation should still work. If this doesn't work, the solution is to reboot your computer in \safe mode\ (Choose this by pressing F8 just before your machine starts Windows during rebooting), install MyODBC, and reboot to normal mode.   To make a connection to a Unix box from a Windows box,  with an ODBC applica- tion (one that doesn't support MySQL natively), you must rst install MyODBC on the Windows machine.   The user and Windows machine must have the access privileges to the MySQL server on  the  Unix  machine.   This  is  set  up  with  the  GRANT  command.   See  Section  4.3.1 [GRANT], page 212.   You must create an ODBC DSN entry as follows: Open the Control Panel on the Windows machine. Double-click the ODBC Data Sources 32-bit icon. Click the tab User DSN.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide