Aktueller Inhalt von siddharthdc

It is supported with AS 4.2 Version. I emailed them.IF you know any expert in B&R or a person who has worked with MSSQL and Automation Studio. It will be great help. Sample code did not function. It failed to create a database. I suspect its unable to establish connection even though the...

Yes true I tested it. It certainly gives the right output if I define my field in Siemens as array of char. But unfortunately its defined as string[20] . So when i write to this field it is writing in a hex format or so. I certainly think its the restriction of using the Function block...

Thanks for your reply and spending out the time to write an example. May I ask why did you use Mid$. I know its used to iterate a string. But the reason is you are converting a string to ascii :rolleyes: is a bigger step as you write a string into DB in ascii format. Neverthless I thank you...

Thanks for your reply again. I tried reading the string of 20 bytes long from excel sheet Cell( 12, 5) to Cell(12,9). As you suggested also defined array of Byte to read a string Private Sub CommandButton4_Click() Dim s As Integer Dim a As String Dim h() As Byte Dim b() As Byte For j = 5...

It would be nice if you could share an example. Thanks

Englisch wäre besser

ich habe String von 20 Bytes 80 Bytes ,22 usw . Wie kann ich von Excel ( mit VBA) mit daveWriteByte übertragen. LG Siddharth

Thanks for your reply. My code is working for writing Double Int from an Excel cell. I face problem writing strings of variable byte size from Excel Cell to LibnodaveDb. As the davePut8/ davePut16 / davePut32 will be hard to use along with daveWriteManyBytes

Hello Everyone, I have been working with B&R Automation Studio 4.2 Database Example program. All I need to know is how can one use the Database function blocks with MSSQL Server. in Automation Studio I have tried setting the firewall and activated SQL Browser as I have browsed several videos...

I tried o implement your code in VBA. Unfortunately it doesnt accept buffer the way you have defined it. I get a compile error. I could only write For example : a = davePut32(buffer, Cells(10, 1)) res2 = daveWriteBytes(dc, daveDB, dbnum, 2, 4, buffer). . I would be grateful if you could show...