Join us today!
Conection Twin CAT2 to SQL Server
I have a Beckhoff CX1010-121 PLC and want to send some data from the PLC to the SQL server. I have done the configuration of the TwinCAT DB Server with its XML-File Configurator. But my Problem:
When I selected the Double mode for DBValue Type, I had the following error:
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource) at System.BitConverter.ToInt16(Byte[] value, Int32 startIndex) at TcDatabaseSrv2_0.Write_to_DB.GetSymValue(String type, Int32 bitsize, AdsStream readstream, Int32 reqNum, E_ValueType ValueTyp, Boolean isBC, Int32& position)=>Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: startIndex
and when I selected the Bytes, I had the following error:
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at TcDatabaseSrv2_0.MSSQLDB.SQL_INSERT(String DBName, Object Value, DateTime timestamp)=>Invalid column name 'Value'.Invalid column name 'Name'.Invalid column name 'Timestamp'.
Can you help me and say what is the reason, Thank you
- 17 Forums
- 267 Topics
- 924 Posts
- 3 Online
- 737 Members