Search results

  1. Rob Fitzpatrick

    Question Connecting to Progress database thru IBM Cloud Secure Gateway client

    To expand on what @TomBascom said, when a TCP client (whether ABL or SQL) connects to an OpenEdge database, it first connects to a login broker which listens on a statically-defined port. This is the port number you see in your DSN. It is the only port the client needs to know to initiate the...
  2. Rob Fitzpatrick

    PAS licenses for 12.8

    I can't give you a definitive answer, but this interpretation (as many sessions as you want) would not align with the way Progress typically licenses their products. To me, this is the more reasonable interpretation; the countable entity would be the AVM session, not the process. And it aligns...
  3. Rob Fitzpatrick

    PAS licenses for 12.8

    The Concurrent User model was grandfathered by Progress for existing licenses of existing customers. They could keep those licenses and add users to them. But no customers could buy new licenses on that model. I don't have first-hand knowledge of the Access Agent situation, but it sounds like...
  4. Rob Fitzpatrick

    PAS licenses for 12.8

    Caveat: it has been several years since I worked on OpenEdge licensing, so my knowledge is out of date, and I've doubtless forgotten a few things. A license that you purchase has several attributes (this may not be a comprehensive list): the software product being licensed (e.g. Enterprise...
  5. Rob Fitzpatrick

    Audit Policy Maint

    You can create audit policies for CUD events per table, but that happens server-side, and it happens for all users. However, you could choose to report on those events for only certain users, if you have a way to distinguish application user names from others (DBAs).
  6. Rob Fitzpatrick

    Audit Policy Maint

    That's a very vague requirement. You'll need to be a lot more specific about what you mean by "track by users".
  7. Rob Fitzpatrick

    Issues after installing the service pack 11.7.19

    What was your procedure to install the OpenEdge update?
  8. Rob Fitzpatrick

    Comment ABL Toast Notifications

    It's an OS notification mechanism where a small panel slowly pops up in the corner of the screen, in a manner reminiscent of a piece of toast popping up from a toaster; thus, "toast notification". The panel contains a short message and the name of the application or OS component that created...
  9. Rob Fitzpatrick

    DB Backup script

    Given both the syntax and the .sh extension, that is a Unix shell script. You would run that to back up a database on Linux. You will need to translate it to the appropriate syntax for a scripting language on Windows, e.g. a batch file (.bat) or a Powershell script (.ps1).
  10. Rob Fitzpatrick

    Track Structural Changes in DB (Auditing not enabled)

    If you have an audit requirement, i.e. you need to provide data from an audit trail that is uninterrupted, unimpeachable, authenticated, and secure, to satisfy an auditor, use OpenEdge Auditing. Any solution short of that, which captures similar information, is just logging. If you don't want...
  11. Rob Fitzpatrick

    Sqlexp

    This KB may also help: https://community.progress.com/s/article/20143
  12. Rob Fitzpatrick

    Sqlexp

    Your user SQLUser is unable to read data because your attempt to grant it select permissions failed. First, check who has such permissions; look in the sysdbauth table. E.g.: select * from sysprogress.sysdbauth;
  13. Rob Fitzpatrick

    Answered Question on xcoding

    Not all code changes alter the length of a source file, e.g. fixing a typo of transposed characters in a string, changing an operator (e.g. ">" to "<"), changing the value of a constant, etc. Such changes would result in a different xcoded file with the same length as the prior one.
  14. Rob Fitzpatrick

    OE Studio / GitHub integration

    It looks to me like PDSOE is not the future for OE development. It isn't completely abandoned, like OE Studio, but in my view the writing is on the wall. In Progress' roadmap talks, they talk about supporting Language Server Protocol, which will ultimately allow you to use your IDE of choice...
  15. Rob Fitzpatrick

    Answered Question on xcoding

    An xcoded file will always be one byte larger than the source file: as I recall, the first byte is always 0x13. It sounds like you're rolling your own checksum algorithm. Couldn't you just use an OS tool like diff to compare two xcoded files? Also, is there any possibility that some of your...
  16. Rob Fitzpatrick

    Upgrade from 9.1E to 12.8 (Windows)

    @JLovegren I've written about a general approach you can take in this thread. That was about going from 10.1A to 11.7 (i.e. across one major-version boundary), so it's relevant for your journey.
  17. Rob Fitzpatrick

    Copying a Procedure Library

    I've done this in the past. It works, as Tom points out, if the r-code in the PLs doesn't use any incompatible OS-specific features (e.g. assuming a GUI library is in the propath in a tty environment).
  18. Rob Fitzpatrick

    Question Progress User Named/Seat License for developing platform

    From 3.4.2: One of the attributes of a Progress license model is whether it is single-server or multi-server. Named User is multi-server. In your case, you can install this one license on your three servers. You didn't mention which product this is. I mention that because some product use...
  19. Rob Fitzpatrick

    -n value maximum number of user

    The -n parameter doesn't affect how many users you can define, if by "define" you mean "create". The -n parameter determines how many users can connect to the database at the same time. You can see how many users were purchased for each of the product licenses that are installed on the server...
  20. Rob Fitzpatrick

    -n value maximum number of user

    Of course. Every setting has a limit. The -n parameter determines how many database connections you can have concurrently. It includes all types of connections (4GL clients, SQL clients, utilities, helper processes, etc.), except for servers and brokers. The question shouldn't be about the...
Top