Progress KB - Which data sources does Progress Dataserver for ODBC support?




Feedback
Did this article resolve your question/issue?

   

Article

Which data sources does Progress Dataserver for ODBC support?

« Go Back

Information

 
TitleWhich data sources does Progress Dataserver for ODBC support?
URL Name18240
Article Number000125944
EnvironmentProduct: OpenEdge
Version 10.x, 11.x
Product: Progress
Version: 7.x, 8.x, 9.x
Product: Webspeed
Version: 3.x
OS: All supported platforms
Other: DataServer for ODBC
Question/Problem Description
Which Foreign Data Sources does Progress ODBC DataServer Support?
Which Database does Progress ODBC DataServer Support?
Which Databases are Supported for a connection through 'Progress ODBC DataServer'
Which Database does OpenEdge DataServer for ODBC Support?
Is it possible to directly access a FireBird or InterBase Database via 4GL?
Is the FireBird Database supported by ODBC DataServer?
Is the InterBase Database supported by ODBC DataServer?
Does the OpenEdge ODBC DataServer support Informix?
Can OpenEdge ODBC DataServer support Sybase?
Will OpenEdge ODBC DataServer work with DB2?
Does the OpenEdge ODBC DataServer support DB2/400 (IBM's AS/400)
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
Progress 7.x supports access via the Progress ODBC DataServers to:

- Informix OnLine.
- Microsoft Access.
- Borland Paradox.
- DBase4.

Progress 8.x supports access via the PROGRESS ODBC DataServers to:

- Informix OnLine.
- Microsoft Access.

NOTE: The other data sources mentioned in the Progress manual "DataServer for ODBC guide" are not supported.

WebSpeed 2.1, supports access via the Progress ODBC DataServers to:

- Informix OnLine.
- DB2/MVS.
- Sybase System 11.
- MS SQL Server V6.5.
- MS-Access.

Progress 9.x / WebSpeed 3.x supports access via the Dataserver for ODBC to:

- DB2/NT.
- DB2/6000.
- DB2/MVS.
- Informix Online.
- MS-Access.
- MS SQL Server V6.5.
- MS SQL Server V7 (starting in 9.0B).
- Sybase.

OpenEdge 10.0x supports access via the Dataserver for ODBC to:

- DB2
- DB2/400 (IBM's AS/400v5R1)
- Informix
- Sybase

OpenEdge 10.1x and 10.2x supports access via the Dataserver for ODBC to:

- DB2
- DB2/400 (IBM's AS/400v5R1)
- Sybase


OpenEdge 11.x  supports access via the Dataserver for ODBC to:

- DB2
- DB2/400 (IBM's AS/400v5R1)
- Sybase
Workaround
Notes
References to other documentation:

DataServer for ODBC Guide (Progress 7.x, 8.x, 9.x)
Progress 9.1x DataServer for MS SQL Server Guide
OpenEdge Data Management: DataServer for ODBC
OpenEdge Data Management: DataServer for MicroSoft SQL Server
Progress 9 Product Availability Guide
OpenEdge 10 Product Availability Guide
OpenEdge 11 Product Availability Guide

Progress Article(s):
000021678, "Where is the OpenEdge Product Availability and Life Cycle Guide?"
000030208, "Progress Support for Accessing Microsoft SQL Server 2000"
000030207, "Which Progress Product(s) supports Microsoft SQL Server 7 ?"
000020513, "How the OpenEdge Release 10.x ODBC DataServer works with AS/400 DB2 Database?"
000021243, "Error during schema pull using ODBC DataServer from MySQL database"
000001632, "ODBC & ADO (ActiveX Data Object) access from Progress 4GL
000020973, "Can I connect to PostgreSQL from Progress ODBC dataserver?"
000030209, "Does Progress have any plans to provide support for FireBird or InterBase Databases with the Progress OpenEdge ODBC DataServer?"

AS/400 DataServer is no longer supported, as it was retired in 2004 with release 9.1C, However, support for AS/400 can found under the ODBC DataServer, however the last certified version was AS/400v5R4.  AS/400v6R1 and AS/400v7R1 have not been and there are no plans to certify them.

MS Access datasource is no longer supported, however loegacy support remains and the , "MS Access" option is still present when it comes to selecting a foreign datasource in the ODBC Dataserver migration utility in OpenEdge 10.x and later releases. By design, the ODBC DataServer design is supposed to be open to any target whether it is "supported" or not. The documentation will be updated to provide better guidance regarding this unsupported datasource and limitations when it comes to legacy support (PSC00345775).


 
Last Modified Date3/9/2016 9:33 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.