OLE DB provider "MSDASQL" for linked server

Gilles Carreau 1 Reputation point


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

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

6 answers

Sort by: Most helpful
  1. Gilles Carreau 1 Reputation point

    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