Skip to content

Pervasive PSQL

← Knowledge Base

  1. Btrieve Error Codes 001 - 199

  2. Btrieve Error Codes 3000 - 3099

  3. Btrieve Error Codes 3100 - 3199

  4. PSQL Version Required by Each Elliott Version

  5. Do I Need to Change PSQL Server Engine Default Parameters After Installing It?

  6. New Elliott PSQL Server Processor and RAM Suggestions

  7. Can I Dynamically Adjust Elliott / PSQL 11 Server Memory?

  8. Received "Your Computer Does Not Have PSQL 10 or 11 Client " Even though PSQL Client Is Just Installed

  9. Btrieve Error 161 on Password File When Starting Up Elliott

  10. Problems with Using Pervasive Rebuild Utility on APOPNFIL and AROPNFIL Tables

  11. Security Issue with Installing PSQL Client Remotely on User's Workstation

  12. PSQL and Distributed File System (DFS)

  13. How Do I Turn on PSQL Relational Engine Security?

  14. An Example of Debugging NOTE_ORD_VIEW PSQL Expression Evaluation Error

  15. Btrieve Error 025 on COP Open Order by Salesman Report

  16. What Is the *.^01 File for My PSQL Btrieve Table?

  17. Suggested Files to be Monitored by Audit Master

  18. Pervasive Backup Agent Is Not Compatible with Creating Work Files

  19. Hardware Recommendations for Your PSQL Database Server

  20. How to Optimize SQL SELECT Statement When Retrieving Data from Invoice History

  21. New User-Defined Functions in Elliott DDF

  22. How to Improve Query Performance When Retrieving Data from Notes & Invoice History

  23. How to Retrieve Tracking Number for an Order from Notes

  24. Actian PSQL Not Started Automatically After Server Reboot

  25. Create a New Database in the PCC for Relational Engine Access

  26. Slow PSQL Relational Engine Performance

  27. IPV6 May Cause Problem for PSQL 11 Relational Query

  28. DDF Files in DATA Folder May Confuse PSQL

  29. What to Do When PSQL 11 License Is Disabled

  30. Quick Installation Guide for Audit Master

  31. Quick User Guide for Audit Master

  32. PSQL 13, Micrsoft SQL Integration Service & Pervasive PSQL OLE DB Provider

  33. Your Firewall Needs to Allow Outbound Traffic to the Netherlands for PSQL Licensing Server Purposes

  34. A Case of Btrieve Error 046 on ARCRCLOG A/R Credit Card Log File

  35. A Support Case of Migrating to Different Version of DDF

  36. How to Clear the Message "Unable to Read your Users record (9/068)"

  37. Setup of the PSQL 13 Report Engine

  38. How to Create CPHSTTRX_VIEW with Left Join to CPINVHDR Due to Invoice Database Archive

  39. How to Access Elliott's Data by Using Query in Microsoft Office Excel 2019

  40. Elliott Database Naming Convention

  41. What Does Btrieve Error 080 Mean?

  42. How to Enable PSQL Relational ODBC Security

  43. Converting Elliott Physical Server to a Virtual Machine (VM)

  44. Use Telnet to Diagnose PSQL Communication & Port Disabling Problem

  45. How to Fix and Protect Audit Master Data from Corruption

  46. Configure PSQL Server Memory Usage

  47. How to Download PSQL 15

  48. Restart PSQL Engine to Fix Slow IO Performance Issue

  49. How to Retrieve Open Orders That Are Not Invoiced Through Query

  50. After Server Reboot, Elliott Stopped Working Due to PSQL Engines Not Starting

  51. Elliott 8.6 to Distribute 4.4 PSQL Entity Framework Client

  52. How Elliott 8.6 Works with Different Versions of the PSQL ADO.NET Client

  53. Cannot Create DDFs Due to Metadata Version Mismatch

  54. How Do You Rebuild a Corrupt Elliott File?

  55. A Case to Optimize PSQL Query Performance with INNER JOIN SYCONTCT & SYCONREL Tables

  56. How Can I Tell How Many Users Are Using PSQL?

  57. An Example of DDF Files in DATA Folder that Can Confuse PSQL

  58. Why Does Elliott User's PSQL Connection Stay Open Even If User Is Out of Elliott?

  59. Convert Elliott Internal Date to Proper Date Format in Third-Party Tools (Crystal Reports)

Feedback and Knowledge Base

(thinking…)