Error [HYS12] [Microsoft][ODBC DBASE Driver] Index not found.

[Guest]

Hi,
I use a .NET windows application that reads a dbf file. It uses a
DataAdapter to fill the datatable with the dbf file content. No problems in
most of the clients and also no problems with that in my machine or our
development environment (Windows XP SP1 or SP2). But there are couple of
clients having the same error.
That is the ODBC error - [HYS12] Index not found. I don’t think there is any
permission problem. They also have MDAC 2.8 as I do have. Has anyone
encountered this problem?

 

[Guest]

Check the version of the MDAC on these machines. It is possible the DBase
ODBC driver on their machines requires indexed DBF files to work (long shot,
perhaps, but something to examine).

In addition, you should find out if indexes are normally created, but not on
these particular clients (assuming local DBF files).

Outside of this, I would look through a DBase knowledge base for what might
cause this particular error. FoxPro or Paradox KBs might also hold the answer
as both use a customized DBase format.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************