How do you install a .jar for ms sql on QIE?

Question

Hello,

 

I attempted to install the microsoft JDBC driver into the lib folder on our QIE server, but when I went to the system configuration -> manage external libraries the mssql driver was not available.  I then went into the mssql folder that was unzipped in the lib directory and moved just the .jar file for mssql up to the lib folder.  At that time the driver was available to install on the systems configuration page in QIE.  After installing it and restarting the QIE service we attempted to connect to the database and received a time out error.  The networking between the two machines is good; the authentication on the database is good (username and password); it just appears that the connector is installed incorrectly, or it requires more time to connect (time out is presently set to 10 seconds).  Is there anyway to adjust the time out as well?  Thanks!

Answer 1

These JAR files are called External Libraries in QIE and can be loaded into QIE via the System Administration-> System Configuration->Manage External Libraries. The Jar files themselves must first be put into a folder called ‘lib’ under the directory where the QIE application is installed (e.g. C:\ProgramData\QIE\lib) before they can be enabled in the Manage External Libraries section under the System Configuration.