This is the scenario -
We are trying to point an asp web server to a SQL 2000 database thought a WAN link. If we point the web server to a database server lying in the same LAN it works fine.
If we point the same web server to the same database across the WAN, we get the following error.
Driver={SQL Server};Server=aspsql;Database=TEST0213;User id=AgencyUser;Password=asp;AgencyId=174 sp_GetUser SP String: sp_GetUser 1,174,1 Error: -2147168246 Description: [Microsoft][ODBC SQL Server Driver]Distributed transaction error
The only difference I can see between the two scenarios is the physical distance between the web server and database server.
Please help. Could this be a subnet issue?
We are trying to point an asp web server to a SQL 2000 database thought a WAN link. If we point the web server to a database server lying in the same LAN it works fine.
If we point the same web server to the same database across the WAN, we get the following error.
Driver={SQL Server};Server=aspsql;Database=TEST0213;User id=AgencyUser;Password=asp;AgencyId=174 sp_GetUser SP String: sp_GetUser 1,174,1 Error: -2147168246 Description: [Microsoft][ODBC SQL Server Driver]Distributed transaction error
The only difference I can see between the two scenarios is the physical distance between the web server and database server.
Please help. Could this be a subnet issue?
