How do I fill in the various fields in the ODBC administrator program?

There are three possibilities for specifying the server name on Windows95:

1. Use the IP address of the server.
2. Add a file lmhosts with the following info: ip hostname For example:

   194.216.84.21 my
   

3. Configure the PC to use DNS.

Example of how to fill in the 'ODBC setup'.

Windows DNS name:   test
Description:        This is my test database
MySql Database:     test 
Server:             194.216.84.21
User:               monty
Password:           my_password
Port:

The 'Windows DNS name' is any name that is unique in your windows ODBC setup.

When you fill in the values in the ODBC setup, these will be used as default values when prompting for a Driver connect. You don't have to give 'server', 'user' or 'password' in the ODBC setup screen.

When connecting to an ODBC source you have the option to change the server, user, password and port.

If port is not given the default port (3306) is used.

Go to the first, previous, next, last section, table of contents.