Error trying to Connect a SQL Server -- Driver class ‘sun.jdbc.odbc.JdbcOdbcDriver’ could not be found, make sure the ‘MS SQL Server’ driver (jar file) is installed.
Issue: Trying to establish a connection with a SQL Server database, but the Process Studio Wizard returns an error as stated below.
Error connecting to database [DATABASE] :com.automationedge.ps.core.exception.ProcessStudioDatabaseException:
An error occurred while trying to connect to the database
Driver class ‘sun.jdbc.odbc.JdbcOdbcDriver’ could not be found, make sure the ‘MS SQL Server’ driver (jar file) is installed.
sun.jdbc.odbc.JdbcOdbcDriver
com.automationedge.ps.core.exception.ProcessStudioDatabaseException:
An error occurred while trying to connect to the database
Driver class ‘sun.jdbc.odbc.JdbcOdbcDriver’ could not be found, make sure the ‘MS SQL Server’ driver (jar file) is installed.
sun.jdbc.odbc.JdbcOdbcDriver
Solution:
- Download the jtds.jar driver https://sourceforge.net/projects/jtds/files/ or use this link jtds-1.3.1.jar (310.4 KB)
- Place it into process-studio/lib directory
- Close process-studio and try again.