I am facing problems with the JDBC communication channel in PI. I have a sender JDBC communication channel which is trying to execute a distributed query in a SQL Server 2000 database. My query looks like:
select * from [ServerName].[DatabaseName].[dbo].[ViewName]
The reason I have to specify the Server Name and Database Name is because I am connecting to a different database on a different server through PI and then trying to execute the above query. All the required database permissions have been set up correctly and this query works fine if I execute it on SQL Server Management Studio. But in RWB in channel monitoring I am seeing these errors.
Database-level error reported by JDBC driver while executing statement 'select * from [ServerName].[DatabaseName].[dbo].[Viewname] where role_id is not null'. The JDBC driver returned the following error message: 'java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.'. For details, contact your database server vendor.
This looks like a database error but I wanted to check if there could be a problem with JDBC driver used by PI.
Any help, ideas will be greatly appreciated.