<BLOCKQUOTE><font size="1" face="Arial, Verdana">quote:</font><HR>Originally posted by progresstalk:
The Progress ODBC Enterprise Dataserver is used to connect to external ODBC
data sources
> Like MS SQL Server or DB/2 or MS Access
from with in Progress.
Progress 9.1A Enterprise Database will
ship with Merant's 3.5 Progress Driver that is used to talk to a Progress Database via the SQL 92 Engine from an external source. There is continual confusion about how the ODBC Dataserver is used and the Enterprise Database.
I couldn't let this slip.
<HR></BLOCKQUOTE>
Colleagues,
We are using Progress Data servers to let Progress 4GL code communicate with non-progress data sources Oracle, MS SQL Server, DB/2, Sybase, Ms Access, etc. Some of them like Oracle data server are using a OCI libraries to connect to the data source directly. The most common interface is introduced by Microsoft and known as ODBC. When we are running a data source from Microsoft (Access or SQL Server) even selection of Merant driver will execute Microsoft's dll. And performance, features and operation will be result of Microsoft operation. That is Progress 4GL to non Progress RDBMS configuration.
If there is a need to communicate Progress RDBMS with non Progress application like Crystal Reports or Actuate that the Merant' (or other vendors like OpenLink and SCO in some instances) product prerogative. These drivers allow user to send requests to Progress RDBMS Engine using SQL statements (in ANSI standards like ANSI SQL-89 or ANSI SQL-92). I hope that helps. Your comments questions are welcome.
Andrey Vegger
anvegger@diligentsys.com