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

 

[TomKane]

Could it be that you've come up against your maximum number of sessions/users?

It's been a long time since I worked on Foxpro, but, I was wondering are you using SQL commands to do the journal entries or are you using the x-base update commands?

Do the updates work every time if you execute the commands from the SQL Data Manager?

 

[redeye44]

I don't think it's a session/users issue. Generally there are only one or two other users working at the same time and I have tried several times after hours when I am the only user.

We are using the Foxpro update commands to create the journal entries, which has worked for ten other customers with no problems.

We have not tried executing the commands from Pervasive, we will give that a try and see what happens.

They are running with the most current service packs for Pervasive, Dynamics and Windows NT. I am logged in as administrator will full access.

Thanks for your reply,
Redeye