471,349 Members | 1,412 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,349 software developers and data experts.

Error in OLEDB Transaction

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


Jul 21 '05 #1
5 2402
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 :)


.

Jul 21 '05 #2
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 :)


Jul 21 '05 #3
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" <VN@discussions.microsoft.com> 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 :)


Jul 21 '05 #4
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" <VN@discussions.microsoft.com> 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 :)



Jul 21 '05 #5
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" <VN@discussions.microsoft.com> 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" <VN@discussions.microsoft.com> 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 :)
>>
>>
>>
>>
>>
>>
>>


Jul 21 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Martin Hazell | last post: by
reply views Thread by Eyal Cohen | last post: by
4 posts views Thread by Troy | last post: by
4 posts views Thread by Eitan | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.