Greetings,

I have 2-networked PC running on Windows 2000, a server PC with IP 192.168.0.1 (installed MySQL ver 4.0.12, MyODBC ver 3.51.06 and storing MyISAM tables) and a client PC with IP 192.168.0.9 (just installed MyODBC ver 3.51.06).

I could use my own developed program to access my database without any difficulties on server, but I could not access the same database thru client, even I had installed MyODBC ver 3.51.06 and set up a System DNS driver for it. However, I get this error message when I click on "Test Data Source": -

[MySQL][ODBC 3.51 Driver] Host '192.168.0.9' is not allowed to connect to this MySQL server

For your info, this is "my.ini" stored in server: - [mysqld] basedir=E:/DataPath/mysql datadir=E:/DataPath/BCB/SSH

skip-innodb skip-name-resolve

[WinMySQLadmin] Server=E:/DataPath/mysql/bin/mysqld-opt.exe user=Admin4ALL password=1234

Questions ========= 1) Do I need to install MySQL ver 4.0.12 on client PC in order to access server's database? 2) Any steps I missed?

Please help and thanks in advance.