<< 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
    Chapter 8:  MySQL APIs 547 Click the button Add. Select MySQL in the screen Create New Data Source and click the Finish button. The MySQL Driver default con guration screen is shown. See Section 8.3.2 [ODBC administrator], page 547.    Now start your application and select the ODBC driver with the DSN you speci ed in the ODBC administrator. Notice  that  there  are  other  con guration  options  on  the  screen  of  MySQL  (trace,  don't prompt on connect, etc) that you can try if you run into problems. 8.3.2  How to Fill in the Various Fields in the ODBC Administrator Program There are three possibilities for specifying the server name on Windows95:    Use the IP address of the server.    Add a le `\windows\lmhosts' with the following information: ip hostname For example: 194.216.84.21 my_hostname    Con gure the PC to use DNS. Example of how to ll in the ODBC setup: Windows DSN name: test Description: This is my test database MySql Database: test Server: 194.216.84.21 User: monty Password: my_password Port: The  value  for  the  Windows DSN name   eld  is  any  name  that  is  unique  in  your  Windows ODBC setup. You  don't  have  to  specify  values  for  the  Server,  User,  Password,  or  Port   elds  in  the ODBC setup screen.  However, if you do, the values will be used as the defaults later when you  attempt  to  make  a  connection.   You  have  the  option  of  changing  the  values  at  that time. If the port number is not given, the default port (3306) is used. If you specify the option Read options from C:\my.cnf, the groups client and odbc will be  read  from  the  `C:\my.cnf'   le.   You  can  use  all  options  that  are  usable  by  mysql_ options().  See Section 8.4.3.38 [mysql_options()], page 586. 8.3.3  Connect parameters for MyODBC One can specify the following parameters for  MyODBC  on the  [Servername]  section of an `ODBC.INI' le or through the InConnectionString argument in the SQLDriverConnect() call.
     

    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