Extract ODBC Data Long Field Names

[JohnGial]

I need to extract some data created by the lookout 4 data logging (.thd files).  Is there a way to do that. I am using a PC that has not the Lookout Installed, I have only the database files 

What I have managed up to now is to export some of the fields whose names are less that 62 characters long (using the Logos 4.5 program and Citadel 4 ODBC database driver by limiting the setting of field names to 62). If I increase the limit to around 100 that is required to extract all fields I cannot export them to Microsoft Query or any other software (that supports ODBC database import). I have tried several programs but usually they pop a message that only one point at the time can be read (or they do not see the fields or values at all)

 Please, can you tell me ANY way that I can extract the data?

[jdr_ni]

Hi,

I'll try to help you out. Can you post the query string that you are using and the exact error message that is being returned?

Thanks,

J.D. Robertson

National Instruments

[JohnGial]

Hello,

I finally managed to extract the data using an ODBC query software that worked. The data for the particular tag I was looking for goes around 3 days before the database was captured even that the setting for the Logging Lifespan was for 1 day. Does this means that the data logged are kept for a longer period that the Lifespan setting? For how long approximately?

Thanks,

John.

[jdr_ni · Accepted solution]

The database lifespan is not aggressively enforced. The database does not seek out and delete data simply because the lifespan has expired. Rather, the lifespan is enforced only when new data is being logged to the database and the logger would need to increase the size of the database in order to store incoming data. The rate at which data is removed from the database will vary depending on the rate at which new data is logged to the database. If the logging rate is slow, it might take a very long time for data to be removed.

J.D. Robertson

National Instruments

[JohnGial]

Thanks for the support

John.