Search results

Nice. I'll check it out. I've been playing with the MSQRY32.exe tool that comes with office, but it is very buggy.

The SQL Explorer tool is gone as of 10.1a. As far as I can tell, we need to create a new ODBC DSN for each different database we want to connect to. All gripes aside, I know it's still possible to run SQL queries against the DB, it just has to be done through a third-party application...

Bummer ouch, that sounds like a painful ordeal. I'm not very well versed at .net yet so I dont know how to compile to COM object. The project we wanted to do involved adding some features that are natively available to .net. Through progress we would have to make API calls... We live and we learn.

Hey I like this! It's packed with useful features. Now I just have to find my way around. Thanks for the recommendation Jonny.

From your description it sounds like the best thing since sliced bread. I'm downloadint it now to give it a shot. If my dreams come true, this IDE will have intellisense (like VS), syntax highlighting, etc...

Would you mind posting a few hints? For instance the call you're making from Progress, as well as any helpful hints in making the .net dll?

The SQL-92 guide should be able to answer that question and many others. http://www.progress.com/progress_software/products/documentation/start/docs/sql92/s92/s92.pdf

So far I've done all of my Progress/Java experimenting in the SQL explorer tool. It's getting to the point now where I need a real development IDE. I could copy my code out into my .net IDE, but that would be cumbersome as I make small changes, compile, fix things, make more changes... Which...

Sounds familiar... are you interfacing to a db named HOST or POS? What user name are you logging on to the DB with? If the user name contains a space, then the java compiler will puke. You can confirm this by taking a look at the java file that gets spit out when the compile fails. The...

I just used the NOW() function recently and it worked like a charm. I was adding a record to a table that had a date field defined as "required". Just off the top of my head my syntax looked something like this: INSERT INTO PUB.barcode ("UPC","created-date") VALUES...

It is confirmed. I just got it up and running on my development computer (Java 1.4.2). Here are my fix notes: Add a user without spaces in the name (our default DB owner has a name with spaces, this initially caused Java errors when compiling). GRANT DBA TO SQL; COMMIT; Install Sun's...

I think I just got it. My system path was missing the folder: C:\Progress\OpenEdge\jre\bin\client AND after fixing the path, I had to reboot for it to take affect. Now when I run the stored procedure I get no errors... That leads me to believe it's working. I'll confirm this and then post...

Already reviewed that KB Entry. All it does is sets environ variables in that DOS instance - not the environment which is used by the DB server. In other words, that KB Entry probably worked for someone who was starting their DBs from that DOS session, but not from progress explorer tool. They...

This morning, I uninstalled Java and OpenEdge 10 installed Java 1.4.1.03 into C:\progress\openedge\jdk installed OpenEdge 10 installed OE SP 3 Installed pup fix created a new stored procedure Ran that procedure Same error rebooted Ran the procedure again same error === SQL Exception 1 ===...

Windows XP Professional. Sun's JDK 1.5.0 revision 6 (the latest asof today). I selected this version because it is the latest, and the SQL92 doc I read indicated to use any version after 1.4.something. Earlier I had installed the JDK into the default C:\program files\java\... folder, but...

Thanks. I was able to get past that error, just to be presented with another. What I did was modified progress.ini by adding these values to the existing ones: JDKHOME=C:\Progress\OpenEdge\JDK JREHOME=C:\progress\openedge\jre...

All tests have been on OpenEdge 10.0b, with Wkgroup license. There is no %DLC%\JDK directory, but there is a JRE, which I renamed after fixing the java paths through progress.ini and regedit... It's using the Sun JDK now (at least to start adminservice) but doesn't know to use it when it comes...

I just tried creating a stored proc on my development server and that one returned the java error message - that's good! My development computer has something that the lab is missing... I think I'm on the right track now so I'll do some more reading in the SQL92 docs. Is there a specific...

No Errors Thanks for the note. The problem is that no java errors are ever shown... Is this by design? If so then my second problem is that I am not able to create any stored procedure, no matter how simple it is. The same error is always returned (see below). How can I make sure the java...

I would like to create my first stored procedure, so I have created what I think is an extremely simple (so it should work, right?) procedure that does basically nothing. My Query (executed through SQL Explorer tool) create procedure MyFirstProcedure () BEGIN string strHello = new String...