aspose file tools
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 OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP 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
Author

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help needed on SQL Server Error