Read-only status on tables opened with Foxpro

[redeye44]

We have an application written in Foxpro 6.0 that works along with Great Plains Dynamics using Pervasive 2000i. We use an ODBC connection and are able to retrieve data from Dynamics, but when trying to create a journal entry from Foxpro into Dynamics, it does nothing. Running the monitor utility during this process, it's showing the tables opened as read-only. We have checked the ODBC database configuration and it is set to normal open. We have also turned on the log and the following line is the first error listed.

DIAG [S1C00] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Driver not capable. (0)

We do have about 12 installations that do work, and this has us stumped. Any help would be great.

Redeye

 

[Pervasivite]

We found something like this with Access which also uses the JET engine and it opens two handles to the file, one in read/write mode and one in read-only. This is a property of the application telling our engine how to open the file and we see it most often when developers are trying to updating grids in their app. The best solution is to use a SQL Passthrough instead of the built-in component.

One other possible solution may be:

An ODBC application may return a Pervasive Software ODBC Interface error "Driver Not Capable (0)" when the TableSource property specified the physical file name. The solution is to
make the TableSource property specify the source table name, not the physical file name.

There also may be problems with the DDFs.

Regards,
Pervasivite