PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Danny_S

Pages: [1]
ODBC / Re: ODBC and Logic Procedures
« on: August 10, 2022, 09:33:55 AM »
OK, Never mind, on a hunch I reinstalled the local driver, and now I can see code getting executed...

ODBC / ODBC and Logic Procedures
« on: August 10, 2022, 07:25:08 AM »
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.


ODBC / Re: ODBC and views not working
« on: August 03, 2022, 09:28:41 AM »

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. :)

ODBC / ODBC and views not working
« on: August 02, 2022, 08:37:18 AM »
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 :


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

Pages: [1]