Erro na string select - Mysql com VB.NET

[Leandro Braçaroto 0]

Dim cmdEmpresas As New OdbcCommand("SELECT * FROM empresa e, empresaCliente ec WHERE e.empresaId = ec.empresaId AND ec.empresaId ='" & codEmpresa & "'", con)				Dim drEmpresas As OdbcDataReader				Try					con.Open()					drEmpresas = cmdEmpresas.ExecuteReader()....

o que pode ter de errado no código acima?está dando erro no drEmpresas = cmdEmpresas.ExecuteReader()está dando o erro abaixo:

System.Data.Odbc.OdbcException was unhandled by user code ErrorCode=-2146232009 Message="ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]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 ')'' at line 1" Source="myodbc3.dll" StackTrace: at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteReader() at rep_administracaoEmpresaCadCliente.Page_Load(Object sender, EventArgs e) in D:\Desenvolvimento\WebSite System Service\WebSite v.3\Projeto\website\rep\administracaoEmpresaCadCliente.aspx.vb:line 29 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

já fiz de tudo e não achei nenhum bentido ) errado =/

[Leandro Braçaroto 0]

Já encontrei o problema, eu passava errado o valor get...obrigado