RE: ALTER TABLE Denied

I do have some users who make use of the app on a separate machine =
("server" gets a bit ambiguous) but always within their local network.  =
This is the first time trying it on a truly "remote" machine/server.  As =
I mentioned, this is not a new process.  I have been running the process =
for years and never had an issue. =20

Jim

-----Original Message-----
From: Simon Walter [mailto:[email protected]]=20
Sent: Thursday, June 02, 2016 6:39 PM
To: [email protected]
Subject: Re: ALTER TABLE Denied

On 06/03/2016 06:57 AM, Jim Taylor wrote:
> I have an app that uses a local database but am moving it to a remote=20
> database.  I believe I have everything setup correctly regarding the=20
> connection as I can connect using Workbench and alter tables =
successfully.
> The problem is that when I try altering tables via the ODBC  =
connection,
> using the same credentials, I get the Alter Table Denied message.   =
The
> process is tried and true so am reasonably certain I am going wrong in =
some
> other fashion.   I have granted permissions via CPanel and assume I =
couldn't
> make the changes via Workbench if the GRANT wasn't done properly.
> Suggestions?

Hi Jim,

I have noticed that some operations are not supported with the ODBC =
adapter. So that might be your limitation there. I have only ever used =
the ODBC adapter for SELECT, INSERT, and UPDATE.

Simon

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc





-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc