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 - michaelgreer

Pages: 1 [2] 3 4 ... 9
16
ODBC / Re: ODBC on Redhat
« on: June 09, 2023, 03:17:59 PM »
You are correct sir.  Long week I guess. Thanks.

17
ODBC / Re: ODBC on Redhat
« on: June 09, 2023, 03:04:43 PM »
Devon,  That was just me being sloppy.  /facts93 is a symbolic link to /facts/facts93. In order to eliminate that as the issue I changed everything to be /facts/facts93 in odbc.ini. If I issue the command with -d /facts/facts93 you see the success on the first and a fail on the second.

18
ODBC / ODBC on Redhat
« on: June 09, 2023, 01:19:07 PM »
This is configured for 64 bit on RH 7.9. unixODBC is installed.  If I do this:
[root@rhlinux etc]# /usr/pxpsqlodbc/pxpsql -d /facts93 LIST |grep AR_CUST
AR_CUST_BY_ALPHA
AR_CUST_BY_CLASS
AR_CUST_BY_CNTCT
AR_CUST_BY_DOC
AR_CUST_BY_PHONE
AR_CUST_BY_SLSP
AR_CUST_BY_ZIP
AR_CUST_CLASSES
AR_CUST_CLASSES_AKT
AR_CUST_CROSS_REF
AR_CUST_LDGCARDS
AR_CUST_MAST
AR_CUST_PRC_CLS
AR_CUSTOMER_HISTORY
AR_CUSTOMER_NOTES_A
AR_CUSTOMER_NOTES_B
AR_CUSTOMER_NOTES_C

You can see AR_CUST_MAST as a table. Good.  Now this:
[root@rhlinux etc]# /usr/pxpsqlodbc/pxpsql -d /facts/facts93 LIST table AR_CUST_MAST

ERROR: Invalid Table Name or No Columns Returned By LIST Columns Command.

Since (think) I know the table name is good, what would cause the column list to fail.  Providex.ddf shows the file, and the file has an embedded IO list (as well as an IO program, see attached.

Any insight appreciated. - Michael

19
Programming / Re: Preview / Viewer Object
« on: April 06, 2023, 04:53:40 PM »
Jeff,

Create a link file using /dev/null on *nix or nul on windows.  Use the driver viewer provided with PxPlus.

Michael

20
Programming / Strange if then else behavior
« on: March 08, 2023, 09:00:05 AM »
This is an abstraction of a code issue we are seeing:
0005 let mike$="P"
0010 if mike$="P" then {
0015 print "Yes P"
0020  } else if mike$="T" then {
0025 print "Doing T too"
0030  }
If you execute this, you get both outputs when it seems you should not get the "Doing T too".  I realize this is not great coding (I didn't write it) but it seems it should work.

21
Language / TCP/IP address
« on: January 16, 2023, 05:06:04 PM »
Is there anything in the PxPlus environment that stores/returns the IP address of a telnet or raw tcp connection on a *nix box.  I can get the value from the telnet login but it is ugly.  Same thing with the mac address (parse arp -a).

22
Programming / Invoking an Android command
« on: December 29, 2022, 12:40:34 PM »
I have a customer running a character app on android over a telnet session.   They now would like to be able to launch a browser to a specific URL.  Has anyone found a telnet client or used some other connection method (javx?) to run a character app, but which would also support the url launch capability?

23
Thin Client/WindX / Automated Windx install
« on: November 11, 2022, 11:43:03 AM »
Is it possible to build an automated install for Windx that has an icon preconfigured with the targe, start in, etc. as well as a predefined install location?

24
Language / Re: Error 15 in *plus/web/request
« on: September 29, 2022, 11:49:11 AM »
Devon,

I went ahead and installed version 18 (dev suite 2021) in demo mode. Full communication with no issues.  I will work with the customer to upgrade or add on a new license. Must be something deep down in the implementation at 12.5 that is still causing an issue. - Michael

25
Language / Re: Error 15 in *plus/web/request
« on: September 27, 2022, 03:09:05 PM »
Thanks Devon.  I too can successfully make the call you used.  I get a lengthy response but it does indicate "tls-v1-2".

On my call I get:

[TCP][Sockets]Error[2]:No such file or directory (5:<Unk>)

I am able to make a successful call from my PC running windows 10 and using PxPlus v 19.00

26
Language / Error 15 in *plus/web/request
« on: September 27, 2022, 12:23:36 PM »
I have a customer running pxplus 12.50 on linux.  Linux is set to support TLS 1.2.  On a call to request I get the open to the web site for the API I am trying to access, but when PxPlus tries to write the body (r$) I am getting an error 15.  Ideas?  Thanks!

27
Language / Simple Client/Server lock up
« on: September 26, 2022, 12:49:12 PM »
PxPlus 15.1 running under windows.  Every so often (1 to 2 weeks) the cshost program refuses to spawn new sessions.  This means that no new users can connect to the app, an when our menu attempts to launch a function in a newly spawned session, that also fails.  Restarting the service (which in this particular instance is running under srvany) cures the issue.  Any insight here would be appreciated.

28
Nomads / Data dictionary maintenance error
« on: August 15, 2022, 01:04:00 PM »
In the process of maintaining a dictionary we attempt to add a new element.  When we click Ok we get an "Error Occurred processing: "PERFORM *dict\Element;OKY_BTN".  The program is there and the label is too.  Ideas on what would cause this.  It is PVX 11.5 running under linux.  If I exit Nomads I can "call" that routine with no issue.

29
Programming / Re: Error 13 on [tcp] connection with secure
« on: August 03, 2022, 03:08:38 PM »
Mike and Devon,

Thanks for your assistance and patience.  I am running windows where the issues are occurring. I did install the latest version of PxPlus and it had no issues.  I also do not find SSL installed on my machine.

Connected to the customer who is redhat, running pvx 12.50.  *No* issues, so this is done I guess.

Never mind on this --->  Seeing invalid key so staring in demo mode. One question. I have a PVXKEY set for all of my PxPlus instances.  When I launch the 2022 pxplus I expected to have an issue with that but it came up in Demo mode. How is it "ignoring" my PVXKEY env. variable?

30
Programming / Re: Error 13 on [tcp] connection with secure
« on: August 02, 2022, 04:21:46 PM »
I currently have access to systems up through 1510.  I always get:

Unable to connect securely (err/ret=0/0)

I tried adding ";TLS1.2" after secure, but same thing (this was at 1510).


Pages: 1 [2] 3 4 ... 9