::: re. Open for non select statement (7562)

[Kevin Willis]

When attempting to use the SQL Explorer tool within OpenEdge 10.1A,
to perform an SQL update on a table from a remote OpenEdge 10.0B,
I received the following error message:

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20039
[JDBC OpenEdge Driver]:Open for non select statement (7562)

Any ideas on what might be causing this would be appreciated.

- Kevin Willis
klwillis.dsl@verizon.net

 

[Casper]

SQL Explorer tool within OpenEdge 10.1A,
to perform an SQL update on a table from a remote OpenEdge 10.0B

From availibilty guide:

Client and Server Connectivity – Both the OpenEdge SQL database and the Client ODBC and JDBC Drivers must be at least at the same OpenEdge Enhancement version (the definition of an ‘Enhancement release’ can be found at Product Life Cycle guide)​

from life cycle guide:

Enhancement Release
An Enhancement Release contains product enhancements and bug fixes and is reflected by a change in the second digit of the
version number. Since an Enhancement Release is a replacement release (refer to replacement release policy outlined in this
section), the “replaced” release assumes “Mature” status and will remain in the Mature Phase for 9 months following the first
commercial shipment (FCS) of the Enhancement Release, after which time it is automatically discontinued and no longer
available for sale. During this period, Progress Technical Support will be providing limited support for the earlier release.
Progress categorizes Enhancement Releases as upward compatible, and there should be a minimal effort in moving to an
enhancement release. Existing applications can continue to run without the need to recompile, and existing databases should​

So if you want to update an 10.0B db with SQL then you need to use a 10.0B driver.

HTH,

Casper.