我已经尝试了很多次将Pentaho CE连接到SQL Server 2005中的数据库但没有成功。我首先在安装了 Pentaho CE 的 Ubuntu 上执行此操作。似乎无法连接到 SQL Server。然后，我将 Pentaho CE 与 SQL Server 安装在同一台计算机上，并遵循 官方指南设置，失败。
步骤如下：
- 下载 MS JDBC 驱动程序（版本 4）并将其放置在
pentaho\bi-server\tomcat\webapps\pentaho\WEB-INF\lib 和 pentaho\administration-console\ 中分别
- 之后，我进入 Pentaho 控制台创建一个新的数据源并按照手册所述设置所有内容。
但是，它总是提示“没有合适的驱动程序...”
有人遇到这个问题或可以给出解决方案吗？提前致谢。
I have tried many time to connect Pentaho CE to database in SQL Server 2005 but not successful. I first did this from Ubuntu on which Pentaho CE installed. It seems impossible to connect to SQL Server. I then installed Pentaho CE on the same machine with SQL Server and was following official guide to set it, failed.
The steps are:
- Download MS JDBC driver (version 4) and place it in
pentaho\bi-server\tomcat\webapps\pentaho\WEB-INF\lib and pentaho\administration-console\jdbc respectively
- after that, I go to Pentaho console to create a new data source and set everything as the manual said.
However, it always prompts that "No suitable driver for ..."
Does anybody meet this issue or could give a solution? Thanks in advance.
发布评论
评论（1）
最后我解决了。它并不那么神秘，而且不需要修改任何文件。有两件重要的事情：
首先，使用 jtds 驱动程序而不是 MS JDBC 驱动程序，尽管 MS JDBC 4 可以工作（但不太好，早期版本根本无法与 Java 6 及更高版本一起工作）。将驱动程序放置在administration-console和biserver-ce下的相应目录中。你可能会注意到新的 Pentaho 版本中的目录与以前不同。它们应该如下所示：administration-console/jdbc/ 和 biserver-ce/tomcat/webapps/pentaho/WEB-INF/lin/
其次，您必须在 URL 中提供实例类型。正确的 URL 如下所示：jdbc:jtds:sqlserver://localhost:1433;instance=MSSQLSERVER;DatabaseName=test。 MS SQL Server 每个版本都有不同的 URL 格式，这非常棘手。你必须找到合适的人。
另一件事是，（我认为）您必须在 MS SQL Server 2005 中启用 SQL Server 身份验证才能与其连接。
Finally, I solved it. It's not so mystery, and don't need to modify any files. There are two important things:
First, use jtds driver instead of MS JDBC drivers, although MS JDBC 4 is working (but not so good, the earlier version not working with Java 6 and later at all). Place the driver in corresponding directories beneath administration-console and biserver-ce. You may notice that the directories in the new Pentaho version are different from before. They should look like:administration-console/jdbc/ and biserver-ce/tomcat/webapps/pentaho/WEB-INF/lin/
Second, you have to provide the instance type in the URL. The correct URL looks like: jdbc:jtds:sqlserver://localhost:1433;instance=MSSQLSERVER;DatabaseName=test. It's very tricky that MS SQL Server has different URL format for each version. You have to find the right one.
One more thing is that, (I think) you have to enable the SQL Server Authentication in MS SQL Server 2005 to connect with it.