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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.