We are using SQL Linked servers and are receiving the error [ProvideX][ODBC Driver][PVKIO]Invalid segment number in one company (JAN). We are getting this error when doing a Select * From GL_DetailPosting. (Other tables work without error.) We can get a select TOP to work occasionally. It seems sometimes we can select TOP 10000, for example, and sometimes not. And we've tried TOP various numbers of records, but it seems it's inconsistent, though Select * always fails.
We are using linked servers successfully for all other companies except this one (JAN), and we have A LOT of companies. We have all the DSNs configured exactly the same way. We are using the 64-bit ProvideX driver, as that is generally best practice, as I understand it. We will try and test using the 32-bit driver, but don't have high hopes for that. We will also try the ODBC Client Driver. We have already rebuilt the GL_DailyPosting file and have gone as far as to *UFAR the file. We have also purged GL history and that shrunk the file to a minuscule size, but the error persists.
Hoping for some guidance.
Thanks!
