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.


Topics - Doug Clark

Pages: [1] 2
1
Utilities / DB2 WIN-OS2 ODBC and ReportSmith
« on: August 17, 2019, 12:40:48 am »
Sean and I have been conversing through messenging on the site about DB2/2 and WinOS2 and IBM's WinOS2 CAE.

I wrote an article a number of years ago about databases and ODBC. In that article I said that the DB2 version 5 CAE for WinOS2 did not work very well, and that IBM had instituted a "2 versions back, 1 version forward" policy on CAEs and server versions. This meant that the DB2 version 2 WinOS2 CAE and ODBC driver, which works well in WinOS2, would not work connect with DB2 version 7. All of that, to the best of my knowledge, is still true.

I have discovered since then however what appears to be a work around for getting the version 5 DB2 CAE and ODBC driver for WinOS2 to work - which means you can connect from WinOS2 to DB2 version 7 - which is the last version of server released for OS/2.

The work around that appears to work is to install the DB2 version 5 CAE for Windows 3.1, connect to your database using the IBM WinOS2 Command Line Processor in a WinOS2 session, and leave the command line processor running and connected, before attempting to connection with any other application.

(This is an obvious issue when attempting to connect Windows 3.1 applications to DB2 in a seamless session. I think I have a work around for that also but it is not ready yet.)

The second issue Sean had was running ReportSmith in WinOS2 and connecting to DB2.  ReportSmith is, in my opinion, and excellent report writer, very cheap and readily available. It is bundled with Delphi versions 1 and 2 which you can pick up on ebay for $5 - $15. The trick in getting ReportSmith to connect to DB2 is to remove the word DB2 from the description of the driver in ODBC.INI and ODBCINST.INI located in C:\OS2\MDOS\WINOS2. I have attached my ODBC.INI and ODBCINST.INI to show how it is done. The thing to remember however is the IBM DB2 Client Setup won't work unless the DB2 is in the description. So get the client setup, THEN alter ODBC.INI and ODBCINST.INI.

Hope this helps Sean

2
Utilities / Create an ISO from a CD
« on: June 04, 2019, 03:55:22 am »
Is there a utility or program that runs in OS/2 that I could use to create an ISO from the contents of a CD?   I don't see how to do that in DVD tools.

Or must I fall back to a mac for this task?

3
Applications / PostgreSQL database initialization
« on: May 30, 2019, 01:51:16 am »
I have installed PostgreSQL v 9.6.6 - by unzipping into e:\pgsql

I have two issues:

1) initDB apparently doesn't like the OS/2 code page IBM-850
The error message is below

[E:\]initdb -D E:\PGDATA
LOG:  00000: invalid binary "E:/"E:/pgsql/bin/postgres.exe"
LOCATION:  find_my_exec, exec.c:146
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.IBM-850".
could not determine encoding for locale "en_US.IBM-850": codeset is "IBM-850"
initdb: could not find suitable encoding for locale "en_US.IBM-850"
Rerun initdb with the -E option.
Try "initdb --help" for more information.

----------------------------
2) I think the encoding of LATIN1 (ISO-8859-1) is the closest encoding to IBM-850 that PostgreSQL recognize, so I specified -E LATIN1.
But now I get a strange issue of Postgres not being able to find its own binaries.  Notice the error message below says invalid executable: "E:/"E:/pgsql/bin/postgres.exe"
For some reason Postgres is prefixing the current directory to the front of the path containing the executable and then using that as the path for the executable.

Anyone had success in getting version 9.6.6 to install and run?





[E:\]initdb -E LATIN1 -D E:\PGDATA
LOG:  00000: invalid binary "E:/"E:/pgsql/bin/postgres.exe"
LOCATION:  find_my_exec, exec.c:146
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.IBM-850".
could not determine encoding for locale "en_US.IBM-850": codeset is "IBM-850"
could not determine encoding for locale "en_US.IBM-850": codeset is "IBM-850"
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory E:/PGDATA ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... sysv
creating configuration files ... ok
running bootstrap script ... LOG:  00000: invalid binary "E:/"E:/pgsql/bin/postg
res.exe"
LOCATION:  find_my_exec, exec.c:146
LOG:  00000: invalid binary "E:/"E:/pgsql/bin/postgres.exe"
LOCATION:  find_my_exec, exec.c:146
FATAL:  XX000: "E:/pgsql/bin/postgres.exe": could not locate my own executable p
ath
LOCATION:  InitStandaloneProcess, miscinit.c:236
child process exited with exit code 1
initdb: removing data directory "E:/PGDATA"

4
Programming / ODIN - loading DLLs
« on: May 01, 2019, 07:07:20 pm »
Does ODIN know the "type" (windows vs OS2) of DLL and load both types automatically?

Meaning: if I have a windows program I have created called MYPROGRAM.EXE, and start that program using PE.EXE, can that program call functions located in DLLs compiled for OS/2 by an OS/2 compiler?

Conversely: If I have an OS/2 program, MYPROGRAM2.EXE, which is compiled for OS/2 and started the normal way (i.e from a command prompt, etc.), can that program call functions located in a Windows DLL?

Finally - if either program needs a function located in a DLL, and there is both an OS/2 type and Windows type DLL with the same name located on the LIBPATH, which one gets loaded? Or the same name (but a different type) already loaded into memory?

5
Setup & Installation / ODIN - System32 directory
« on: May 01, 2019, 06:48:55 pm »
Looks like ODIN is installed as part of AOS, which is great, and updated via RPM, which is also great.

However my ODIN installation on 2 AOS machines does not have an ODIN/SYSTEM32 directory.

The README and user manual both say that ODIN.INI should be located in ODIN/SYSTEM32, as well as ODCININST.EXE. I find both in USR\LIB\ODIN

So it looks like there is an ODIN tree under USR\LIB\ODIN and another ODIN tree under VAR\LIB\ODIN - but no SYSTEM32 directory anywhere. SYSTEM32 is the directory that holds DLLs common to multiple programs in Windows. Is there a substitute directory used in ODIN, or should I just manually create a SYSTEM32 directory and add it to the WINDOWSPATH?


6
Hardware / Pen for OS/2
« on: April 12, 2019, 03:58:50 pm »
I am trying to get Pen for OS/2 to install. When I run pinstall.exe (the install program) I get an error message saying "There is an active Pen for OS/2 Install program running. This is not supported."

I believe Sigurd Fastenrath has posted videos of a Samsung table running with Pen for OS/2.

Anyone know how to install Pen?

7
Setup & Installation / Desktop screen shots
« on: April 04, 2019, 05:26:10 am »
I think it would kind of fun to see other people's desktops - how they have configured their desktop, what apps they run, color and icon schemes, etc.

Anybody up to posting screen shots of their desktops? Maybe with a short description of their system and interesting hardware, along with what they have networked together, e.g.storage, file and/or database servers, what other OSes they are running and connected to, etc.

8
Applications / PMChart - and other v 2.1 applets
« on: February 26, 2019, 07:19:06 pm »
Does anyone have PMCHART hanging around from an old OS/2 v 2.1 installation? Or know what the format of the file is and how to extract the app from the OS/2 2.1 CD? It is in the directory

OS2SE21\DISK_7

on the CD.

It appears that PMCHART.EXE also needs PMCHART.HLP, and possibly MGXVBM.DLL, MGXLIB.DLL, INVEST.DAT, INVEST.GRP, FASHION. DAT, FASHION.GRP, GREEN.DAT, GREEN.GRP and maybe MIRRORS.DLL

I believe there were also some other applets that came with v 2.1 and disappeared in later versions. For example I cannot find PMCHART on the Warp 3 CD.

9
Applications / PMMail - COMCAST - secure tunnel
« on: December 19, 2018, 06:32:41 am »
Comcast has closed their port for plain text authentication. I am trying to get PM Mail to use secure tunnel but I apparently do not have it set up right.

1) On the secure channel setup should the server port and local port be the same number?

2) Should the port number on the account setup be the same as the local port?

3) Has anyone successfully connect to COMCAST with PM Mail using secure channel?

10
Applications / ODBC v 3 - SQLConnectW() - DB2 CLI
« on: December 17, 2018, 08:00:00 pm »
The DB2 v 7 ODBC driver is at version 3.52, which supports Unicode. The ODBC driver manager shipped with Lotus Smartsuite is version 3 - which was before Unicode was supported.

When I attempt to connect to DB2 using a DB2 v 7 ODBC driver with a version 3 ODBC Driver Manager I crash. It appears to me from tracing that the ODBC driver manager is, for some reason, calling the wide/unicode version of the DB2 CLI functions instead of the ANIS version. For example there is a SQLConnect() which is ANSI and a SQLConnectw() which is unicode; SQLConnectw() is getting called.

I assume my crashing is related to wide version returning data in buffers allocated for ANSI lengths of data. My believe is, in part, based on the tracing, and the fact that if I call SQLConnect() directly by linking to the CLI library rather than the ODBC library the connection succeeds.

It also appears from IBM documentation that the DB2's  defaults to the wide/unicode versions unless, somehow, restricted to ANSI functions. For example there is a db2cli.ini keyword DisableUnicode=1 listed in the version 11 documentation which I cannot find in the version 7 documentation.

Does anyone know how to restrict to ANSI only for DB2 v 7? 

11
Setup & Installation / Setup strings with PARSEDB and DATABASE.DAT
« on: November 16, 2018, 11:10:12 pm »
When creating or updating a Program Object it appears the WP_PROGRAM object in the WPS searches DATABASE.DAT when you cursor off the "Path and file name" on the Program tab of the program object and updates various settings on the program object based on the settings in DATABASE.DAT.

(This is described starting on page 122 of Redbook GG24-3731)

DATABASE.DAT is created/updated by PARSEDB.EXE based on text in DATABASE.TXT and "tags" in DBTAGS.DAT.

I was hoping I could add a new "tag" in DBTAGS.DAT that equals a setup string, make an entry in DATABASE.TXT/DATABASE.DAT with the setup string for a program, and have the Program Object execute the setup string when the user types a executable name in the "Path and file name" entry field.  But alas, it does not work.

Has anyone messed around with PARSEDB and DATABASE.DAT and created new tags to add settings to DATABASE.DAT that worked?

12
Applications / Problems Installing a PPD for PM
« on: November 07, 2018, 10:42:50 pm »
I am attempting to install a PPD using PIN.EXE and get the error message

reading driver extended attributes
   fail
SYS005: Access is denied
fail

Background
-----------------
I have an HP m452dn printer. The m452 family of printers includes m452dn, m452dw (with duplexer) and m452nw (no duplexer).

hplib, which apparently is where CUPS gets (some of) its *.PPD files from has
hp-color_laserjet_452-ps.ppd   and
hp-color_laserjet_452d-ps.ppd

The "d" in the name indicates the PPD for the printers which have a duplexer. Unfortunately the nickname in both those PPD files is the same, so CUPS can't distinguish between the two files.

I found the correct *.ppd for the HP m452 models with a duplexer, changed the nickname and used CUPS to modify the printer I had already installed to the new PPD. (That file is attached as hp_m452d_ppd.zip) Everything works great.

Problem
-------------
Now I want to update the PM printer driver with the new, correct PPD that contains duplexer info.  When running PIN to import the PPD I get an access is denied error - a screen shot of the error message is attached. I also get an error when trying to import the same PPD with the Manager Printers object in the Printers folder.

I get the message running PIN on the PPD before it has been cleaned, and after the PPD has been cleaned with cleanPPD.exe.  I have attached the cleaned PPD

13
Applications / CUPS User ID and Password
« on: November 06, 2018, 06:59:46 am »
On the CUPS administration page (http://localhost:631/admin) when I click on "View Error Log" I am prompted for a user id and password. None of the user ids/passwords I have entered work.

Does anyone have any idea which user id and password CUPS is looking for?

14
Applications / How to install and use DropBox plugin for Netdrive
« on: October 14, 2018, 03:14:19 am »
Anybody have any idea how to install or use the DropBox plugin for NetDrive?

I assume that to install it I use

YUM install  ndpdbox-0.6.0.b9-0.oc00.i686.rpm

This does create a folder on the desktop titled NpdDBox 0.6.b9. Inside the folder is an icon for Dropbox Authorize.

If the browser (firefox 45.9.0) is already open and I have signed on to DropBox when I click on Dropbox Authorize, click on the Start button, and then copy the text from the "Api Request Authorized" page on DropBox.com I get what looks like an error dialog box, title is DropBoxauth, message is: 
No access token in http reply!

If the browser isn't open then when I click the Start button, the browser starts and opens a sign on page for Drop Box. When I type in my email and password and click Sign In nothing happens - there is a busy cursor that never goes away.


15
Applications / AOS RAM Disk
« on: September 25, 2018, 06:43:44 pm »
I have read that the AOS RAM disk uses memory above the 4 MB limit - meaning on a 8 MB machine I could assign 4MB to a ram disk and not impact any OS/2 applications or the operating system itself.

Yet the Low and High memory check boxes and available amounts don't seem to indicate that is true.

Does anyone know where RAM disk takes memory? And it it does use memory about the 4 MB limit, how does it do that?

Pages: [1] 2