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 - Jan-Erik Lärka

Pages: 1 [2] 3 4 ... 18
16
Programming / Re: BREXX - Classic REXX implementation
« on: June 28, 2023, 08:45:48 pm »
ooRexx 5.0.0 has been compiled for OS/2-eComStation-ArcaOS.
I'm writing rexx code for it here on my machine.
I've also created help files (.inf/.hlp) for the OS/2 version.

You may however wish for a fully system integrated rexx engine replacement as I do.

17
Utilities / Re: Intersolv/ODBC
« on: May 06, 2023, 09:04:46 am »
I have to use a patched version of the Apache OpenOffice odbc.dll to list selectable datasources... but then again, base refuse to actually reinitialize the connection once one reopen any .odb-file.

18
Utilities / Re: Intersolv/ODBC
« on: April 30, 2023, 09:24:45 am »
According to the ODBC documentation the function SQLConfigDataSource() is used to call the driver's setup routine, presumably including any dialog box(es) the driver needs to display to get info from the user to set up the datasource. 

The header files in the ODBC SDK specify calling convention for all functions in the SDK.
The image posted come from the app I started to design with VX-Rexx as can be seen on the icon of the window in front.
If one would go ahead there, one need a support library for rexx to call SQLConfigDataSource(...), but would would need one to query the driver itself as well, but a rexx library provide greeat flexability, yet power and should be easy to assemble.

Wrote some java code that load jdbc4 drivers, list them and their settings that could be used to set thing up.
Would be much gained if the different jdbc drivers would appear just like individual odbc driver rows to avoid special manager window for those.

At the same time I began to tinker with ideas on how to create ODBC-to-JDBC-bridge, but the problem with floating point exceptions made me stop. I do have C/C++ code now that can load jvm.dll and use java functions... so BSF4ooRexx and ODBC-to-JDBC should be possible as long as one avoid debugging. But someone else has to come up with the code to shuffle data, queries etc.

The UnixODBC driver manager that I got off of the web reports itself as version 3.52.  However I believe that UnixODBC at that time did not support fileDSNs, so neither does the OS/2 port.  The lack of FileDSNs isn't a big loss, in my opinion, since a FileDSN is just a DSN where the configuration information is stored in a separate disk file instead of being stored in ODBC.INI. Arca Noae may feel differently with their corporate customers: the idea of a FileDSN is the file can be created by a network administrator and stored on a file server, instead of requiring each user to create their own DSN on their own machines through the ODBC administator.

Also the concept of User and System DSNs doesn't make sense in OS/2 since OS/2 is really a single user system. That is why the Intersolv administrator only shows User DSN.  (System DSNs are available to all users of a machine, User DSNs are available only to a specific user.)

If Paul Smedley wants to pull the latest sources for UnixODBC and compile them for OS/2 that would be GREAT.  But please keep the following issues in mind.

That is a very important part you mention below

#1 The format of the ODBC.INI (and possibly ODBCINST.INI - I just don't remember right now) produced by Intersolv and by UnixODBC are slightly different.  I don't think the linux world had an installed Intersolv base they needed to conform to and we do on OS/2.  It would be nice if the new UnixODBC would produce ODBC.INI and ODBCINST.INI files that match the format used by Intersolv.  That way a user could use those files (and the drivers) with either UnixODBC or Intersolv.  This is because of #2

How about the Q+E drivers with DBExpert?

#2 There are users that purchased licensed versions of Intersolv drivers and use those with OS/2 applications.  For example Lotus Smart Suite bundled a complete set of licensed drivers.  Unfortunately the licensing for Lotus Smart Suite limits the use of those drivers to Smart Suite applications,  It appears the application calls a special function (probably in the Intersolv driver manager) that checks the licensing information while connecting.  If that function cannot be implemented in the UnixODBC port then the user would need to switch between Intersolv ODBC and UnixODBC in order to continue to use their licensed drivers.  The function that is called is mentioned in one of the readmes for VisualAge Basic - sorry I don't remember more details right now.

rexx/ooRexx 5.0 support (something like in unixodbc 010)

19
Utilities / Re: Intersolv/ODBC
« on: April 29, 2023, 09:54:23 am »
There's a Qt4/5 (I think Qt4 is stable) GUI admin tool for unixodbc as well.
Yes, I've seen it for quite some time now.

The attached file was modeled after the text mode instodbc as of unixodbc version 2.3.4, though use rexx on OS/2 and can therefore be enhanced and translated easily. (English and Swedish included)

20
Utilities / Re: Intersolv/ODBC
« on: April 28, 2023, 07:57:47 pm »
This is what I had in mind for a GUI Admin tool I started to work on... if someone would like to contribute how to open settings for the drivers and handle settings etc.

21
Utilities / Re: Intersolv/ODBC
« on: April 27, 2023, 10:27:15 pm »
i'd also sponsor work on an updated version that work with as many tools (e.g. office and development) and databases.

22
Utilities / Re: Intersolv/ODBC
« on: April 27, 2023, 12:38:17 pm »
The ODBC Admin maintain odbc.ini and odbcinst.ini that contain the paths to the drivers and settings.
If so, one could write a new one that look and behave well.

Is it odbc.dll that does major parts of the work under the hood then, or...?
Is it the different calling conventions used that cause problems with certain applications written with gcc or vac/wat?

JDBC to ODBC bridge would close the gap and enable us to connect to more databases.

A gui sql query tool with syntax higlightning would be very welcome as well.

23
Applications / Apache OpenOffice Base
« on: April 16, 2023, 07:45:06 am »
Hi,

I have a need to use OpenOffice Base on ArcaOS-OS/2 and have now tried it over and over again in several versions over the years...
One can create a new connection, jdbc with OpenJDK 1.6 as well, add tables, use the wizards, create reports with Oracle Report Builder as well.
The problem start as one reopen the saved .odb file, I guess from all retries with different database engines* I've done, that it may skip over some initialiation routine and thus fail (bail out/abort) as it behave ok at first.

What can one do to overcome this?

PostgreSQL
MySQL
hsqldb (both emedded with OpenOffice and as stand alone server)
Derby
dbf
spreadsheet
etc.

Code: [Select]
   EBP     Address    Module     Obj:Offset    Nearest Public Symbol
 --------  ---------  --------  -------------  -----------------------
 Trap  ->  1F47D03E   LIBCN0    0001:000FD03E

 0012FA58  1F47D80A   LIBCN0    0001:000FD80A

 0012FA78  1F3DAC85   LIBCN0    0001:0005AC85

24
Applications / Re: Updated Postgresql/2 builds
« on: April 13, 2023, 11:51:19 pm »
Uhm,

Ok, I'll write some even though there may not surface any updates.

9.3.17: Forcing the log worked, it started after that, but the other problems remain.

8.0.x contained a lot of goodies, but it's not possible to install it ( 9.1 and earlier ) as there are problems with \ (back slash) and libc?

9.3.17 and onward
(1. initdb) Define -U MyNewUser during initialization of the db folder and skip (3. createuser) allow one to connect to the server as MyNewUser.
(3. createuser) Fail as one add a superuser, (2. start server) then abort and doesn't end recovery during the next start to accept connections.
(4. create database) fail.

Created tables dissappear, as one use
Code: [Select]
pg_resetxlog -f D:\Path2\DBFolderif the server abort, or else the database is unreachable.

9.6.6 output a lot of problems with poll() as well

Steps I've used in the past within a rexx script to fully initialize and install PostgreSQL database for use:
Code: [Select]
initdb -U postgres -D D:\Path2\DBFolder --encoding=UTF8 --locale=sv_SE.UTF8 /* 1. To initialize and prepare path for databases */
pg_ctl -D D:\Path2\DBFolder -l logfile start          /* 2. To start the server with that path */
createuser -U postgres -a -d -E -P MyNewUser /* 3. Only the superuser "postgres" exists from start, one has to add to use MyNewUser */
createdb -O MyNewUser -U MyNewUser MyNewDB /* 4. Create the actual database as the Owner and User of the new db. */
pgsql  -U MyNewUser MyNewDB < D:\Path2\db_init.sql /* 5. Run SQL script to add tables, views, data etc. */
vacuumdb -U MyNewUser -a -z /* 6. To shrink, analyze and find possible optimizations */
createlang plpgsql MyNewDB -U MyNewUser /* 7. To add programming language PL/pgSQL to database */
pg_ctl -D D:\Path2\DBFolder stop          /* 8. To close the server gracefully */

Step 5 and 7 may be skipped, while the others are crutial to verify that the database engine and additions work as expected.

25
Applications / Re: Updated Postgresql/2 builds
« on: April 11, 2023, 05:24:49 am »
Ahh, ok.

In desperation I tried:
[D:\PROGRAMS\PGSQL\BIN]pg_resetxlog -f D:\...
Transaction log reset

And it worked! :)

26
Applications / Re: Updated Postgresql/2 builds
« on: April 10, 2023, 10:32:58 pm »
Hello,

I've tried the packages 9.3.17 and 9.6.6, but have problems.
9.6.6 seem not to allow one to connect nor add user, and especially superusers, while 9.3.17 allow one to use it with phpPGAdmin (create tables and add data) until it close unexpectedly... unable/unwilling to recover/rebuild the database.9.3.7 seem to have potential to work with OpenOffice through jdbc, was able to get a message "FATAL:  the database system is starting up" from it.  :)

Code: [Select]
PANIC:  could not write to log file 000000010000000000000001 at offset 7471104, length 8192: Invalid argument
STATEMENT:  commit

Killed by SIGABRT
pid=0x016a ppid=0x0102 tid=0x0001 slot=0x009c pri=0x0200 mc=0x0001 ps=0x0010
D:\PROGRAMS\PGSQL\BIN\POSTGRES.EXE
Creating 016A_01.TRP
Moved 016a_01.TRP to C:\var\log\app\6434819e-016a_01-POSTGRES-exceptq.txt
LOG:  server process (PID 362) was terminated by signal 6: Abort trap
DETAIL:  Failed process was running: commit
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  could not fork startup process: Invalid argument
LOG:  database system was interrupted; last known up at 2023-04-10 21:06:51 CEST
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 0/16E8C90
FATAL:  the database system is starting up
FATAL:  the database system is starting up

27
Programming / Re: WebSite / HTML editor - what do we have?
« on: February 04, 2023, 09:51:46 pm »
I use version 0.8b4pre (20100331, Gecko 1.8.1) as well, and the css-editor make it more useful than SeaMonkey.
Switching directly between the source code- and wysiwyg view cause problems, most often add square characters but also disable the save button. But that occur on other os:es such as "blowing in the wind" as well. Switch between the three tabs at a slow pace from left to right, or right to left to overcome some problems.

KompoZer 0.8b4pre produce code compatible with our firefox as both was created from the same generation of the mozilla engine (as in Firefox: Mozilla/5.0 (OS/2; Warp 4.5; rv:45.0) Gecko/20100101 Firefox/45.0). The included css-editor make it quite useful compared to the newer Blue Griffon 1.1.1 from 2011 (the css editor wasn't included by default), but doesn't support new styles introduced with html5. The css editor may therefore remove code you add by hand that it (the mozilla engine) doesn't support, unless you avoid to touch the custom style.

I would have preferred the idea to have the various front ends (such as KompoZer, Firefox, SeaMonkey, Thunderbird etc.) use one (1) common mozilla engine, but other platforms however must have dictated how and what.

28
Utilities / Re: graphic interface for smartahci
« on: January 07, 2023, 09:10:06 pm »
Anyone tried to add code that for example test a hdd?


29
Events / Re: Warpstock 2022 - Personal Remarks
« on: December 12, 2022, 10:33:27 pm »

UEFI support was coming for more then 10 years. And Intel announced that on 1st of January 2020 CSM support would be withdrawn by Intel.
So its all difficult choices to make...

Roderick
One use whatever, when there's a way one can find a workable solution with minimum effort. It's however not possible to buy a current computer here without uefi and gpt, so that is something to address here and now. CSM is a transition phase that OS/2-ArcaOS need to overcome or we're stuck with spare-parts-machines.

While there is still a very large amount of hardware that allows installation in the CSM, there have been no new OS/2 WLAN drivers for almost exactly 15 years.
Blonde Guy presented a neat universal solution on his page with the external WiFi that use ethernet where we do have support combined with configuration through the web browser or curl. Ok, it use something external, but it seem quite usable. I've asked the local dealers for some "mango" but may have to order one directly from the states. Need to get a new laptop soon, as the left shift key fail now and then, so...

As uninteresting as it may be for industrial customers, this has ultimately been the nail in the coffin for many private users for OS/2 use.
Isn't it more likely the die hard enthusiasts that use OS/2-ArcaOS these days and not "Industrial customers"? Do look forward to the update to Dynamic Icons, xCenter/XWP, high resolution support (as mini icons tend to be tiny on modern screens) updated web browser and ooRexx 5.0. Appreciate such usability enhancements as a user while others want something else more important to them.

I'd therefore like to take the opportunity to

Thank you to everyone for your participation and work on OS/2, eComStation and ArcaOS. You are greatly appreciated!

Unfortunately, "It's high on our list, but..." or "Priorities have shifted for the umpteenth time..." were also very counterproductive. It's the same as always: there are lengthy explanations but in the end only facts count: no WLAN for 15 years, it's that simple.
Can imagine that developing the framework/infrastructure for such a set of driver must be significant. I can't see, quantify and thus not compare that required effort as to what it has been used for instead, and perhaps that's what some would like: To be able to compare themselves and prioritize, but that is possible when you have the some money already and the info tied to it. It can be frustrating when someone else got a broader perspective and info that may not be available to all.

30
Applications / Re: ssh - sshd
« on: November 01, 2022, 06:36:30 pm »
ssh -v

OpenSSH_5.3p1, OpenSSL 0.9.8k 25 Mar 2009

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