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 - Mike Hatfield

Pages: 1 2 3 [4] 5
46
Wish List / PxPlus - WindX on IOS or Android
« on: January 23, 2019, 06:24:23 PM »
Is there a roadmap for including Simple Client or WindX, on an IOS or Android device?
We are regularly asked this question!
We have offered iNomads but the expense and difficulty of implementation is always the killer.
Thanks

47
ODBC / PXPlus SQL ODBC Client Procedure
« on: January 14, 2019, 06:58:25 PM »
The operation of the client ODBC is different to the 5.20 version.
EG:
I open Excel - Blank Workbook - Select Data - Select Get Data - Select From other sources - Select From Microsoft Query
The Data source windows displays and I choose my Data Source
The next window to display is "PxPlus SQL ODBC Setup"
You can see from the screenshot it is not fully populated with dictionary and INI file.
Although these were entered and are editable in the ODBC setup utility.
I Click OK
I'm presented with the file tables and I choose a table and columns
After I've chosen all the columns and clicked through to the Excel window I'm presented with the 'PxPlus SQL ODBC Driver Setup' window again.
I click OK and the spreadsheet populates.

My question is: Why the seemingly superfluous ODBC setup windows?

48
ODBC / PxPlus SQL Server 6.10
« on: January 14, 2019, 01:20:49 AM »
I've downloaded and installed the current 6.10 release (August 2018) on our Server 2016  and WindX.
The ODBC driver setup window shows PRE-RELEASE on the bottom left.

49
Programming / Re: FTPS instead of FTP or SFTP
« on: December 28, 2018, 07:45:35 PM »
Well maybe HTTPS is the way to go.
We do upload and download though.
SFTP should work but it is an onerous process to set up and then you have to distribute the keys to each client end user.

50
Programming / Re: FTPS instead of FTP or SFTP
« on: December 28, 2018, 04:49:36 PM »
In the first example curl works with ftp and --ssl and -k. The -k ignores the certificate which whilst it works is not ideal.

You can see from the second example below that curl does not work using ftps.
curl is trying to use port 990 which would normally mean it is attempting 'implicit FTP over TLS' rather than 'explicit FTP over TLS'
Port 990 is open on the firewall.

Filezilla only presents the certificate the first time for a set of credentials (unless you don't accept the certificate).
The certificate is valid btw.

The site expects TLS 1.2 minimum with explicit FTP over TLS.

We use *web/ftp to upload the license files  and the end user is downloading the file.

C:\HIT\PVX>curl --ssl -k -O ftp://ftp.hit.net.au/public_html/Future/Texts/0030020.txt --user xxxxxx:xxxxxxxxxxxxx
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    66  100    66    0     0     86      0 --:--:-- --:--:-- --:--:--    86

C:\HIT\PVX>curl -O ftps://ftp.hit.net.au/public_html/Future/Texts/0030020.txt --user xxxxxx:xxxxxxxxxxxxx
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:--  0:00:20 --:--:--     0curl: (7) Failed to connect to ftp.hit.net.au port 990: Timed out

51
Wish List / *WEB/FTP - TLS
« on: December 28, 2018, 12:44:59 AM »
Add TLS TO *WEB/FTP
We are finding that more hosting services are enforcing TLS for FTP

52
Programming / Re: FTPS instead of FTP or SFTP
« on: December 27, 2018, 08:42:34 PM »
Our hosting provider has just enforced TLS. They say the FTPS still works on port 21.
We have been using *web/ftp in our program for some time, now it fails with error 15.
I have tried *web/ftp using ftps://domain.com.au and it also fails with error 15.
When using FileZilla for the first time to connect via Explicit FTP over TLS you are presented with a screen to accept the certificate.
I imagine *web/ftp would need to deal with this as well.
 
What is the solution to this problem? How do we resolve it?
Our application uses *web/ftp to periodically verify the end user license and download a new license file.
This is going to become a major problem for us if we have to do this manually.

53
ODBC / Re: ODBC 5.20 32bit
« on: December 20, 2018, 02:40:10 AM »
Loading odbca32 from the syswow64 worked.
I've always had success in the past loading from system32.
Something learned today!
Thanks

54
ODBC / Re: ODBC 5.20 32bit
« on: December 19, 2018, 05:22:34 PM »
I did the upgrade to windows 1809.
The odbca32 still does not appear in the start menu.
Running odbca32 does not find the PxPlus odbc driver.


55
ODBC / Re: ODBC 5.20 32bit
« on: December 18, 2018, 04:45:12 PM »
I had already tried 'run as administrator'
I'm going to run the 1809 update and see what happens.
It is more or less a new windows install so at least as good as a repair.

56
ODBC / ODBC 5.20 32bit
« on: December 18, 2018, 12:11:34 AM »
Hi All,

I am trying to install the ODBC 5.20 client on a windows 10 Pro 64 bit computer.
The server is running V14 (suite 2017 Upd1)
The desktops are all Windows Pro 64 bit version 17134
The 5.20 32 bit ODBC File Server is installed on the server.
Four desktops have the 5.20 32 bit ODBC driver installed and they work fine.
The fifth one is giving me a bucket load of grief.
I've tried installing the ODBC 5.20 32 bit as local admin, domain user and domain admin.
It installs OK but does NOT add the ODBC 32 bit setup to the start menu.
If I run the odbca32.exe from the Windows system32 folder and select ADD in either System DSN or User DSN it does NOT show the PxPlus ODBC driver (32bit)

Any suggestions?
Thanks

57
Programming / Re: GET_FILE_BOX WindX vs local desktop
« on: December 15, 2018, 01:16:15 AM »
In previous post I made a mistake the %SCANDATA$ should read "/HIT/SCANDATA/" with the trailing "/"
What I have discovered is that on my local windows desktop I must use backslashes.
I thought PxPlus could interchange  / and \
 
On my local desktop it is working but still displays File Explorer.
I presume this is intended behaviour.
Why is WindX a LIST BOX and local is File Explorer?

58
Programming / GET_FILE_BOX WindX vs local desktop
« on: December 15, 2018, 12:49:03 AM »
Why does GET_FILE_BOX behave differently on a local Windows 10 Pro desktop vs WindX on the same desktop to Server 2016 NTHOST
Server and desktop are running V1410-001

IE on WindX GET_FILE_BOX displays a nomads list box and on the local desktop it displays File Explorer

This program code:
%SCANDATA$="\HIT\SCANDATA"

0010 BEGIN
0020 PRINT 'CS',
0100 LET PDIR$=%SCANDATA$; LET PROOT$=%SCANDATA$
0200 GET_FILE_BOX PDIR$,PROOT$,"Choose Order File","Text Files|order*.TXT,"

On WindX displays a list box in the folder \hit\scandata with only the order*.TXT files
Which is what I want.

On local desktop line 200 drops straight through to next line. Weird!!
If I set PDIR$="" then on local desktop it displays File Explorer in the folder \HIT with ALL files.

What is going on?



59
Programming / Re: GET_FILE_BOX
« on: December 14, 2018, 04:02:29 PM »
Len,

I don't see that option in the online doco for GET_FILE_BOX (only for the DIRECTORY option)
Thanks

60
Programming / GET_FILE_BOX
« on: December 14, 2018, 03:33:12 AM »
I'm selecting a file from a directory:
PDIR$=""
PROOT$="\HIT\SCANDATA\"
GET_FILE_BOX PDIR$,PROOT$,"Choose Order File","Text Files|order*.TXT,"

This is fine except I want to:
a - stop the user going back up the directory tree
b - suppress the 'new folder' button

how do I do this?
Thanks

Pages: 1 2 3 [4] 5