Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
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 =/
Carregando comentários...