Feedback
Did this article resolve your question/issue?

   

Article

OpenEdge 11.7 can no longer connect to an ODBC database source

Information

 
TitleOpenEdge 11.7 can no longer connect to an ODBC database source
URL Name11-7-can-no-longer-connect-to-an-ODBC-database-source-19027
Article Number000112617
EnvironmentProduct: OpenEdge
Version: 11.7 and later
OS: Windows
Other: ODBC DataServer
Question/Problem Description
How to connect to an ODBC DataServer when migrating to OpenEdge 11.7
OpenEdge 11.7 can no longer connect to an ODBC database source 
There is no ODBC DataServer available in version 11.7
Starting with OpenEdge 11.7, the OpenEdge DataServer for ODBC is retired.
In OpenEdge 11.7 am ODBC DataServer desupport check ensures that an ODBC connection cannot access the Server with the 19027 and 6142 messages.
Steps to Reproduce
Clarifying Information
Error MessageLicense of ODBC DataServer cannot be obtained due to product retirement (19027)
Failed to connect to the ODBC database (6142)
Defect/Enhancement Number
Cause
Resolution
While the ODBC Dataserver, has been discontinued in OpenEdge 11.7, conditional backwards compatibility will allow the ODBC DataServer from 11.6 to be used by the 11.7 client to connect to it via a DataServer Broker connection (not a local connection). For further information refer to the following Article: You will need an OpenEdge 11.6 ODBC DataServer license installed.  Start a command-line broker then connect through that to the external database source
$   _probrkr -H localhost -S probrkrPort
$   -db schemaHolder -RO -db odbcDSN -ld MSAccess -dt ODBC(?) -H localhost -S probrkrPort -U -P

Alternatively, use the Unified Broker (ODBMAN) / autostart with the AdminService:
$   odbman -name <broker-name> [-start / stop / query]
Workaround
Notes
Last Modified Date9/11/2020 8:14 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.