We have a legacy application with the following architecture: Logical architecture --------------------------------------------------------------- Web layer: ASP 3.0 Application layer: COM+ components written in VB 6.0 Database layer: SQL Server 2000 Deployment architecture --------------------------------------------------------------- Web layer: Hosted on Windows Server 2003 Standard Edition running IIS 6.0. Reads (does not write) data from the database by invoking a COM+ component in the application layer over DCOM. Application layer: Hosted on Windows Server 2003 Standard Edition. Hosts a single COM+ component that invokes a stored procedure in the database to read data. Uses Windows authentication to authenticate with the database. Database layer: Hosted on Windows Server 2000 Standard Edition. Everything has been running fine for the last 5 years. Since last 3 days we are unable to read data from the database. Event logs on the application server show the following error: No:-2147168246 Source:Microsoft OLE DB Provider for ODBC Drivers -> MyDatabase.GetData Description:[Microsoft][ODBC SQL Server Driver]Distributed transaction error SP:spLoadData There are no other details on any of the servers. Can someone provide help on the possible causes for error number -2147168246?

Hi, It seems that you have an own developed application, so the issue seems to be related to coding development. As we mainly focus on the General question about Windows Server system and here is not the best support resource for coding development, it is recommend you to get further support in the corresponding community so that you can get the most qualified pool of respondents. Thanks for your understanding. For your convenience, I have list the related link as followed. MSDN Forums http://social.msdn.microsoft.com/Forums/en/categories Best Regards, Vincent Hu