troubleshooting Question

MSDTC on server is unavailable

Avatar of anthony0007
anthony0007 asked on
Microsoft SQL Server
1 Comment1 Solution3614 ViewsLast Modified:
I am using SQL Server 7 on an XP machine named JAZZ, with a linked server setup with MS Access. I created the link and I know that it is valid because it displays the list of tables within Access. I have named it PDI5CUSTOM. I also know this is valid because when I use the "model" database in SQL Server Enterprise Manager tool and select "New View" I can define a valid View using the following statement:  Select * from PDI5CUSTOM...annualdata. I name the view boo and it does not cause any problems. However, in my application I am trying to create views on the fly by executing: "CREATE VIEW AnnualData  as  Select * from PDI5CUSTOM...annualdata" . When I do this, I receive the message below:
SQLSTATE = 37000
[Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'JAZZ' is unavailable.

I have made sure that DTC service is running. I have looked at the other E-E issues but none of them seem to help.

Any ideas as to what the problem is?

Thanks Anthony
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros