|
Title: SQL Server topic for SQL queries Post by: jupton on May 27, 2019, 02:00:00 PM 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! Title: Re: SQL Server topic for SQL queries Post by: Arthur Grasin on June 07, 2019, 02:00:00 PM 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. Title: Re: SQL Server topic for SQL queries Post by: jupton on June 20, 2019, 02:00:00 PM 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! |