Connecting to a database using OLE DB

OLE DB uses the Component Object Model (COM) to make data from a variety of sources available to applications. Relational databases are among the classes of data sources that you can access through OLE DB.

This section describes how to connect to a SQL Anywhere database using OLE DB from the following environments:

  • Microsoft ActiveX Data Objects (ADO) provides a programming interface for OLE DB data sources. You can access SQL Anywhere from programming tools such as Microsoft Visual Basic.
  • Sybase PowerBuilder can access OLE DB data sources, and you can use SQL Anywhere as a PowerBuilder OLE DB database profile.

This section is an introduction to how to use OLE DB from Sybase PowerBuilder and Microsoft ADO environments such as Visual Basic. It is not complete documentation on how to program using ADO or OLE DB. The primary source of information about development topics is your development tool documentation.

See also

OLE DB providers
Connecting from ADO

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0