List:General Discussion« Previous MessageNext Message »
From:John Foley Date:August 11 2000 5:54pm
Subject:RE: Access 97 to MySQL on Solaris
View as plain text  

	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
	Network Administrator
	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
> Hi,
> I'm sure this has been dealt with before, but I'm new to MySQL and I have
> a
> requirement to design reports using Access as the frontend and MySQL at
> the
> backend.
> I am running Access under NT 4 with the myODBC driver installed (version
> MySQL sits on a Solaris box and I have the server's IP
> address
> 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???
> Regards
> Robert
I'm new...Jim Ide15 Apr
  • RE: I'm new...Willem Bison15 Apr
  • Re: I'm new...Christian Mack15 Apr
RE: Access 97 to MySQL on SolarisJohn Foley11 Aug