I have an application served up by IIS on an NT4.0 server
which accesses a Microsoft SQL Server 7.00 - 7.00.1063
database on another NT4.0 server. I have copied the
database to a Win2000 server running Microsoft SQL Server
2000 - 8.00.760 and changed the ODBC properties to point
to the new server. Everything on the application seems to
work until a write to table function is called. At that
point, I get:

"Microsoft OLE DB Provider for ODBC Drivers
error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distrubited transaction
error .....
update.asp, line 26.

If I simply point the ODBC properties back to the NT
server, everything works fine. I have the Database
Compatibility level set to 70 on both databases. The
permissions are identical on the properties of both
databases.

The MSDTC service is running on the NT database server and
the Distributed Transaction Service is running the Win2000
database server. I have run out of ideas on this. Any help
would be appreciated.

Thanks.