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 - Per E. Johannessen

Pages: [1] 2 3 ... 12
1
Programming / SAF-T
« on: December 17, 2020, 06:24:55 pm »
Hi,

Anyone here with knowledge of converting accounting data from text files to SAF-T?

https://en.wikipedia.org/wiki/SAF-T

At the moment there are only three standard accounting reports that, by local law, must be availble upon request
from tax authorities. I think REXX and XML can be used for this.

2
Storage / Re: eSata
« on: December 15, 2020, 08:03:59 pm »
Thanks Ivan, I'm going to use SSD's, but good to know.

Thanks for links Andi.
I noticed that they mention eSATAp so they get power over eSATA and my system does only have eSATA port.

Anyway, I've asked a local computer reseller to come up with a solution.

3
Storage / Re: eSata
« on: December 15, 2020, 04:22:42 am »
Thanks, Pete.
For now I've ordered a similar cable as the one Roberto is using.
Will keep searching for an external eSATA enclosure though. Based on the comments that USB 3.0 is slow on our platform it's even more important.

4
Storage / Re: eSata
« on: December 13, 2020, 05:28:07 pm »
Roberto,  I meant to ask for the brand/model of the disk cabinet/enclosure, sorry for being unclear.
I see now that you don't use any external enclosure at all so I'll try to get such a cable that you mentioned.

5
Storage / Re: eSata
« on: December 12, 2020, 08:57:46 pm »
Well, that's a surprise to me. I never thought that we would achieve USB 3 transfer speeds that the hardware manufacturers lists as max speeds but only 20% of what they should be able do is very disappointing.
Slow, or not, I will eventually need an external USB 3 drive and will also continue trying to find eSATA solution.

6
Storage / Re: eSata
« on: December 12, 2020, 03:54:46 pm »
Thanks to all for info.

Doug, I had hardware controlled RAID in mind when mentioning an enclosure for 2 disks.
Not really necessary, just that I'd like to try it.

Pete, I was actually looking at various Icy Box disk enclosures but couldn't find any wth eSATA.

Anyway, both of you mentioned USB 3 so I think I'll go for that.


7
Storage / Re: eSata
« on: December 11, 2020, 06:03:18 pm »
What external disk brand/model do you have?

8
Storage / eSata
« on: December 11, 2020, 04:43:12 pm »
I have a ThinkStation P520 with an eSATA port and I'm trying to find some "external SSD disk system" to connect to it.
All systems I find use either USB 3.0 or Thunderbolt. Preferably I'd like to have an external enclosure/cabinet that can hold one or two SSD's. Any ideas?

9
Programming / Re: ODBC VX-Rexx/DBExpert
« on: December 02, 2020, 12:00:44 am »
Hi Sean, sent you a pm......

10
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 25, 2020, 09:41:19 pm »
Hi Dave,

To get an idea of how unixODBC works I think it's best to install the old version:

https://hobbes.nmsu.edu/?detail=%2Fpub%2Fos2%2Fapps%2Fdatabase%2Funixodbc010.zip

Long ago I had it installed but had some problems with the odbc driver. Don't remember exactly what the problem was so I'll install it again when I've set up a "test system".




11
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 22, 2020, 02:43:20 pm »
For simple SQL statements the DBE drivers do work with VX-Rexx, using JOIN or AS in queries fail.

Did try UNIXODBC quite some time ago but had some trouble with that package also.
At that time I also tried SmartSuite's odbc driver (Intersolv?) and it keeps displaying a popup window
when used with other programs.

UNIXODBC looks promising so a more recent port would be nice.
Unfortunately I don't have the skills to do that.

12
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 16, 2020, 04:23:35 pm »
Found the SQL statement in a file named window1.vry and it is identical to the one produced by DBExpert.

Does anyone happen to have Watcom SQL?
Believe that one is doing well with VX-Rexx so I'd like to try it if it was available anywhere.

13
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 15, 2020, 12:19:26 am »
Yes, can do without 'INNER JOIN' in this case, but this was just an example to trigger the error.
Most queries in this project are quite simple, however I a need a few that involves up to four tables and several joins.

Have tried to find the actual syntax/code VX-Rexx creates by searching the various sections involved but no luck so far.

14
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 14, 2020, 05:55:55 pm »
Here is an example of an error I get when running the SQL statement with VX-Rexx.
(The same SQL statement produces the expected result and no errors with DBExpert.)



15
Programming / Re: ODBC VX-Rexx/DBExpert
« on: November 13, 2020, 06:38:12 pm »
I don't have ODBCADM.EXE in os2\apps\bin, however the one I use is \dbexpert\odbcadm.exe and it works ok.
Think the problem is with the odbc.dll so it would be nice to find out what SQL commands it supports, and/or find out what's blocking
VX-Rexx from using all the functions.

You mentioned that your odbcadm.exe does nothing. Doesn't it even bring up the dialog window where you can define databases etc.?

Pages: [1] 2 3 ... 12