Distributed transaction error

Hi,
I am getting the below error after a timeout when trying
to connect to an SQL Server database. This refers to the
connection setup to the database from my asp page. This
was working perfectly fine until 2 days ago and this same
connection is used throughout the system with out any
problems or timeout issuse.
Microsoft OLE DB Provider for ODBC Drivers
error '8004d00a'
[Microsoft][ODBC SQL Server Driver]Distributed
transaction error
/hbc/weightcoach/counselling/weeklyreport.asp, line 8
Line 8 refers to the following code:
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open Application("DSN"), Application("UserName"),
Application("Password")
where the application variables are set out in the global
file as used by most pages on the site.
I changed the page to just the connection and removed all
transactions to narrow down the problem but no change. It
seems to be the connection that's causing the problem on
just this one page.
Could this probably be a lost packet issue? Any help
apprecaited.
Regards,
DeirdreDid this ever get resolved? I'm having the same problem.
/J
deirdre wrote:
> *Hi,
> I am getting the below error after a timeout when trying
> to connect to an SQL Server database. This refers to the
> connection setup to the database from my asp page. This
> was working perfectly fine until 2 days ago and this same
> connection is used throughout the system with out any
> problems or timeout issuse.
> Microsoft OLE DB Provider for ODBC Drivers
> error '8004d00a'
> [Microsoft][ODBC SQL Server Driver]Distributed
> transaction error
> /hbc/weightcoach/counselling/weeklyreport.asp, line 8
>
> Line 8 refers to the following code:
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.Open Application("DSN"), Application("UserName"),
> Application("Password")
> where the application variables are set out in the global
> file as used by most pages on the site.
> I changed the page to just the connection and removed all
> transactions to narrow down the problem but no change. It
> seems to be the connection that's causing the problem on
> just this one page.
> Could this probably be a lost packet issue? Any help
> apprecaited.
> Regards,
> Deirdre *
jojje
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message174004.html