error when writing to "long sting" field in database

[labviewette]

Dear community,

I am using LabVIEW Database and Connectivity Toolkit to write a large string into an access field of the type long string. See attached vi. Once I write more than 256B I get the error "invalid precision value". Is this related to using the DCT? Will I need to find a solution using Database connections via ActiveX?

Thanks for any ideas.

[Yamaeda · Accepted solution]

I can't open the code right now, but are you using DCTs Insert or are have you built a string and use "Execute query"? In many cases i prefer the latter as i have better control over it. I know there's often problems with too long SQL commands, but that's usually around 8kb. 256B shouldn't be any problem (unless you mean 256kb).

/Y