Cannot use schema name with table name

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 6
Joined: Fri 28 Dec 2007 18:11

Cannot use schema name with table name

Post by jswhal » Wed 16 Jan 2008 20:39

I have a MySqlDataSource bound to a gridview on an ASP.NET page. I need to specify the schema name with the table name, as I access tables in two different schemas.

DeleteCommand="DELETE FROM `chims.tasking` WHERE `ID` = ?">

When I click Delete on the grid, I get an error saying "Incorrect table name 'chims.tasking'. When I try and edit a row, when I click on Update, nothing happens - the row stays in edit mode.

The select statement works fine with the schema.table.

Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 17 Jan 2008 12:03

We cannot reproduce the error.
Please send us a small test project to reproduce the problem. It is desirable to use 'test' schema objects, otherwise include the definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of your code where the error occurs.

Post Reply