Recent content by jeremysimmons

Stefan - thanks for encouraging the sanity checking. No, the propath.ini I 'thought' was being used, was not! (the one in %DLC%\bin). It was using values from the Windows Registry first. OpenEdge® Deployment:Managing ABL Applications page 4-6 has a wonderful illustration Figure 41: Windows...

yes. I saw that immediately after my post. I changed it, and it doesn't work at all. I got a tip from the guys in the office to do this. [setpropath.p] propath = "foo,/bar,/bar/baz". run testProPath.p [testProPath.p] message propath. apparantly since I'm on windows, instead of unix, the...

FocusIT/Stefan - I can't seem to get this working. working directory contains progress.ini and testPropath.p. executing: C:\Progress\OpenEdge\bin\_progres -b -ininame progress.ini -p testPropath.p [testProPath.p] message propath. [progress.ini] [WinChar Startup] DLC=C:\Progress\OpenEdge...

tom My immediate goal is to generate a single result set using SQL that contains a sequence of numbers in a specific range. A sequence of numbers helps with all kinds of things in SQL. Parsing strings, generating dates, replacing complex procedural constructs and cursors with simple and...

I certainly cannot do this: select 1 UNION ALL select 2 UNION ALL select 3. Syntax error at or about (statement excerpt). (10713) SQL-92 found a sql syntax error in the sql statement sent to it by the client. "statement excerpt" is the portion of the statement where the syntax error was found...

Re: норма ток мал @vinod_home - didn't check the log file. as stated earlier, I was able to fix the issue by allocating more login brokers for my database server. Thanks for the tip about the promon. I'll look into that.

Thanks for the post casper. I used the instructions at How to set up a secondary login broker for SQL-92 connections for Progress 9.1D and above to setup my Database server correctly. I also had to use a user that had the SQL RESOURCE priviledge. In this case it was the user sysprogress. The...

Sorry to reopen a thread, but I read this and disappointingly didn't find a reply. I ended up using this quick&dirty .p to fix my issue. FIND FIRST _user WHERE _userid = "SYSPROGRESS" NO-ERROR. DELETE _user. CREATE _user. ASSIGN _user._userid = "SYSPROGRESS" _user._Password = ENCODE("").

Tried this command: proenv>sqlexp -char -db sxe61 -S 9800 -user UUUUU -password PPPPP OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009 Connecting user "UUUUUU" to URL "jdbc:datadirect:openedge://uscsnjsimmons1:9800;databaseName=sxe61"... (8920) Error: [DataDirect][OpenEdge JDBC...

I could use some help getting SQLEXP working. Windows 7 x64. OpenEdge 10.2B 32-bit. started ProEnv. ran command sql_env. tried to run sqlexp in character mode using: proenv>sqlexp -char -url jdbc:jdbcprogress:T:localhost:9800:sxe61 OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009...