cancel
Showing results for 
Search instead for 
Did you mean: 

Error : oRecordser.DoQuery(strsql )

Former Member
0 Kudos

'*******************************

strsql="SELECT CONVERT(REAL, RIGHT(LEFT(Code,LEN(Code) - 0),LEN(Code)- (0))) AS KEY_NEW FROM [@USRDVKT] WHERE LEFT(Code,0)='' AND RIGHT(Code,0)='' ORDER BY KEY_NEW "

oRecordser.DoQuery(strsql )

'*******************************

When i excute command : oRecordser.DoQuery(strsql ), it message:

"The server threw an exception. (Exception from HRESULT: 0x80010105(RPC_E_SERVERFAULT))"

Please help me!

Thanks everybody !

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Duc,

If the Error "HResult" means may be the given size in database is less than the give data.

If it helps give me reward points

Thanks,

Regards,

Anitha

Former Member
0 Kudos

Thanks ani nazir !

I did successfull.

Answers (0)