permaculture playing cards
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
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
I agree. Here's the link:
subject: Help needed on SQL Server Error
It's not a secret anymore!