Problem using Linked server and C\ODBC

Ans

Hi,

We have a problem setting up a linked server to the navision DB using C\ODBC. When I call a stored procedure, it returns the data. But I can only do this 1 or 2 times and then I get the following error:

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Navision Software a/s][Navision Financials ODBC Driver]ISAM error]

When I restart Sql Server the stored procedure again works for 1 or 2 times.

I have no problem linking and viewing the tables in Access.

Anybody had a similiar experience and perhaps found an answer?

Thanks,
Ans

CHRISPPY

I have the same problem

Please answer us.

Cristina Menéndez.