Incorrect Data When Using Database Variant to Data VI with SQL DatabasePrimary Software: LabVIEW Development Systems>>LabVIEW Professional Development SystemPrimary Software Version: 1.0 Primary Software Fixed Version: N/A Secondary Software: LabVIEW Toolkits>>Database Connectivity Toolset
Problem: I am trying to send a large amount of data to my SQL server but the data is all wrong. What am I doing wrong? Solution: A known issue with SQL Server 2000 is that it has a maximum binary data size of 8000 bytes. If data size exceeds this amount there is a risk of termination characters and data not getting interpreted correctly by the database. The best way to avoid this problem is to limit the size of your data to 8000 bytes per transmission before using the Variant to Data VI. Related Links: KB 27JCLTDM: Common Questions: LabVIEW SQL Toolkit KB 4LSECVDR: Compatibility between the SQL Toolkit for G and the Database Connectivity Toolkit Attachments:
Report Date: 11/05/2008 Last Updated: 11/11/2008 Document ID: 4R4AE29A |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
