PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: [1] 2 3 ... 10
ODBC / Re: Error Log ODBC
« Last post by Jeffrey Ferreira on Today at 01:23:27 PM »
Devon, i think i'm pretty sure i'm using the same one
i have 64 bit version
if i go back in there it is still checked....
i will double check everything.
ODBC / Re: Error Log ODBC
« Last post by Devon Austen on Today at 12:30:02 PM »
Hi Jeff,

I use the debug logging all of the time and I have not had this issue. We have not had anyone report this issue before either.

When using Excel are you sure you are using the same DSN you turned debug logging on in?

When clicking enable debug logging do you then save the change by clicking apply or OK?

Do you have both 32-bit and 64-bit versions of the ODBC driver installed or just one?
ODBC / Error Log ODBC
« Last post by Jeffrey Ferreira on Today at 11:36:41 AM »
Hello List,
On the Debug Tab of a 64 bit odbc pxplus data source i checked.
Enable Debug
and then specified log file
if i use test connection it outputs to the file but no other tests will write to the file....Excel  or Other applications that we use to access it...
Has anyone had this issue before....
i have used this feature before at another client with some degree of success.

Programming / Re: unique file name
« Last post by Mike King on Today at 09:37:46 AM »
The loop, and subsequent OPEN (which I'm assuming you have) may not work properly if you have a prefix set. 

For example if you have a prefix of "dir1/ dir2/" and USER1 doesn't have create/write permissions on dir1 but USER2 does.  The SERIAL directive for User1 will make the file in dir2 (since it cannot add to dir1) yet USER2 will make it in dir1.  A subsequent OPEN directive could then result in both opening the dir1 file.  Similar situations can happen if the users have different prefix values or current directories causing the creation of the file in one directory yet the OPEN finding the file created by another process.

As a rule of thumb we always recommend that you include the PID ('STR(TCB(89))') in any temporary file name.  This avoids any potential problems with permissions or path search rules.

Programming / unique file name
« Last post by Thomas Bock on Today at 05:52:45 AM »
Is this loop save to generate a unique file name in a multi user environment?
A customer reports issues which can only occur if that loop creates the same file for 2 processes.

Code: [Select]
mask$      = "0000000"
extension$ = ".txt"
filePart1$ = path$ + "spoolfile"
counter    = 0
checkFile$ = filePart1$ + str(++counter : mask$) + extension$
serial checkFile$, err = *continue
until 0
Programming / Re: Odd error 13 question
« Last post by Bob Sosbee on March 15, 2019, 02:19:43 PM »
Yeah, it took some hunting to find where it was open as object.  Thanks!
Programming / Re: https
« Last post by Devon Austen on March 15, 2019, 08:38:33 AM »

If this is for a website you probably need a trusted SSL certificate from a Certificate Authority (CA) in order from web browsers to trust your web site and not warn users and prevent them from accessing it. To get a trusted SSL certificate from a CA you need to purchase one and the CA then will verify you are who you claim and that you control the website. They will then issue you a certificate.

Here is some links to a couple:



https://letsencrypt.org/ (free but certificates must be renewed every 90 days)

There are many more options as well.

If this website it for internal use only and you control the machines that can connect to it you can used a self signed certificate and add that certificate to the trust store of the machines that will access it yourself. If you are using PxPLus 2017 are newer PxPlus provides a tool for generating a self signed certificate (https://manual.pvxplus.com/PXPLUS/utilities/SSL%20Cert%20Generator.htm).
Programming / https
« Last post by Danilo David on March 14, 2019, 08:54:56 PM »

i want to make our website to be https and in the pxplus webserver to secure https i need a certificate (ssl certificate).
how to get or generate certificate to make it https .
Thank you

Web Services / Re: Custom content for http error responses
« Last post by St├ęphane Devouard on March 11, 2019, 05:59:06 AM »
Sorry, I was thinking about %EXIT_TEXT$ but forgot the leading % when posting my response

Well, I guess you're using the Web Services stuff embedded within the newer versions of PxPlus

So far, any and all web services I have written in ProvideX were using V10 or prior versions, so were just CGI programs launched from Apache/IIS which were parsing incoming XML data and writing back XML responses to %PRINT_FN with the appropriate %CONTENT_TYPE$ and %EXIT_CODE set, and no pre-defined HTML was getting in the way if I happened to return anything else than an HTTP 200/201

So either you need to do the same, or I guess the Web Services maintenance interface needs some improvement on the PxPlus side with settings to either prevent it to spit out its predefined HTML pages in case of an HTTP 4xx ou 5xx status, or hooks to define special responses for special HTTP statuses

Programming / Re: Frequent Error 65's
« Last post by Thomas Bock on March 11, 2019, 02:56:53 AM »
We see a similar behavior on customers' sites only. I don't think the reason is a two head system, because our software is developed on multi head (2-3 monitors) systems. As far as I could find out there is an error 29 preceeding but it is not constantly happening. So next time the panel runs fine.
Somehow I got the impression that error is limited to controls near the right window border. But that is just a guess.
Pages: [1] 2 3 ... 10