Megalextoria
Retro computing and gaming, sci-fi books, tv and movies and other geeky stuff.

Home » Digital Archaeology » Computer Arcana » Computer Folklore » EHLLAPI
Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend 
Switch to threaded view of this topic Create a new topic Submit Reply
EHLLAPI [message #411927] Wed, 20 October 2021 20:25 Go to next message
Anonymous
Karma:
Originally posted by: J. Clarke

Some years back I put together a nice macro in Excel that greatly
simplified one of our tests. It used EHLLAPI to poke a bunch of test
cases into a 3270 screen (the test was specifically verifying that the
code behind that screen was pointing at the right data sources--using
JCL would have defeated the purpose), grab the output, pull it down to
a PC, pok it into Excel, and compare the results with what they were
supposed to be. Turned an all-day pain in the butt job into about 20
keystrokes most of which were login and password, watch the screen
flash, and look at the nice pretty workbook that already has any
issues highlighted.

Well, the Powers That Be decided that we shall have 64-Bit Excel, and
Attachmate/Micro Focus/NetManage/whoever the H owns Rumba this week
doesn't have an EHLLAPI that works with 64 bit Excel. Before I
rewrite the whole damned thing in Python with an open source 3270
emulator, does anybody have an idea where I might find an EHLLAPI that
works with 64-bit Excel?

Thanks all.
Re: EHLLAPI [message #411928 is a reply to message #411927] Wed, 20 October 2021 23:07 Go to previous messageGo to next message
Quadibloc is currently offline  Quadibloc
Messages: 4290
Registered: June 2012
Karma: 0
Senior Member
On Wednesday, October 20, 2021 at 6:25:32 PM UTC-6, J. Clarke wrote:
> Before I
> rewrite the whole damned thing in Python with an open source 3270
> emulator, does anybody have an idea where I might find an EHLLAPI that
> works with 64-bit Excel?

Out of curiosity, I did a Google search and found this page by IBM about
that product...

https://www.ibm.com/docs/en/personal-communications/6.0?topi c=programming-introduction-standard-ehllapi-enhanced-ehllapi -winhllapi

It notes that IBM provides three versions of EHLLAPI:

Standard EHLLAPI (16- and 32-bit)
WinHLLAPI (16- and 32-bit)
IBM Enhanced 32-bit HLLAPI (ELLHAPI32)

Since 64-bit versions of Windows have no problem running pure 32-bit software written for
Windows 95, it's only 16-bit software for Windows 3.1 that they can't run, in my ignorance
this suggests that IBM's Enhanced 32-bit HLLAPI might *possibly* work, but as I certainly
can't guarantee that, you'll need to ask around. But at least there's a *hope* something
exists that might work.

However, reading further through that page, the other two versions of EHLLAPI have
separate 16-bit and 32-bit interfaces, and so if the 32-bit interfaces of either of them
don't work, there is likely to be a problem.

Searching a bit more, I found this Microsoft page

https://docs.microsoft.com/en-us/office/vba/language/concept s/getting-started/64-bit-visual-basic-for-applications-overv iew

which claims VBA allows 64-bit Microsoft Word, Excel, and so on to call 32-bit
APIs. But I have to assume this is all stuff you've already tried, and it hasn't
worked.

John Savard
Re: EHLLAPI [message #411929 is a reply to message #411928] Wed, 20 October 2021 23:20 Go to previous messageGo to next message
Quadibloc is currently offline  Quadibloc
Messages: 4290
Registered: June 2012
Karma: 0
Senior Member
The short form is this:

- no, there isn't a 64-bit EHLLAPI floating around
- but the 32-bit one you have should work just fine IF:
you have the source code to the macros that your application uses to call the
32-bit EHLLAPI, and you can modify it and stick the resulting macro back in.

Just add declarations that say that the calls use 32-bit data types instead of the default
data type which is 64 bits, and you're off and running.

Not that I really believe that it will actually be that simple.

John Savard
Re: EHLLAPI [message #411930 is a reply to message #411929] Wed, 20 October 2021 23:30 Go to previous messageGo to next message
Quadibloc is currently offline  Quadibloc
Messages: 4290
Registered: June 2012
Karma: 0
Senior Member
Further web searching has turned up others that have asked the same
question as you:

https://code400.com/forum/forum/tips-techniques-tools-announ cements/iseries-tools/153833-ehllapi-in-excel-64-bit
https://www.tetcommunity.com/blogs/personal-communications-s ession-api-pcsapi-in-ibm-personal-communications

and apparently the answer is: no, it can't be made to work in the
ways I was hoping. However, I also found this:

https://dn-computing.com/history.htm

The company DN-Computing already makes a 3270 emulator with
64-bit EHLLAPI. So apparently there may be a solution available to
purchase off the shelf.

John Savard
Re: EHLLAPI [message #411931 is a reply to message #411928] Wed, 20 October 2021 23:55 Go to previous messageGo to next message
Anonymous
Karma:
Originally posted by: J. Clarke

On Wed, 20 Oct 2021 20:07:51 -0700 (PDT), Quadibloc
<jsavard@ecn.ab.ca> wrote:

> On Wednesday, October 20, 2021 at 6:25:32 PM UTC-6, J. Clarke wrote:
>> Before I
>> rewrite the whole damned thing in Python with an open source 3270
>> emulator, does anybody have an idea where I might find an EHLLAPI that
>> works with 64-bit Excel?
>
> Out of curiosity, I did a Google search and found this page by IBM about
> that product...
>
> https://www.ibm.com/docs/en/personal-communications/6.0?topi c=programming-introduction-standard-ehllapi-enhanced-ehllapi -winhllapi
>
> It notes that IBM provides three versions of EHLLAPI:
>
> Standard EHLLAPI (16- and 32-bit)
> WinHLLAPI (16- and 32-bit)
> IBM Enhanced 32-bit HLLAPI (ELLHAPI32)
>
> Since 64-bit versions of Windows have no problem running pure 32-bit software written for
> Windows 95, it's only 16-bit software for Windows 3.1 that they can't run, in my ignorance
> this suggests that IBM's Enhanced 32-bit HLLAPI might *possibly* work, but as I certainly
> can't guarantee that, you'll need to ask around. But at least there's a *hope* something
> exists that might work.
>
> However, reading further through that page, the other two versions of EHLLAPI have
> separate 16-bit and 32-bit interfaces, and so if the 32-bit interfaces of either of them
> don't work, there is likely to be a problem.
>
> Searching a bit more, I found this Microsoft page
>
> https://docs.microsoft.com/en-us/office/vba/language/concept s/getting-started/64-bit-visual-basic-for-applications-overv iew
>
> which claims VBA allows 64-bit Microsoft Word, Excel, and so on to call 32-bit
> APIs. But I have to assume this is all stuff you've already tried, and it hasn't
> worked.

Yep. None of it works.
Re: EHLLAPI [message #411932 is a reply to message #411930] Thu, 21 October 2021 00:03 Go to previous messageGo to next message
Anonymous
Karma:
Originally posted by: J. Clarke

On Wed, 20 Oct 2021 20:30:56 -0700 (PDT), Quadibloc
<jsavard@ecn.ab.ca> wrote:

> Further web searching has turned up others that have asked the same
> question as you:
>
> https://code400.com/forum/forum/tips-techniques-tools-announ cements/iseries-tools/153833-ehllapi-in-excel-64-bit
> https://www.tetcommunity.com/blogs/personal-communications-s ession-api-pcsapi-in-ibm-personal-communications
>
> and apparently the answer is: no, it can't be made to work in the
> ways I was hoping. However, I also found this:
>
> https://dn-computing.com/history.htm
>
> The company DN-Computing already makes a 3270 emulator with
> 64-bit EHLLAPI. So apparently there may be a solution available to
> purchase off the shelf.

Thank you very much. Your Google-fu is strong.

And that's cheap enough for a single user that I can buy my own copy
and convince myself that it works with Hercules before I go to the
boss.
Re: EHLLAPI [message #411943 is a reply to message #411930] Thu, 21 October 2021 20:00 Go to previous messageGo to next message
Peter Flass is currently offline  Peter Flass
Messages: 7976
Registered: December 2011
Karma: 0
Senior Member
Quadibloc <jsavard@ecn.ab.ca> wrote:
> Further web searching has turned up others that have asked the same
> question as you:
>
> https://code400.com/forum/forum/tips-techniques-tools-announ cements/iseries-tools/153833-ehllapi-in-excel-64-bit
> https://www.tetcommunity.com/blogs/personal-communications-s ession-api-pcsapi-in-ibm-personal-communications
>
> and apparently the answer is: no, it can't be made to work in the
> ways I was hoping. However, I also found this:
>
> https://dn-computing.com/history.htm
>
> The company DN-Computing already makes a 3270 emulator with
> 64-bit EHLLAPI. So apparently there may be a solution available to
> purchase off the shelf.
>
> John Savard
>

I read that PCOMM supports 64-bit HLLAPI.

--
Pete
Re: EHLLAPI [message #411944 is a reply to message #411943] Thu, 21 October 2021 20:37 Go to previous message
Anonymous
Karma:
Originally posted by: J. Clarke

On Thu, 21 Oct 2021 17:00:40 -0700, Peter Flass
<peter_flass@yahoo.com> wrote:

> Quadibloc <jsavard@ecn.ab.ca> wrote:
>> Further web searching has turned up others that have asked the same
>> question as you:
>>
>> https://code400.com/forum/forum/tips-techniques-tools-announ cements/iseries-tools/153833-ehllapi-in-excel-64-bit
>> https://www.tetcommunity.com/blogs/personal-communications-s ession-api-pcsapi-in-ibm-personal-communications
>>
>> and apparently the answer is: no, it can't be made to work in the
>> ways I was hoping. However, I also found this:
>>
>> https://dn-computing.com/history.htm
>>
>> The company DN-Computing already makes a 3270 emulator with
>> 64-bit EHLLAPI. So apparently there may be a solution available to
>> purchase off the shelf.
>>
>> John Savard
>>
>
> I read that PCOMM supports 64-bit HLLAPI.

I am surprised that we don't already have that available. Of course
IBM does the usual IBM trick of making you call and talk to a
marketroid before they'll deign to tell you you can't afford it.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Michael Tomcyzk interviewed
Next Topic: Re: Nice to be back on Usenet
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Dec 08 17:55:30 EST 2021

Total time taken to generate the page: 0.00819 seconds