Hi all,
I'm having trouble getting data from Views using the ODBC driver.
I'm using the client/server ODBC, version 7, where the server is RedHat 6, 64-bit, and the client ODBC version 7, and Windows 10.
(also tried version 6.1). Pvx version is 14.10, but also tried 18.20
Using the ODBC to get data direct from data-files works, but by using the Views, there comes a message that there are no visible coloms.
Pxp is in /opt/pxp, and the ODBC is installed in /pvxapps/odbc.
The data is in /pvxapps/livedata, and the views-files are in /pvxapps/livedata/views
In de pxpsqlsvr.conf I have defined 2 catalogs :
Ref_Prod_Data=[/pvxapps/liveprog][][/pvxapps/livedata,/pvxapps/livehist,/pvxapps/livemenu,/pvxapps/syspvx]
and
Ref_Prod_Views=*[/pvxapps/livedata/views][][/pvxapps/livedata,/pvxapps/livehist,/pvxapps/livemenu,/pvxapps/syspvx]
and the View Library Path is set to 'ViewLib=/opt/pxp'.
The example view I created has a data-source with a physical file, actcodf0, which is in /pvxapps/livedata. I tried it with just the filename, and the full path in de datasource, but no luck. Also no embedded io with the datafile.
The Ref_Prod_Data returns data, and the Ref_Prod_Views returns the View-names, but no data.
I have tried mixed combination of 32-bits and 64-bits, but all results are the same
The libpxpio.so is copied to /usr/lib64
I got a feeling I'm missing something...anybody any idea?
Thanks, Danny