I do a bunch of Access 97 / Solaris MySQL . . . BUT the problem you
are having is one of simple permissions.
Look up "GRANT" syntax in the manual in order to add permission to
the user, host, and database (this should be a single GRANT statement).
The host in question is the NT4 client, not the Solaris server.
John T. Foley
Pollak Engineered Products, Actuator Products Division, A Stoneridge
195 Freeport Street, Boston MA 02122
ph: (617) 474-7266 fax: (617) 282-9058
The geographical center of Boston is in Roxbury. Due north of
the center we find the South End. This is not to be confused with South
Boston which lies directly east from the South End. North of the South
End is East Boston and southwest of East Boston is the North End.
> -----Original Message-----
> From: Barrett, Robert [SMTP:Robert.Barrett@stripped]
> Sent: Friday, August 11, 2000 10:28 AM
> To: 'mysql@stripped'
> Subject: Access 97 to MySQL on Solaris
> I'm sure this has been dealt with before, but I'm new to MySQL and I have
> requirement to design reports using Access as the frontend and MySQL at
> I am running Access under NT 4 with the myODBC driver installed (version
> 2.50.31.00). MySQL sits on a Solaris box and I have the server's IP
> and database name set correctly in the driver config.I also have the
> username and password correct. However, when I try to connect to the
> database, I get the error
> "[TCX][MyODBC]Host is not allowed to connect to this MySQL server (#1130)"
> I'm sure there is some additional configuration needed. Can anyone help???