Inductive Automation Forum

Comments Panel

bassa April 26, 2012, 2:40am 14

Thank you Travis, the solution fixed my problem.

Travis.Cox:

To get the attachments to work with MS SQL Server you can set the INSERT QUERY 1 to the following:INSERT INTO Notes (Note, Username, TStamp, Attachment, Filename, Sticky) VALUES (?, '%s', CURRENT_TIMESTAMP, CAST(? AS VARBINARY(MAX)), ?, ?)Note the CAST(? AS VARBINARY(MAX)).

show post in topic

Home
Categories
FAQ/Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled