RE: need help with ODBC!

Step one - If you are using Windows/Access, set a DSN within either Access
or START > PROGRAMS > ADMINISTRATIVE TOOLS > DATA SOURCES. That way you will
not have to use the test connection everytime.

It sounds as though your new user doesn't have SELECT access to your
database, which would cause you to not have connectivity. Go back into the
mysql client and use:

mysql> GRANT ALL ON *.* TO 'user'@'hostname' IDENTITIFIED BY 'password'
USING GRANT OPTION;

This will give your user global super-access to all your databases. If you
want to restrict their access, only choose the options you want your user to
have.

Secondly, see the above mysql CLI option to give your new user access to the
mysql table.

Hope this helps...

J.R.



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx