9.2.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 file `\windows\lmhosts' with the following information:

  ip hostname
  

  For example:

  194.216.84.21 my_hostname
  

• Configure the PC to use DNS.

Example of how to fill 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 field 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 fields 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' file. You can use all options that are usable by mysql_options(). See section 9.1.3.39 mysql_options().

User Comments

I've been working with mySQL for 2 days. I had
trouble linking from an existing Access database
to my mySQL tables on a remote server. Access
seemed to be looking for a file DSN, and none of
the configurations I tried allowed me to set up a
File DSN on the server, perhaps because the boot
disk was different from the disk on which the
database resides? However, I managed to set up a
User DSN on the server using the Administrator
password, and the IP address for 'server', and
then by using the Open command in Access on my
local machine I could open the database on the
server directly into Access locally. At that
point, when prompted for the DSN info locally, I
used the ODBC user name and the localhost
for 'server'. And then I could work with the data
on the server from within Access on my machine.

Using the stable version of the ODBC driver I was
able to setup SQL Server Data Transformation
Services (DTS) to keep two Linux bases MySQL
databases in-line

Add your own comment.