Link to home
Start Free TrialLog in
Avatar of anthony0007
anthony0007

asked on

MSDTC on server is unavailable

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
ASKER CERTIFIED SOLUTION
Avatar of JMattias
JMattias
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial