Join us today!

Notifications
Clear all

Conection Twin CAT2 to SQL Server

1 Posts
1 Users
0 Reactions
47 Views
Posts: 1
Topic starter
(@h_samsami)
New Member
Joined: 4 weeks ago

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

Reply
Share: