Microsoft.Data.Odbc gives me error

[yahoo182]

Hi there,
I am able to sccessfully open a connection to MySql db. but when I try to execute the following code, I get an error

string tableName="images";
OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();
OdbcCommand MyCommand = new OdbcCommand("DROP TABLE IF EXISTS"+tableName,MyConnection);

however, if I hardcode the table name like so, it works correctly.

OdbcCommand MyCommand = new OdbcCommand("DROP TABLE IF EXISTS images",MyConnection);

 

[Veep]

You need a space " " between EXISTS and your tableName
("DROP TABLE IF EXISTS"+tableName
should be
("DROP TABLE IF EXISTS "+tableName

 

[yahoo182]

Gosh
thanks Veep. That did the trick.