PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: Mike Hatfield on January 14, 2019, 06:58:25 PM

Title: PXPlus SQL ODBC Client Procedure
Post by: Mike Hatfield 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?
Title: Re: PXPlus SQL ODBC Client Procedure
Post by: Devon Austen 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.