Hi,
I am working with Advanced OPC Server and the SQL Database Professional plug in. I have managed to communicate with the OPC server to retrieve tags and connect with the SQL server.
We would like to add our queries to the SQL queue section but do not know what topic to direct the query towards.
We would also like to know whether each tag will require a query or if we can simply dump all the values into our SQL server.
I may have just missed this in the manual or in this forum but any help would be great!
Please, look at this very similar tutorial:
http://www.dataloggersuite.com/dde-to-mssql-2.htm
It is for DDE, but you can do same for OPC.
Thanks for the link Arthur - I was able to work out data export to SQL via ODBC.
I am now working on accessing and logging data to our central SQL server across a network of several computers. I've found another post with clear directions that will coach me thru DCOM setup (http://forum.aggsoft.com/index.php/topic,616.0.html) and will be working thru that shortly.
I appreciate your help with this issue and will reply back if I run into any additional problems. Thanks again!