Results 1 to 7 of 7

Thread: A Strange Error

  1. #1
    Join Date
    Feb 2006
    Posts
    17

    Unanswered: A Strange Error

    Today I got a error message from one store procedure.

    "Cannot fetch a row from OLE DB provider "STREAM" for linked server "(null)".."

    Did anyone met this error before?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No. Post your code.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Google is your friend

    Cannot fetch a row from OLE DB provider "STREAM" for linked server - Google Search

    Maybe Flomax?

    In any case...sounds like you have alinked server and my guess is that it is set up for windows auth hvalidation, of which you are not authorized

    So...

    No. Post your code

    I just can type more because I'm not blind
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2006
    Posts
    17
    yeah, I used a query via linked server in my procedure. Code like below:

    Code:
    EXEC
    (N' 
    SELECT
        *
    FROM db1.dbo.arcash WITH(NOLOCK)        
    WHERE (CustomerNumber = ?     )
    	AND (CompanyCode = ?)
    ',
    @CustomerNumber, @CompanyCode 
    ) AT server1

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    what's with the ?'s

    And dynamic sql to boot

    Wait is this a new syntax for 2008?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Feb 2006
    Posts
    17
    No, it is syntax for 2005.

  7. #7
    Join Date
    Feb 2006
    Posts
    17
    And our production server is SQL 2005 SP2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •