What "build in" funtionality can databound controls use (like GridV.) use with mySQL?
I am using VWD and connecting to a mySQL database through an ODBC connection. That tests out okay.
However when try to use the connection string to bind it to my GridView control on my aspx page I get an error:
Database schema could not be retrived for this connection. Please make sure the connection settings are correct and the database is online. The conncetion has been disabled.
(however I can still press "ok" and get through the GridView guide for configuring the datasource)
But when I try to "run" my application I receive the following exception:
ERROR  [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[GaveListe]' at line 1
(which I kind of expected as the datasource configuration for the GridView did not complete error free)
So my question is
Can I do it like I do it? (meaning setup GridView to use my mySQL connection string and still expect to be able to add "UPDATE, DELETE, etc" to the control) - Or do I need to write something more? (note that my DB is currently empty - It's just the table that I have created without any content).
Best Regards Allan Ravn