Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Reading a sql server database
rajasekar.rk
Member
03-22-2007 04:03 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Hi Friends,
I am a new user of Labview..
I have a doubt, will it be possible to open a sql database and show it in a graph,and the database is updated continously
and keep updating the graph with new data, jut like real time data viewing...from a data acquisation card...
kindly provide some guidelines to start the project....
Thanks and Regards
Rajasekar
I am a new user of Labview..
I have a doubt, will it be possible to open a sql database and show it in a graph,and the database is updated continously
and keep updating the graph with new data, jut like real time data viewing...from a data acquisation card...
kindly provide some guidelines to start the project....
Thanks and Regards
Rajasekar
TiTou
Trusted Enthusiast
03-22-2007 05:18 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Hi Rajasekar
You can purchase the enterprise toolkit fron NI, it includes a "database connectivity toolkit".
As regards the design pattern to do you you describe, it will depends on the refresh rate you need and the rate at which you want to write your data to the database.
I would have 2 loops :
- one acquiring the data and putting it in a queue,
- and a second that get the data from the queue, logging data to database and refreshing the graph.
If the write time to database is too long and slows down the graph refresh you place it in another loop.
Hope this helps
You can purchase the enterprise toolkit fron NI, it includes a "database connectivity toolkit".
As regards the design pattern to do you you describe, it will depends on the refresh rate you need and the rate at which you want to write your data to the database.
I would have 2 loops :
- one acquiring the data and putting it in a queue,
- and a second that get the data from the queue, logging data to database and refreshing the graph.
If the write time to database is too long and slows down the graph refresh you place it in another loop.
Hope this helps
We have two ears and one mouth so that we can listen twice as much as we speak.
Epictetus
03-22-2007 06:09 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Hi Friend,
Thanks for ur reply,
Is there any other way other to achieve this task..like math script....by our own method..
since it is too costly for our application...that's why...
regards
rajasekar
Thanks for ur reply,
Is there any other way other to achieve this task..like math script....by our own method..
since it is too costly for our application...that's why...
regards
rajasekar
Brian_Beal
Active Participant
03-22-2007 06:57 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
You can use LabSQL.
04-02-2007 03:33 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Hi Friend,
Thanks for ur kindly help..
I was sick for last 1 week..I returned to office today only..I saw ur mail..and
I downloaded the LabSql software..
and I run the Examples...it fetches the Data from the Ms-Access database succesfully...
My Requirement is fetch the Database continously..since the Database gets modified instantly...
and show it on the graph....like real-time .
how to add graph tool to visulalize the data ..............?
Guide me to proceed further with this tool to achieve the task.....
Regards
Rajasekar
Thanks for ur kindly help..
I was sick for last 1 week..I returned to office today only..I saw ur mail..and
I downloaded the LabSql software..
and I run the Examples...it fetches the Data from the Ms-Access database succesfully...
My Requirement is fetch the Database continously..since the Database gets modified instantly...
and show it on the graph....like real-time .
how to add graph tool to visulalize the data ..............?
Guide me to proceed further with this tool to achieve the task.....
Regards
Rajasekar
Brian_Beal
Active Participant
04-02-2007 04:48 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
You can select "Find Examples" from the help menu and search using "graph". That will give you some ideas.
eek
NI Employee (retired)
04-03-2007 08:55 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Hello,
If you are new to LabVIEW, it might be advantageous to check out some free online tutorials that will get you up and running with key concepts and programming techniques. This LabVIEW Interactive Tutorial is one of my favorites. It will most certainly cover the topic of user interfaces (i.e. graphs), when to use them and how to find them.
Cheers,
Emilie Kopp | Applications Engineer | National Instruments
