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.
46
Thin Client/WindX / Windx Security on Terminal Server
« on: June 17, 2019, 02:09:31 PM »
A client has used the pxp1510-0001-WPI.exe program to install and configure windx on a terminal server running windows 2016. It would seem that each user is confronted with the initial "Security" question. Is there a way to provide a system wide answer to this and avoid it popping up for each windows user. It is only a matter of time (very little time) before someone answers this incorrectly.
47
ODBC / sql server install alongside 5.
« on: May 21, 2019, 10:31:35 AM »
We are attempting to deloy sql server 6 alongside odbc server 5.20 on linux. The new install wants to re-deploy libpxpio.so. Will the new library work with the old server? If not, is there a way to have the 2 versions co-exists while we test?
Michael
Michael
48
ODBC / [PxPlus][ODBC Driver][PXPIO]File is busy
« on: May 08, 2019, 11:30:48 AM »
I have an SQL query that runs for 4.5 hours or so, then posts the error referenced in the subject. Any insight on what would cause this. This occurs at about 1:30 AM almost every day. I have looked for other processes that might be locking a source file but am not currently aware of any.
49
Programming / [tcp] open issue
« on: April 01, 2019, 01:24:10 PM »
Application is running on Redhat 7.6. PXPlus version being accessed 13.10. This fails:
open(hfn)"[tcp]someurl;someport;secure"
fails, but this does not:
open(hfn)"[wdx][tcp]someurl;someport;secure"
Both machines are on the same LAN. Is there some configuration on the linux box of which I am unaware which would block the first open. I have never had such an issue and use this technique extensively to access web API's.
Thanks!
Michael
open(hfn)"[tcp]someurl;someport;secure"
fails, but this does not:
open(hfn)"[wdx][tcp]someurl;someport;secure"
Both machines are on the same LAN. Is there some configuration on the linux box of which I am unaware which would block the first open. I have never had such an issue and use this technique extensively to access web API's.
Thanks!
Michael
50
ODBC / odbc 5.1 vs 5.2
« on: February 18, 2019, 05:41:40 PM »
I have the following construct in a development environment running 5.2 odbc:
, {fn REPLACE(
{fn REPLACE(
{fn REPLACE(
{fn REPLACE(
{fn REPLACE(GEBH.gl_type,'A','Asset')}
,'R','Revenue')}
,'E','Expense')}
,'L','Liability')}
,'C','Capital')}
as 'Acct Type Desc'
When I port this to a customer running ODBC 5.1 I get an "invalid argument in a scalar function - REPLACE" message. I don't see a note in the docs about this. Is this a known limit of 5.1? a bug? something else?
Thanks!
, {fn REPLACE(
{fn REPLACE(
{fn REPLACE(
{fn REPLACE(
{fn REPLACE(GEBH.gl_type,'A','Asset')}
,'R','Revenue')}
,'E','Expense')}
,'L','Liability')}
,'C','Capital')}
as 'Acct Type Desc'
When I port this to a customer running ODBC 5.1 I get an "invalid argument in a scalar function - REPLACE" message. I don't see a note in the docs about this. Is this a known limit of 5.1? a bug? something else?
Thanks!
52
Programming / excel object create error 12
« on: November 16, 2018, 02:56:49 PM »
I have a customer who has several users running the same version of excel, and of course pvx/windx on different PC's. One user gets and error 12 on this command:
3215 def object xl,"[running]excel.application"
"[running]ecel.application" is actually in a variable, but the above shows the command. Does anyone know of an excel setting which would cause this?
Thanks!
Michael
3215 def object xl,"[running]excel.application"
"[running]ecel.application" is actually in a variable, but the above shows the command. Does anyone know of an excel setting which would cause this?
Thanks!
Michael
53
ODBC / MySQL write via ODBC
« on: October 17, 2018, 04:10:00 PM »
I have a standard interface to various MySQL databases that have the same table format. In one instance I am getting duplicate rows when I write the same record rather than overwriting. The MySQL database is not under my control. It is my understanding the PxPlus handled the determination of whether to do an update or an insert. I am opening the table with a unique key specified. The insert/duplication occurs whether I write with a key or not. Is there some open option that I did not notice that will help with this behavior?
54
Registration and Setup / Windx Security
« on: August 20, 2018, 04:05:01 PM »
I had a customer enable windx security on their own initiative. I have attempted to reset Windx Security, both by clicking on the PxPlus globe and then clicking reset, which does nothing, as well as trying the shift+ctrl+insert, which did nothing. I even did a remove/re-install to no avail. What am I missing?
55
Nomads / Data Read logic in nomads DD or View definition
« on: July 09, 2018, 12:44:29 PM »
I don't really use nomads, but use the Data dictionary and views definitions to create ODBC links to PVX data. Is there a way to create a column in a table or view that includes logic to set the value of the field based on other fields in the record, or data from another table. Thanks! Michael