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

sureshgoud bhimagonolla 1

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

Erland Sommarskog 107.2K Reputation points

2021-02-14T11:39:44.03+00:00
As a starting point, we need to see

The definition of the linked server. (As a script, no screenshots please.)

The full error message. More precisely, with error with linked servers there are usually accompanying message from the OLE DB provider. They are often presented as informational and do not appear in red.

The actual query you are running.

The output of "SELECT @@version".
sureshgoud bhimagonolla 1 Reputation point

2021-02-15T05:03:05.047+00:00

Here is the Script:

Actual Query:

SELECT * FROM
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"')

Here is the Result:

Version:

Provider Properties:

I have seen the same issue last time, But it got solved by checking "Allow In Process" in the Provider properties.
AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor

2021-02-15T09:43:22.607+00:00

Hi sureshgoudbhimagonolla-8336,
Could you please try to turn "Allow inprocess" off, save, then turn it back on?
Please refer to this thread which might help.

Best Regards,
Amelia
sureshgoud bhimagonolla 1 Reputation point

2021-02-15T11:48:32.11+00:00

Hi,
I have tried checking and unchecking the "Allow in process". But, No success at all.

I am not able to see the disabling the "Enable pre-fetch of data for queries" option In the ODBC Data Sources.

Regards,
Suresh Goud

1 answer

Erland Sommarskog 107.2K Reputation points

2021-02-15T22:13:30.927+00:00
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: https://www.ibm.com/support/pages/apar/IC67242

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:

SELECT * FROM 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''')
Please sign in to rate this answer.
sureshgoud bhimagonolla 1 Reputation point

2021-02-16T06:16:58.477+00:00

There is no syntax issue in the query. because it is getting executed till 15th min and 16 seconds. It has fetched 180 records in the result set after that am able to see the error. but actual total records are 26000.

We have old SQL SERVER 2005 and Same configuration was applied on that. Query is getting executed successfully on that.

Erland Sommarskog 107.2K Reputation points

2021-02-16T07:42:58.427+00:00

There is no syntax issue in the query. because it is getting executed till 15th min and 16 seconds.

So why didn't you say that originally? That would have saved me from wasting my time investigating why the query did not run at all - which was the obvious assumption.

What more is it you did not tell us?

Please keep in mind that people here (except for some of the -msft posters) post here in their free time. It is a matter of decency that you help us as much as you can to help us.

I have no idea of what is going on, and on this point I am not sure that I care. You will need to do some troubleshooting on your own. For instance, try to trace things on the Informix side. This is not likely to be an SQL Server problem - SQL Server is only the client. It is the ODBC driver that gives up.
Sign in to comment

Share via

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

1 answer