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