This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Help needed on SQL Server Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Help needed on SQL Server Error" Watch "Help needed on SQL Server Error" New topic

Help needed on SQL Server Error

Melinda Savoy
Ranch Hand

Joined: Jun 21, 2005
Posts: 387

I am running everything from my localhost. I have a linked server in my SQL Enterprise Manager with MSDTC, the SQL Agent and the SQL Server all started. When I try to execute my code that contains the query below I an error defined below my sql statement

Any help or direction would be appreciated.

My code looks like:

When the ResultSet rs_EXP = stmt.executeQuery(sql) runs above I am getting the following error:

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
Have you checked out Aspose?
subject: Help needed on SQL Server Error
It's not a secret anymore!