我正在尝试在Windows桌面环境中将pentaho 9.1连接到Azure SQL Server,但我收到以下错误消息:
Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
net.sourceforge.jtds.jdbc.Driver
我已经从Microsoft下载了JDBC驱动程序,并将mssql-jdbc-9.2.0.jre8复制到lib路径或mssql-jdbc-9.2.0.jre11复制到lib路径。我已经将mssql-jdbc_auth-9.2.0.x64.dll复制到\libswt\win64。
我该怎么办?
我明白了!
只需从 https://sourceforge.net/projects/jtds/files/ 下载驱动程序
答案的来源-https://forums.pentaho.com/threads/217129-How-to-connect-PDI-with-MS-SQL-Server-2016/