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 :)

[Cyn]

Is the connection trusted?

-----Original Message-----
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 :)


.

[VN]

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.

"Eitan" wrote:

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 :)

[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 :)

"VN" <[e-mail]> wrote in message
news:1F**********************************@microsof t.com...

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.

"Eitan" wrote:

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 :)

[VN]

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.

"Avi" wrote:

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 :)

"VN" <[e-mail]> wrote in message
news:1F**********************************@microsof t.com...

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.

"Eitan" wrote:

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 :)

[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

"VN" <[e-mail]> wrote in message
news:DD**********************************@microsof t.com...

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.

"Avi" wrote:

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 :)

"VN" <[e-mail]> wrote in message
news:1F**********************************@microsof t.com...

> 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.
>
> "Eitan" wrote:
>
>> 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 :)
>>
>>
>>
>>
>>
>>
>>