PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Automatic update  (Read 1310 times)

abarzov

  • New Member
  • *
  • Posts: 2
    • View Profile
Automatic update
« on: November 23, 2021, 10:09:34 AM »
I'm a newbie in PxPlus.
The company where I'm currently working uses a very old version of PxPlus - 6.30.
All the vital information is saved in it.
The PxPlus is licensed;  all the licensing information is available. The original installation is missing.
PxPlus is running on a Windows 2003 server.
Standalone version of WindX is installed. There is an original installation file.
The company needs to migrate to a modern platform.
However, there is no way to re-install the PxPlus.
Here are the questions I desperately need an answer for:
Is there any way to extract data from all tables in PxPlus via an ODBC driver?
If yes, how to configure such a driver?
Is there any way to write some SQL query and retrieve some info from PxPlus?
Please help.
Thanks.

Mike King

  • Diamond Member
  • *****
  • Posts: 3817
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Automatic update
« Reply #1 on: November 23, 2021, 10:46:09 AM »
You should probably first contact the company that supplied your PxPlus.  Generally PxPlus (or its predecessor ProvideX) came as part of a business application.  Your application supplier should be able to advise you on the latest version of PxPlus they are using and how to obtain it.

Version 6.30 is a very old release and no longer supported however you may be able to find a copy of it at https://archives.pvxplus.com/

As for accessing the data there is an ODBC driver available that should allow you to access the files along with a command line processor PXPSQL that allows you to execute SQL commands against the file structure and get the data out.

One thing should be noted though, the ODBC driver and PXPSQL utilities rely on the system having and using a Data Dictionary (Schema definition) .  Some older applications neither use nor come with the data dictionary so this may not be a option for you.  In this case your original application provider may have to assist you or you may be able to find others on this forum that can.

Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com

abarzov

  • New Member
  • *
  • Posts: 2
    • View Profile
Re: Automatic update
« Reply #2 on: November 25, 2021, 11:17:12 AM »
Thank you !

robertmartin

  • On Probation
  • New Member
  • *
  • Posts: 1
    • View Profile
Re: Automatic update
« Reply #3 on: December 24, 2021, 08:37:17 AM »
Thank you! :)
« Last Edit: December 25, 2021, 12:30:35 PM by robertmartin »