I am trying to write 3 tags (int, string, and float) from an EPIC PR1 controller to a SQL Server database and am having no luck.
These are triggered writes that happen when an integer tag goes true, and they only happen every hour or so, and just need to write one record. I have been trying to use OptoDataLink but to no avail. Can’t get the connection to happen. We know the server, database name, table, and login and password are all correct as we can login in to the database with them, but it won’t work with OptoDataLink.
We are using PAC Project 10.4.
We can ping the EPIC from the computer that the server resides on, so we know that there is network connectivity. My application (waste water pH control) on the EPIC is running great - we just can’t get the data to log to the database.
One of the errors we are getting is:
“Could not connect to database [ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error
ERROR [01000][Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen(SECDoClientHandshake()).”
There are other PC’s on this subnet that are using OptoDataLink to write from PAC R1’s to a different database on the same SQL Server machine. We looked at how they are setup and tried that as well. No luck.
Is there an easier way to do this? Some have suggested Node Red, but you have to find a node that does this, and I have not used Node Red before, so it needs to be pretty straightforward.
thanks for any help!
- Kurt