March 12, 2010 at 8:35 pm
i m new in this sql server database programming.
in my project i need to use database SQL server,i have an array in my project that i want to connect with SQL server
and when ever the array is updating my database also to be updated.
how i will write the programme for that
please help me
March 14, 2010 at 12:11 am
Could you please additonal details and be a little more specific?
Provide sample Code schema, data, etc.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 14, 2010 at 9:52 pm
sir ,
here i m using labview for my project,in that i made an array that i want to connect with SQL server that should work with above requierment .in my array data will come from PLC, when ever plc array is updated my labview array also will be updated.so same time that want to store in database also
so i want query for that
if you are not femilier with labview you can explain with visual basic also
thank you
March 14, 2010 at 10:06 pm
What output are you expecting this DB application?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 14, 2010 at 10:35 pm
sir ,
here just i want to store my data in SQL sever that is taken from PLC
PLC>>OPC(OLE for Process control)>>Labview>>SQL
March 14, 2010 at 11:53 pm
I'm sorry but I do not understand how I can help you.
Perhaps the brightest members of this forum can assist you with the information that you have provided.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2010 at 10:17 am
Try here
March 16, 2010 at 10:52 am
I am very new to this board and somewhat new to SQL, but I have been working with PLCs for quite some time, however, I do not use OPC. With that said, you should really explain what a PLC is and what OPC does when you ask for help. I have never worked with LabView. I know they make OPC servers/data loggers that make direct connections to SQL and dump data there for you. I assume that LabView can either get the data from an OPC or SQL server at that point, but I don't know what you are looking for exactly.
For those that are reading this post, and on behalf of the original poster, a PLC is a Programmable Logic Controller that can be used in process controls such as car manufacturing, or water plants to control chemicals, mixing, flow control and such. They generally use ladder logic to view analog and discrete status inputs to make decisions like outputting an analog signal to control speed or a discrete output to turn something on. They can measure, make calucalations, and decisions for small or very large processes. An OPC server can be used to communicate to the PLC to give an operator a graphical interface to do something like turn something on or change speed or a whole host of things. The OPC server can have many different communication protocols like MODBUS, DNP, DH+ and others and gathers data from PLCs and many other capable devices to provide the data logging and GUI for the end user.
March 24, 2014 at 5:53 am
One option is to use OPC Client Library - QuickOPC, http://www.opclabs.com/products/quickopc/languages-and-tools/sql-server.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply