Msg 7330 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server

sureshgoud bhimagonolla 1 Reputation point

I have created linked server. when am executing the query I am able to see the error Msg 7330 while executing.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,082 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 103.7K Reputation points MVP

    So the underlying problem is that the Informix ODBC driver returns "Unspecified System Error -21005".

    You may need to find a forum where they talk about Informix to get accurate help. I did however do some googling around, and I did find this page:

    It suggests that there is an illegal character, although it is not clear what that would be. Have you executed this very query directly on Informix to verify that it runs correctly?

    Looking at you query, I notice that you have double quotes in the the string. Now, I don't know anything about Informix, but in ANSI SQL, double quotes delimit identifiers and not strings. So maybe you should try replacing the double quotes with doubled single quotes. That is:

    OPENQUERY(stratix2, 'SELECT tsi_ref_itm, tsi_ref_pfx, tsi_ref_no, tsi_txt FROM
    tcttsi_rec where tsi_rmk_typ = ''35'' and tsi_cmpy_id = ''NBM''')