Some of the reasons for this error message are:
1.> Connecting to a database version which is NOT supported. e.g. connecting via the Connect 4.2 driver for ODBC for PROGRESS (9) to Progress 9.1A and older or to a PROGRESS OpenEdge 10.0A.
2.> The PROGRESS database picks up a wrong copy of the Java Virtual Machine. Make sure to install the PROGRESS recommended version of the JVM/JDK and that the PROGRESS database actually picks up this version. (e.g. JVM 1.3.0_02 is required for PROGRESS 9.1D on Red Hat Linux 7.1). Check the version of the Java Virtual machine by executing the command: java -version
3.> The PROGRESS Database Server service has not been started, or has been started with _mprosrv. Make sure to start the PROGRESS database server service (after checking that the DLC/PROMSGS environment variables have been set correctly) by using the command proserve databasename.db -N xx -S xx -H xx
4.> The PROGRESS Database Server may not support SQL92 connections (e.g. there is no SQL-92 RDBMS on DG/UX Intel, SCO OpenServer & Solaris Intel platforms, and only SQL89 connections are supported with the Connect 4.0 driver for ODBC for Progress).
5.> Hostname resolves to wrong IP-address or does not resolve at all. In this case, specify the IP address as host name.
6.> The wrong port number is specified. Make sure to specify the correct port number in the ODBC data source. This should point to the TCP port number on which the PROGRESS database server service is started.
example:
If the PROGRESS database server service is started as follows:
proserve -db theDatabase.db -N TCP -H thehost -S theServiceName
where theServiceName is specified in the etc/services file as follows:
theServiceName xxxxx/tcp
(note: where xxxx should be a valid TCP/IP number below 65536, like 1234)
(note: specify '/tcp', not '/udp')
then you must specifiy
xxxxx (eg: 1234)
7.> You may have run out of remote servers on the database. If the 4GL remote clients are using all of the remote servers then the database can't serve SQL-92 clients. You may have to set up a secondary login broker to attend SQL-92 connections.
8.> The firewall (e.g. Zone Alarm,..) may be blocking access. Check with the system administrator to monitor network traffic.