A couple a days again I noticed the Views were not working anymore. As far as I know, there are no changes made.
The internal Views show the data, and using the ODBC server to retreive data directly from files works, but concerning the Views, only the tables show up, but no fields or data.
Using the pxpsql.exe, it returns 'S0000:1:101:[PxPlus][SQL ODBC Driver][PXPIO]Unable to locate and open the requested data file', which would suggest the prefix in de Catalog section of is wrong, but it isn't.
Also tried the full path in the Views definition, but no luck.
The ViewLib= is also correct.
PVX ODBC server and client are version 7.00.0003, PxPlus server and client are version 18.20, server is RedHat 7.
What am I missing?
Regards,
Danny