Search results

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...

I just ran into something interesting... I couldn't make my DB connection as long as the port specified was a name like "Myport123". We utilize the the services file, since we have various DBs running, and remembering a name is much easier than remembering a port number. I'm going to try...

Glad ya got it working. Nice. Thanks for posting the follow-up. I haven't had much time to work in Architect lately. I did try out the CVS features and so far I really like it. The factor prohibiting me/us from moving forward with Architect is that it doesn't appear to have an infrastructure...

In what section? I set up various connection profiles already but it's not keying off of those. I also tried specifying project startup parameters such as -db DatabaseName, etc. but that didn't do the trick either. Where in preferences did you specify the DB connection information?

Eclipse Rocks! Good enough for me. Hitting CONTROL+Space does show available keywords. As for getting the database field names, the problem I had was that I wasn't connected to the DB through tools-data dictionary. Once I connected to the DB, it showed up on the DB tab at the bottom, and I...

I'm just starting out with the Enterprise Architect using Eclipse. I'm wondering how to activate the feature where the editor will type-ahead certain things. For instance list the fields of a table as you type the table name followed by a dot. I think Microsoft calls it intellisense, not sure...