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?