Devon,

Thanks for the response.

I have double checked the ViewLib= setting, and it is correct.

I removed the serial from the config file, and put in serial=, so it is in Demo-mode, and on the client side I get a message saying it is in demo-mode, but still no luck.

The PxPlus in the ViewLib is our 'normal' Pxplus, and is activated and working.

At least now I know it is not the Views or PxPlus...

I will try and find out if something else has changed.

Regards,

Danny

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

OK, Never mind, on a hunch I reinstalled the local driver, and now I can see code getting executed...

Hi List,

I have a view, and try to add Logic Procedures to it. If using the Views, I can see it gets executed, but when I access the View using the Client ODBC Driver I can't see anything happening. Also tried an Object, with the Onload, OnExecute, OnClose, SetInitLogic, SetExecutionlogic and SetCloselogic.

I tried the logic on all levels, and in the logic I just tried to create a file (serial), tried using a Linux path (the ODB server runs on a Linux server), a local Windows path, and a windx [wdx] Windows local path.

My final goal is, based on the prefix (set by the Catalog) to show data in a View, or not, if the user is not allowed. There a 2 main databases for 2 companies, each with their own catalog.

I tried everything I could figure out from the manual, but I think I am missing something to get this working.

Regards,

Devon,

Thanks for your suggestions. After checking all versions and re-checking....it still didn't work..

Until it got to me..I installed RedHat 6 Pxplus and ODBC on a RedHat 7 machine..

After fixing that it works like a charm.

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