[Progress Communities] [Progress OpenEdge ABL] Forum Post: Connect OpenEdge database remotely

[nikhil@ranosys.com]

I have subscribed for 60 days tril of Progress OpenEdge RDBMS (cloud)) to explore it for my upcomming project. I have created my database there and started using proserve command. Now I want to connect to this database in my JAVA application using JDBC connection from a remote machine. But I am unable to connect. My JDBC connection string is below: jdbc:datadirectpenedge://ec2-54-147-132-36.compute-1.amazonaws.com:6786;databaseName=testdata and I am getting this error: java.sql.SQLNonTransientConnectionException: [DataDirect][OpenEdge JDBC Driver]Error establishing socket to host and port: ec2-54-147-132-36.compute-1.amazonaws.com:6786. Reason: Connection timed out: connect at com.ddtek.jdbc.openedgebase.ddb9.b(Unknown Source) at com.ddtek.jdbc.openedgebase.ddb9.a(Unknown Source) at com.ddtek.jdbc.openedgebase.ddb8.b(Unknown Source) at com.ddtek.jdbc.openedgebase.ddb8.a(Unknown Source) at com.ddtek.jdbc.openedge.OpenEdgeImplConnection.j(Unknown Source) at com.ddtek.jdbc.openedgebase.BaseConnection.b(Unknown Source) at com.ddtek.jdbc.openedgebase.BaseConnection.k(Unknown Source) at com.ddtek.jdbc.openedgebase.BaseConnection.b(Unknown Source) at com.ddtek.jdbc.openedgebase.BaseConnection.a(Unknown Source) at com.ddtek.jdbc.openedgebase.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at JDBCConnection.main(JDBCConnection.java:15)

Continue reading...