TCI Posted March 25, 2013 Share Posted March 25, 2013 We have a system DSN using the MS SQL ODBC connection to a 2008 R2 database in a logging set. We were successfully logging 6 channels from a spinwave network, but due to the Excel time, we were getting repeated record groups of 8 all with the same timestamps. We went back to DF time and that reduced the repeats to 2-3 per timestamp. We've tried both "All Data Points - Aligned" and "Fixed Interval" and both give the same result. We tried logging to ODBC .csv file to see if the ODBC was a problem, but that file looks great. One record per interval. We set up the SQL DSN logging set the exact same way and we still get the repeated records. For the interval, we're using 60 seconds and we're using the "Align Threshold" of 60 seconds to match. Time sig figs is 15. Any idea why we're getting duplicate records when logging to MS SQL over ODBC? Link to comment Share on other sites More sharing options...
AzeoTech Posted March 26, 2013 Share Posted March 26, 2013 Its your precision probably. I'm assuming your data is spaced pretty close? Try changing the Time Precision option in the detail page of the logging set. Note if it logs correctly as a .csv file, but does not log correctly on MSSQL then you probably have an issue in MSSQL with the field type. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.