RE: ALTER TABLE Denied

"Jim Taylor" <[email protected]> Fri, 3 Jun 2016 06:29:40 -0500
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <014a01d1bd8b$38213820$a863a860$@com>
...message was Sent before finishing...

Did want to say thanks for the reply.

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