Entry

How do I connect to MySQL database running on RedHat Linux from a Windows 95' Workstation using ODBC?

Jun 30th, 2000 12:22
tom brown, Ravi Shankar,

get myODBC drivers from www.mysql.com
install them.

make sure your mysql database is allowing access from another host.
ie:edit user or hosts security tables. ('%' in host field means all)

set up odbc connect as usual in control panels.
you will need to enter the server IP address, user name and password and database name.

there are quite a few other settings, but they are not needed.

that's it.

now open access and import/link to you odbc driven database.