OLE DB provider "MSDASQL" for linked server

Gilles Carreau 1

Hi,

I use a linked server to read data from an accounting application Acomba
First I use a ODBC driver from acomba and create a DSN 32 bits
I test the DSN and succeded
I test the ODBC driver with Excel and I can read the data from the Acomba database

Now on a my SQL Server I created a Linked server with this ODBC I did the test for the linked server and the test succeded
In the providers MSDASQL I activate the Allow Inprocess checkbox

When I do a simple select with my linked server like this

I received this message :

OLE DB provider "MSDASQL" for linked server "SIMA" returned message "[Acomba ODBC Driver]Exception dans la fonction ISAMNextRecord".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "SIMA".

If I do select * from Openquery(SIMA,'select count(*) as NbRec from Customer')
I received the numbers of customers coming out from the Customer table with no error

It is very hard to find information about this error message

This use to work for many year but now it does not work anymore

What can I verify to find out the cause of this problem and fix it

The sql server version is :
Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86)
Nov 1 2020 00:46:51
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)

Thanks in advance

CathyJi-MSFT 21,096 Reputation points Microsoft Vendor

2022-05-03T09:18:36.607+00:00

Hi @Gilles Carreau ,
I discussed your issue with my colleague, we need to use BID trace to capture the driver information and use profiler trace to capture SQL server linked server information to analysis this issue. So we suggest you ask professional engineer for help, and they will deal with your problem separately and confidentially. https://support.microsoft.com/en-us/assistedsupportproducts. since we don't have access to your environment.
Gilles Carreau 1 Reputation point

2022-05-03T15:55:29.197+00:00

Hi,
Good idea
Thank you for the information I will try it and see if I can get more information about this problem.

6 answers

Gilles Carreau 1 Reputation point

2022-05-02T21:12:50.497+00:00

I already talk with acomba support etnd we made test with excel with the same ODBC that I use with my Linked server and everything works fines
Soon that I use my Linked server it does not work anymore

So Acomba told me because it work fine with Excel it looks like your problem is with your Linked Server
I am trying to find out the problemlike you said it is hard to find

Is there any logerror I can look that mite give me an idea of the problem

Thanks in advance
Please sign in to rate this answer.
Erland Sommarskog 101.9K Reputation points MVP

2022-05-02T21:18:08.327+00:00

Again, you need to talk to Acomba. It is their product that is failing, and it is their product that needs to provide more detailed information about the error.

Saying that it works with Excel and therefore the problem is with the linked server is not a very professional answer. The problem with the linked server is exactly their ODBC driver.

Then again, if they don't support this scenario, you will have to look for a different solution altogether.

Gilles Carreau 1 Reputation point

2022-05-03T15:57:51.95+00:00

I agree with you I felt the same way. I will see what I can do.
Sign in to comment