Pervasive

Running Pervasive 10 Workgroup on Windows 7/64-bit Professional.
When we try to connect to a database through ODBC or Pervasive Control Center, we are getting the following: "Invalid Btrieve operation code (Btrieve Error 1)".  There is no issue when connecting to local databases (i.e. DEMODATA).
I'd appreciate any help - thank you.

A few questions:

Is the WOrkgroup running as a service or as an application? 

How is the database defined in the PCC?  Does it use UNC or mapped drive?

What version of v10 are you using?  Are you patched to 10.31?  

Is there an engine running on the remote database?  

It sounds like you have created an ODBC Engine DSN, and the data files you are trying to open reside on a computer that has an older version of the Pervasive engine (or Btrieve 6.x) on it.  The Status Code 1 would likely come about as a result of the newer PSQLv10 SQL engine attempting to send requests to a remote Btrieve engine that doesn't understand the incoming requests.

First things first -- check to see if the server (where the files reside) has an older engine on it.  Disable the engine (if you are not using it).  If it is in use, then switch back the the matching ODBC driver for that version. 

Keep in mind that PSQLv10 was the first version officially supported on Win7, so you may have to do things like disable UAC or stuff like that.  You can try the 18-page Vista white paper (which explained how to get PSQLv9 working with Vista), of which you can find a copy here:

    www.goldstarsoftware.com/vista.asp

Another potential problem older versions used a 16-bit installer which simply won't run on a 64-bit computer.  If you find this, then upgrading the entire environment to PSQLv10 (or the newer PSQLv11) is the best course of action.

BtrieveBill, you are right. We installed PSQL10 on only one machine while the rest is running PSQL9.6.
I apologize for starting this thread and being very tardy with my replies but I was trying to solve the issue. So, once I discovered it is incompatibility problem between 10 and 9. I am quite happy to find that this is the issue as the solution is relatively simple - we have to upgrade everybody to version 10. There were two reasons I was not very keen on upgrading all users to 10.

First, we  use quite a large piece of software written in Delphi. Each time we change version of Pervasive we have to install new version of PDAC and rebuild the Delphi system. This is extra risk, time, work, testing etc so I though I can avoid that at least for short time. Secondly, the other application we run that uses Pervasive is somehow able to work on the new machine with PSQL10 while connecting to database hosted by PSQL9.6  That application does not use ODBC and Pervasive Database definitions . They might be using BTrieve API or whatever else and somehow they manage to connect. So that was misleading as I thought PCC and ODBC should work as well.

Thank you very much for all the help. You guys are great and that's part of why  I like working with PSQL.

Thanks a lot