Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error
- Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error
- Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Or Access Violation
Instead of @data in the query, like this: insertStatement = 'INSERT INTO ' + tabela + ' (Data, Fetr, Fldo, Nrdo, Dii) ' + ' VALUES (?, 'cc','CD', ' + number + ','+ dii + ')'. Msdn says: When CommandType is set to Text, the.NET Framework Data Provider for ODBC does not support passing named.
Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error
Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Or Access Violation
T-SQl,No problem Because, when i change connection string to Jet4.Oledb and so Odbcparameter to Oledbparameter, i dont have any problem and The program works correctly. But I need to Odbc command and visual foxpro connection string, and when i use it,I meet error on Comm.ExecuyeNonquery System.Data.Odbc.OdbcException was caught ErrorCode=- Message=ERROR 42000 MicrosoftODBC Visual FoxPro DriverSyntax error. Source=VFPODBC.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, SQLAPI odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery InnerException.