February 1, 2008 at 1:26 am
I have setup an IIS Web site and a SQL Server 2005 64-bit, but my ASP web page always displays :
Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distributed transaction error
/_lib/function/Connection.inc, line 167
What is it ?
Does it come from the IIS or the SQL Server, please help me, thanks
February 1, 2008 at 2:03 am
Hi,
make sure the distributed transaction coordinator (DTC) is configured correctly. The web server and the SQL Server must be able to see each other over the network, by name. For more information on configuring MTS for use with DTC and SQL Server, see KB #191168. There is also a new KB article written by an ASP.NET MVP: KB #555017.
And be sure to use an the right OLE-DB connection string.
[font="Verdana"]CU
tosc[/font]
February 4, 2008 at 2:13 am
Dear Torsten,
Thanks.
I resolved the problem by myself.
It was because the Web server was made by just cloning but not a proper install.
The problem was fixed by : uninstall MS DTC and then install it again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply