Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

What Progress licenses install the ODBC SQL-92 and JDBC drivers

Information

 
Article Number000020494
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version:10.x, 11.x
OS: All supported platforms
Other: ODBC & JDBC drivers
Question/Problem Description
What license do I need on client side in order to connect Progress database from Java?
What minimum client license contains SQL-92 JDBC driver?
What Progress products contain the SQL-92 ODBC driver?
What Progress products contain the SQL-92 ODBC and JDBC drivers?
What products are required on the client side to setup a JDBC connection?
What products are required on the client side to setup a SQL-92 ODBC connection?
What Progress licenses can be installed to get SQL-92 JDBC driver?
Is the ODBC driver included in a Client Networking license?
What licenses provide the ODBC driver?
Do I have to purchase or buy a product to get the ODBC Drivers for OpenEdge?
What license(s) are needed on the client-side in order to connect to a Progress database using ODBC, JDBC or ESQL-92?
What license is needed on the client-side in order to connect to a Progress database using ODBC?
What license is needed on the client-side in order to connect to a Progress database using JDBC?
What minimum client license contains the SQL-92 ODBC, JDBC driver?
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution

The SQL-92 Client Access license contains the ODBC and JDBC drivers together with the necessary files to support ODBC connections to the Progress/OpenEdge SQL-92 engine (_sqlsrv2).  Starting with OpenEdge 10.0A the SQL Client Access is no longer a paid product. It is available as a free Deployment Component and can be found in the Progress Electronic Software Download Page (ESD).

In order to establish a SQL-92 ODBC or JDBC connection to a Progress / OpenEdge Database a Progress Client license of the same major version is required if the client does not exist in the already existing license package. 

While the SQL Client Access license is minimum license required, any of the following products will also provide support for SQL-92 connections.  

The ODBC and JDBC drivers are obtained by performing a complete installation one of the following licenses:

  •         4GL Development
  •         Client Networking
  •         Enterprise Database
  •         ProVision (Progress 9.x)
  •         ProVision Plus (Progress 9.x)
  •         Provision Development Server
  •         Provision Plus Development Server
  •         Secure AppServer
  •         SQL-92 Client Access (Typical Install will provide the ODBC Drivers).
  •         WebSpeed Development Server
  •         WebSpeed Enterprise Transaction Server
  •         WebSpeed Transaction Server
  •         Workgroup Database
  •         OpenEdge Studio (OpenEdge 10.x, 11.x)
  •         Progress Development Studio OE (OpenEdge 11.x)
  •         OpenEdge Architect (OpenEdge 10.x)

 

Workaround
Notes
Attachment 
Last Modified Date6/17/2019 8:56 AM