DataDirect Connect for ADO – OLE DB

DataDirect Connect for ADO is the premier suite of native OLE DB providers, enabling reliable, high-performance data connectivity for client/server and web-based applications on the Microsoft platform. Connect for ADO supports the latest OLE DB specification, providing data access across a broad range of client platforms and data sources, including XML. Connect for ADO is the industry's only suite of providers that includes a robust SQL optimizer for join capabilities and SQL access to non-SQL-based data stores.

Access to ALL Types of Data - Both SQL and Non-SQL

With DataDirect Connect for ADO, any ADO- enabled application can have direct access to leading relational databases such as Informix, Microsoft SQL Server, Oracle and Sybase, extending to non-relational data such as XML. This eliminates the complexity of supporting native proprietary interfaces, turning data connectivity components into reusable assets for distributed computing.

Quality, Reliability and Performance

Connect for ADO providers are rigorously tested and certified using the DataDirect Technologies Verification Suite, Microsoft LTM and leading OLE DB consumers such as Microsoft ADO, Visual Studio and Internet Information Server. Our extensive testing ensures maximum performance and connection reliability, thereby minimizing downtime and support costs. Optimized for high-volume, high-load environments, Connect for ADO data providers ensure high-performing, continuous connectivity for client, server or Web-based applications.

Most Advanced Functionality

As a close partner with Microsoft in the ongoing development of the ODBC and OLE DB specifications, the DNA framework and COM+, DataDirect Technologies is uniquely positioned to offer the most robust data connectivity available. Connect for ADO data providers deliver consistent access to the latest ADO/OLE DB specification and are constantly tuned and enhanced to fully support the latest database and operating system features. This assures that your data access technology keeps pace with your evolving business and customer needs.

Feature-rich OLE DB support

  • Provides pure ADO access for direct connectivity to industry-leading relational databases
  • Supports the latest DBMS versions including Informix 9, Microsoft SQL Server 7, Oracle8i, and Sybase Adaptive Server 12.5
  • Supports the latest operating systems such as Windows 2000
  • Strict adherence to the latest Microsoft OLE DB specification, including support for critical new features like session (connection) pooling
  • Certified with latest Microsoft OLE DB-enabled tools including ADO, Visual Basic, Visual InterDev, Internet Information Server and Visual Studio
  • Internet enabled through Microsoft IIS and Active Server Pages (ASP)

DataDirect Integrator ensures reliable SQL queries for all types of data

  • Connect for ADO includes Integrator, a query processor engine designed as an ADO service component, for full SQL-based processing of non-SQL data sources, including standard stored procedure calls
  • Delivers consistent and robust SQL functionality across all data stores
  • Delivers value-added services of global catalogs for user-friendly metadata, persistent views for reusable business logic and scrollable cursor capability for easy navigation across all types of data