14:40:25,897 DEBUG (c.d.m.j.i.JDBCImportModule) Error executing query with default fetch size of 0 Perhaps its a good idea to make sure you have a valid backup before you start messing around with the users.14:40:25,896 DEBUG (c.d.m.j.i.JDBCImportModule) query: SELECT file, kirjeldus, kasutusel, moodul, ParentModule, create_kell, create_kpv, create_id, muutja_kell, muutja_kpv, muutja_id FROM PUB.moodul Now you should be able to follow the steps in the link provided above.

To exit something F4.Īccess the Menu using F3 and arrow-key your way to Tools -> Datadictionary. Then access the Progress Editor with a connected database: pro -db rep -H -S It might possibly be a service name to check in /etc/services Look for something like: P-XXXX T-YYYY I BROKER 0: (4262) Servicename (-S): NNNN. If you dont know: check your database log file (rep.lg). Then identify on which port the 4GL broker runs. And possibly try this solution:įirst run that proenv-script, it will set paths and environment variables.

You could try accessing the database using the native 4GL broker. How can I go around this given my environment to be able to establish a successfull connection?Īdditional note: There's a special user called progressuser under which database is created, but impersonating that user from root as su progressuser and going through the same process yields the same results. Which is obvious from my side, but there's no way to get user and password. I get an error even without user and passwordĮrror: Access denied(Authorisation failed). With files like rep.db, rep.lg, rep.b1, rep.d1 and some other files avilable on localhost under port 2502 (confirmed through ps aux | grep rep) Given that there's a db within /dbloc/prod/rep/ Which brings up proenv, and then when I try sqlexp -db rep -H localhost -S 2502 How can I connect to this database so that I can later create another account to use through ODBC?īeing on root account, opening up proenv by /dlcloc/dlc-11.5/bin/proenv There's no way I can obtain it from someone else, as nobody knows these credentials. I'm unable to, since I don't know the user and password. I'm trying to connect to Progress database through proenv and sqlexp. Setup: Progress 11.5 databases sitting on Linux (CentOS) server, with proenv available.

Openedge jdbc driver