I'm trying to create an ODBC connection string that can be used by a third party product to access a couple PxPlus data files.
I have the ODBC server and client setup.
I have been able to successfully extract data from the PXPlus files using Excel with this connection string:
DRIVER={PxPlus® ODBC Driver (32-bit)};Directory=/my_dir/sub_dir/;RemotePVKIOHost=192.168.xxx.xxx
*Note - when using Excel, credentials are tendered in a separate screen, but in the other software, I'm adding ";uid=user" to the connection string (no password).
I also successfully got data using Excel by simply specifying a DSN in the connection string:
DSN=Shipping
However, when using either of the connection strings above in the third party software, it failed.
I have tried variations of the above connection strings with additional keywords, but got similar results... They succeed in Excel, but fail in the other software. They assure me they are simply taking the connection string I provide without any manipulation.
Any ideas why it works with Excel, but not the other software? Is Excel manipulating the connection string I provide?
Server:
RedHat 7.5
PxPlus 11.65
ODBC 5.20
Client
ODBC 5.20