I was able to get this working. (In addition to setting all the Java environment variables, etc., it is looking for the JRE). I was under the impression that the java vm in the JDK would be used to execute the stored procedure dynamic library.
I am able to create a stored procedure successfully (and able to drop it, recreate it etc., and also when I give wrong parameters it correctly comes up with the error). However when calling the stored procedure I get this:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210022...
I am trying to create a simple stored procedure (tried using sqlexp as well as a jdbc tool). While other SQL operations work, I am unable to get this working:
A trivial Hello World case: (Error while compiling stored procedure)
@echo true;
@autocommit true;
CREATE PROCEDURE "HelloWorld" ()...
I did that. In fact I also added the JAVA_HOME variable to the various batch files (and of course the DLC) - but no luck. Eclipse comes up but then it is the vanilla editor with no plugins
I am trying to get PDSOE (classroom edition) installed but even when I setup Custom as the installation type, it does the silent install. And I end up with numerous problems with JAVA_HOME, environment variables, etc., and the result is that eclipse just comes up with no Progress plugins. Any...
Looks like the port redirection in Progress DB (which I did not know happens) may be causing the connectivity failure. I think taking care of that (appropriate firewall rules) should take care of this
Hi Rob,
Thanks for your response.
Attached is the odbc.ini file.
Since it works from Windows (odbc connection to the same server, port, DB) I assume there is a SQL Broker process. However, I will check with the DBA again.
Also jdbc connections work from the same server (just for information -...
I just installed an eval version and configured an OpenEdge database.
Ran the provided example program under samples. It picks up the correct one from odbc.ini, however
I get this error:
SQLSTATE = 08001
NATIVE ERROR = 0
MSG = [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.