Good Morning,
I have a gateway version 8.3 and I would like to connect to a Microsoft SQL 2014 server running in a different server, I can ping the other server and I can setup the OBDC Data sources/System DSN and test successfully the connection but when I add the database connection inside the Ignition gateway configuration the JDBC driver seems to be working only for new versions of Microsoft SQL server, is there a driver that I could download for older versions of Microsoft SQL Server?
v12.6 was the latest for 2014 support.
Thank you Jordan, I have downloaded this version and I have created a new JDBC driver on the Gateway, I pointed to the *jar file on the extracted folder. It didn’t give me any errros when adding the driver but when I created a new database connection I got the following error:
See Error connection SQL Server database after upgrade Ignition - #2 by Kevin.Herron or similar posts.
It might also be worth trying to add encrypt=false; to the connection parameters before any of the more difficult suggestions.
I don't know if it's quite relevant to your situation, but some of what I learned on this thread may be of interest.
Thank you Kevin and the rest for jumping on this, after upgrading the SQL Server 14 to the right version to suppport TSL , the connection worked fine, thank you so much
