Error in OLEDB Transaction

[Eitan]

Hello,



I am using transaction in aspx code

Set myCon = Server.CreateObject("ADODB.Connection")
myCon .Open = GetConString()
.....

myCon.BeginTrans

....

call myCon.CommitTrans



For a reason I don't know,

I get the message (sometimes) :

MICROSOFT OLE DB PROVIDER FOR SQL SERVER ERROR '80004005'



What may be the reason for that message



Thanks

 

[Guest]

This is a very broad error code: E_FAIL. If it is not accompanied by anything
else it would be pretty hard to find out what failed. You could also try to
see what happens on the server when the failure is returned.

 

[Avi]

I didn't understand.
Do you think the error related to the transaction somehow ?
Would you help me find out what the error is ?

Thanks

 

[Guest]

You put "transaction" into the subject, not me. As I said you should try to
localize where it happens. Servers log may also be useful.

 

[Tad Marshall]

SQL Server sometimes puts helpful information in the Application event log.
Try Control Panel\Administrative Tools\Event Viewer\Application and look in
the Source column for MSSQLSERVER, look at all errors and warnings.

Tad