PxPlus User Forum

Twitter Twitter Twitter

Author Topic: PXPlus SQL ODBC Client Procedure  (Read 1762 times)

Mike Hatfield

  • Gold Member
  • ****
  • Posts: 70
    • View Profile
PXPlus SQL ODBC Client Procedure
« on: January 14, 2019, 06:58:25 PM »
The operation of the client ODBC is different to the 5.20 version.
EG:
I open Excel - Blank Workbook - Select Data - Select Get Data - Select From other sources - Select From Microsoft Query
The Data source windows displays and I choose my Data Source
The next window to display is "PxPlus SQL ODBC Setup"
You can see from the screenshot it is not fully populated with dictionary and INI file.
Although these were entered and are editable in the ODBC setup utility.
I Click OK
I'm presented with the file tables and I choose a table and columns
After I've chosen all the columns and clicked through to the Excel window I'm presented with the 'PxPlus SQL ODBC Driver Setup' window again.
I click OK and the spreadsheet populates.

My question is: Why the seemingly superfluous ODBC setup windows?
Mike H

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: PXPlus SQL ODBC Client Procedure
« Reply #1 on: January 15, 2019, 08:51:33 AM »
Hi Mike,

This is caused by a bug that we have already fixed but has not yet been released. We plan to do a release soon with this fix as well as a few other fixes.

If you need the fix now you can e-mail me and I can send you a updated DLL with the fix.
Principal Software Engineer for PVX Plus Technologies LTD.