Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Programming » OLE DB and ADO development


OLE DB is a data access model from Microsoft. It uses the Component Object Model (COM) interfaces and, unlike ODBC, OLE DB does not assume that the data source uses a SQL query processor.

An OLE DB provider, named SAOLEDB, is included with the software. This provider is available for supported Windows platforms.

You can also access a database using the Microsoft OLE DB Provider for ODBC (MSDASQL), together with the ODBC driver included with SQL Anywhere.

Using SAOLEDB instead of MSDASQL has several benefits:

  • Some features, such as updating through a cursor, are not available using the OLE DB/ODBC bridge.

  • If you use the OLE DB provider, ODBC is not required in your deployment.

  • MSDASQL allows OLE DB clients to work with any ODBC driver, but does not guarantee that you can use the full range of functionality of each ODBC driver. Using SAOLEDB, you can get full access to database software features from OLE DB programming environments.