Post reply

Could not execute query against OLE DB provider 'MSDASQL'. [SQLSTATE 42000] (Error 7320)

  • July 7, 2009 at 8:00 am

    #223265

    Has anybody came across this error in SQL 2000? I have searched and haven't found much info on the following issue. Anybody have any information on this would be greatly appreciated.

    This is in a stored procedure which runs in job that runs every fifteen minutes.

    This is the error that I am getting:

    Could not execute query against OLE DB provider 'MSDASQL'. [SQLSTATE 42000] (Error 7320) Transaction context in use by another session.] [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandText::Execute returned 0x80040e14]. [SQLSTATE 01000] (Error 7300). The step failed.

    Here is the description of what is causing this error:

    It is in a stored procedure within a Begin Tran on an Insert Statement with a Select statement which has a Case Statement inside the select then in the when another select statement going againt a view.

    The piece of code causing the problem:

    Begin Tran

    insert into #TEMP

    select PKG_TCK_NR, '

    + dbo.quotestring(@ID) + ' AS SER_NR,

    case when CONVERT(smalldatetime, DT)

    IN (Select top 2 srt_dt from dbo.VGetLast3BODRows )

    THEN

    CONVERT(smalldatetime, LD.OUB_SRT_DT)

    Else ' + dbo.quotestring(@SRT_DT) + ' End as S_DT,

    TS

    ======================================================

    I found a workaround where I took the select statement out of the case statement and it worked fine. Also when I took the whole insert out of the Begin Tran it worked fine too.

    Just asking if any has come across this?

    Thanks.

    Pat

  • July 14, 2009 at 9:17 am

    #1024482

    Has anybody ever seen the above error I was getting?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply