04-23-2012 04:58 PM
I'm trying through NI DIAdem 2011 analyze vibration signals, one of the problemas is that the database is in Microsoft Access and all the data was inserted as a string. So I made a VI that convert all the data to a numeric value and generates a TDMS file for DIAdem.
This VI works perfect with small databases, the major problem is that the files I need to analyze are from 500 mb to 700 mb and when I insert the database the DB Tools Select Data VI gives me the 2147024882 error, I'm guessing becasuse the size of the files.
So, is there anyway to insert all this data without divide my database?
Thanks and greetings.
Solved! Go to Solution.
04-23-2012 08:13 PM
According to http://msdn.microsoft.com/en-us/library/windows/de
Could you provide your machine info? e.g., Windows 7 64bit, 16GB memory, LabVIEW 2011
If you could provide a VI and test db file to reproduce this issue, others might do more help.
04-24-2012 08:35 AM
Hi Bo Xie:
My computer is low in resources
Procesor: AMD Athlon X2 Dual Core QL-65 2.10 GHz
RAM: 3.00 GB
OS: Windows 7 Ultimate
I attached the VI but the forum page won't let me attached de database.
But its just a table with 5 colums, saved in 2002-2003 format, these are the colums:
Eje X (X Axis)
Eje Y (Y Axis)
Eje Z (Z Axis)
You can simulate a signal and insert it into the database for simulate the problem.
04-24-2012 10:17 AM
Thanks for the help but i was able to solve the problem through DIAdem, creating a new numeric channel and copying the generated stings into that new channel and DIAdema automatically converted into numeric data.