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.
Pages: [1]
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...
2
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.
Regards,
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,
3
ODBC / Re: ODBC and views not working
« on: August 03, 2022, 09:28:41 AM »
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.
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.
4
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 :
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
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
Pages: [1]