Errors 4393 & 5644 occur when using SQL-92 with ProVision, ProVision Plus, 4GL Development or OpenEdge Studio licenses

Errors 4393 & 5644 occur when using SQL-92 with ProVision, ProVision Plus, 4GL Development or OpenEdge Studio licenses

SQL-92 client receives ODBC PROGRESS driver errors and cannot connect.


Cannot connect a remote progress client (prowin32 and/or _progres_) to database
Database server log reports errors 4393

One of the following Progress licenses has only been installed on server; i.e., Provision, Provision Plus, 4GL Development or OpenEdge Studio
Error received even after starting a database sever with networking parameters -H hostname -S portnumber
Unable to establish a remote ODBC connection
Cannot use SQL-92 remotely

Can connect from server machine to database with -H localhost
Cannot connect from server machine to database with -H ip address
Cannot connect from remote client machine to database on server machine with -H ip address

The messages appear because the Provision, Provision Plus and OpenEdge Studio products include only a personal database designed for local connections only.

When a local database server is started, it listens for connections at the localhost interface only.
This allows connection to the SQL-92 engine only from the same machine using client-networking parameters.

In order to be able to connect, there are two Options available:

Option 1:
1. Start the database using -S database startup parameter only (not the -H parameter)
2. Connect to local database using -H localhost -S

Option 2:
1. Add a database license such as OpenEdge Workgroup RDBMS  or OpenEdge Enteprise RDBMS which will allow client-server connections.

Reference to Written Documentation:

Database Administration Guide and Reference.

SQL-92 Guide and Reference.