I try to create database connection from Pentaho User Console to database MS SQL Server 2000 using ODBC access. I already create DSN in both client and server. Then I try to create Database Connection in Pentaho User Console.

Name:  test.jpg
Views: 1433
Size:  18.2 KB

However, when I test the connection, this error show up:

Name:  error.jpg
Views: 1146
Size:  17.4 KB

How I can fix this error? I try to do same connection in Pentaho Data Integration and the Connection to database [sutera] is OK. However, when I do the same step in Pentaho User Console, I got that error. Please someone guide me to fix this error.