Read-only status on tables opened with Foxpro
Read-only status on tables opened with Foxpro
(OP)
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
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
RE: Read-only status on tables opened with Foxpro
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?
RE: Read-only status on tables opened with Foxpro
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