This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 386

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
 
Similar Threads
DROP table question
MetaData question
Question on Unhandled Exception - please help!
SQL Server DB connection
SQL Server Connection question