Post reply

Command text was not set for the command object

  • August 5, 2009 at 3:56 am

    #156060

    hi

    can any body tell me

    why i am getting below error ??

    OLE DB provider "SQLNCLI" for linked server "MyMirror" returned message "Command text was not set for the command object.".

    Msg 7215, Level 17, State 1, Line 207

    Could not execute statement on remote server 'MyMirror'.

    this error , i m getting while establishing mirroring between two SQL instances .

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • August 5, 2009 at 4:24 am

    #1034684

    I didnt experience such, but just make it sure that your network is going well, linked server is accessible of that user that is mentioned in linked server. you can test your linked server by writing a query. and your remote connections are enabled on your server.

    Best of luck.

  • August 5, 2009 at 8:36 am

    #1034829

    I've seen you've been having a few problems. What OS is this running on?

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

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