Recent content by regulatre

When I install Progress/OpenEdge, the ODBC driver has always come bundled with the Progress installation. I only go back to 9.1d, does 9.1c not come with the ODBC driver? During Progress installation, there is a question that comes up asking you whether you want to install 4gl, SQL, or both...

Download a packet sniffer such as WireShark and monitor the VPN interface while you try to connect. This will reveal what it really taking place. Make sure not to monitor the internet interface because that will be encrypted and wouldn't be of any help. If I had to make a guess, I'd says...

possibly with select * from PUB."_user" There are a bunch of system tables, like _user that are available via SQL. Looks like there's a system table for db locks, & much more.

The [a-z] clause isn't doing what you expect it to. I just ran a test here and confirmed that Progress (SQL-92?) didn't expand that into "any of a through z" instead I believe it treated it as a literal string. I also searched the SQL-92 guide for any mention of the bracket chracter and didn't...

You might try using javascript by way of a stored procedure? The trick would be making those two connections. Once you did that, the stored procedure would have access to both. It would be worth looking into. The stored procedure could be called relatively simply once you create it. Or like...

The information I gave you is the most you're going to get from anybody on this forum. It will be a waste of your time to take this any further. This will be my last post to this thread. HTH

No doubt these reports were optimized to the original SQL DB and not the Progress SQL... For starters I would crack open the OpenEdge database optimization guide. It's in the documentation section on the Progress web site. The file name is something like tuning_oe_rdbms_ex_06_final. Some...

There are several PDF/online/html manuals that cover that topic: The general area for documentation is: www.Progress.com support Resources Documentation

Yesssssssss!!!!!! GOT IT! While I was in trying your various recommendations, I realized that, when no record is found, I'm doing a "continue". Which skips all the rest of the commands in the braces and starts the next loop. Well the problem with that is that I'm releasing the cursor at the...

It appears that SQLResultSet does not offer a close method. I get the following errors when I try to use the close method. >[Error] Script lines: 1-99 ------------------------- [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Error from Java compiler. Compiler messages follow.(10727)...

I'm calling it from my SQL query tool. I happen to be evaluating Aqua Data Studio (so far it's awesome). Squirrel SQL 2.2 actually tries to interpret the JS and doesn't pass it to the DB for compilation so I can't use Squirrel to create stored procedures.

>[Error] Script lines: 1-1 -------------------------- [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Number of open cursors exceeds limit (7612)  [Executed: 5/26/06 2:17:25 PM EDT ] [Execution: 0/ms] I get the above error upon running my stored procedure for the 17th time. (the first 16...

No dice. Thanks for the valiant effort.

Syntax highlighting isn't working too. My architect is all foobar'd. Definitely going to take a reinstall to fix this. What a pain. Anybody know where the config data is stored? I couldn't find it in the registry or in usual documents and settings places. I would try deleting it so it...

You're going to think i'm crazy, but the eclipse/architect editor is acting really strange. It's exhibiting the following behavior: Hitting enter at the end of a line does not trigger a new line - instead it does nothing. pressing the dot key results in no dot being inserted - instead it does...