Pervasive

We are running a windows 2008 64 bit server with windows 7 clients. We often have an issue that the software that sits on top of the pervasive v10 db ghosts when making requests. Are there any know issues or ways to ensure threading is set up properly?

WHat do you mean "ghosts when making requests?" 

Have you talked to the vendor / developer of the software to see if it's a known problem from the application perspective? 

Because you posted in the v10 section, are you running the latest 10.31 patch?  

Yes we are on 10.31. Ghosting is a term used to indicate when an application hangs and then the application screen is grayed out while the application is waiting for a reply. It may lead to windows asking if you would like to continue to wait or close the application. http://msdn.microsoft.com/en-us/library/dd744765(VS.85).aspx I have been working with the application provider on this issue as well and am working to find the root cause.

When the application "ghosts", try one of the Pervasive tools like Function Executor or Pervasive Control Center.  If you can connect to a data file or database and execute a query while the application is "ghosting," then the problem isn't related to Pervasive. 

When I've seen applications hang, it's usually the application and not the database.  PSQL 10 has been out for quite some time and I haven't heard of any other reports of hangs like you describe. 

You might also check the PVSW.LOG file from a client seeing the hang / ghosting.  Check for any entries around the time of the hang.