database skeleton frame

[m_min]

I'd like to request a database skeleton frame for an application.

Ok. here is the story. I m doing the driver interface for a datalogger. I've done some part with polling data and text file parsing/processing and putting them into arrays and stuff. But i need to store those data into database as the users will view and analyze the data later. I have Database toolkit and I was trying to implement with state machine style but still couldn't work out.

It will have just simple 3 functions. 1. creating tables for new entity. (like every 6 month or so) 2. inserting data into the tables (every 3 hours or so) 3. Fetching data from tables (everyday )

Any idea?

[m_min]

I forgot to mention one thing, I will be using MS SQL server and I have finished setting up them already.

[CarlaU]

Hi m_min,

The first thing to try out is to make sure that the server is working correctly. Have you tried to send and/or recieve data with a third party client? That way, we could eliminate that as a problem. Also, can you elaborate a bit more about what was not working with the state machine (were you getting an error or had a broken run button)? There is a lot of great information in the Database Connectivity Toolkit. Chapter 5 deals specifically with fetching data and executing SQL statements. There are some good examples in there and some other great ones in the NI Example Finder (Help » Find Examples). If you click on the browse tab, you can then double-click on the following folders to get to the database examples: Toolkits and Modules » Database Connectivity. I hope this helps!

[m_min]

can u guys show me an example which is big enogh to contain all those database functions? I have tested with all single functions and ok. What i need is to combine all of them in one program....

Thanks...

[CarlaU]

Hi m_min,

There are some very good examples using the Database Connectivity Toolkit in the NI Example Finder (Help » Find Examples). If you click on the Browse tab, you will see a list of folders in the middle pane. Double-click on Toolkits and Modules » Database Connectivity and you will see several good examples using the database connectivity functions. I hope this helps.

Carla

[m_min]

I have checked those examples already but the application i wanna build is much larger than that...  🙂

[CarlaU]

Hi m_min,

I have also found another great place where there are some examples using the Database Connectivity Toolkit. There is this Developer Zone article that references a few demos that you could find useful. I hope this helps!

Carla

[m_min]

thx.