Post reply

Deferred prepare could not be completed???

  • December 29, 2008 at 3:05 pm

    #217027

    OLE DB provider "SQLNCLI" for linked server "Dev3" returned message "Deferred prepare could not be completed.

    I am getting the above error when running this query

    select distinct stateID

    from Openquery (DEVstate, 'Select * from vwstatePA’)

    I cheked the open row set functionality, it is enabled too.

  • December 29, 2008 at 3:45 pm

    #918646

    Is this a remote SQL Server or another data source?

  • December 30, 2008 at 12:18 am

    #918796

    Hi

    Seems to be a registry issue. I read somewhere that reinsatlling mdac might solve the issue not sure though. Saw a lot of links in google about the issue. Try googling.

    "Keep Trying"

  • December 30, 2008 at 6:14 am

    #918975

    Yes its a Link Server where am querying from.

  • December 30, 2008 at 10:01 am

    #919127

    Mike Levan (12/29/2008)

    OLE DB provider "SQLNCLI" for linked server "Dev3" returned message "Deferred prepare could not be completed.

    I am getting the above error when running this query

    select distinct stateID

    from Openquery (DEVstate, 'Select * from vwstatePA’)

    I cheked the open row set functionality, it is enabled too.

    You are missing the "alias"

    select distinct a.stateID

    from Openquery (DEVstate, 'Select * from vwstatePA’) a


    * Noel

Viewing 5 posts - 1 through 4 (of 4 total)

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