I have a web application with several ASP pages that access SQL Server. On
all but one page, I use a certain connection string that works fine. But on
one page I get the following error:
"Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distributed transaction error"
This error occurs on the connection string line, before it executes the
stored procedure, so I'm guessing it is independent of the actual data
command, which comes on a line after the error. I know the connection
string is the same, because I've pasted it from another ASP page that works
twice (just to make sure). I'm using Studio 6.0 Enterprise edition and
editing in Interdev 6. I am working from a remote machine, although the
actual web files are on the web server, of course.