Please enable JavaScript to view this site.

Altova StyleVision 2021 Professional Edition

Microsoft ActiveX Data Objects (ADO) is a data access technology that enables you to connect to a variety of data sources through OLE DB. OLE DB is an alternative interface to ODBC or JDBC; it provides uniform access to data in a COM (Component Object Model) environment. ADO is the typical choice for connecting to Microsoft native databases such as Microsoft Access or SQL Server, although you can also use it for other data sources.

To set up an ADO connection:

1.Start the database connection wizard.

2.Click ADO Connections.


3.Click Build.


4.Select the data provider through which you want to connect. The table below lists a few common scenarios.

To connect to this database...

Use this provider...

Microsoft Access

Microsoft Office Access Database Engine OLE DB Provider


When connecting to Microsoft Access 2003, you can also use the Microsoft Jet OLE DB Provider.

SQL Server

SQL Server Native Client

Microsoft OLE DB Provider for SQL Server

Other database

Select the provider applicable to your database.


If an OLE DB provider to your database is not available, install the required driver from the database vendor (see Database Drivers Overview ). Alternatively, set up an ODBC or JDBC connection.


If the operating system has an ODBC driver to the required database, you can also use the Microsoft OLE DB Provider for ODBC Drivers.

5.Click Next and complete the wizard.


The subsequent wizard steps are specific to the provider you chose. For SQL Server, you will need to provide or select the host name of the database server, as well as the database username and password. For Microsoft Access, you will be asked to browse for or provide the path to the database file.


The complete list of initialization properties (connection parameters) is available in the All tab of the connection dialog box—these properties vary depending on the chosen provider. The following sections provide guidance on configuring the basic initialization properties for Microsoft Access and SQL Server databases:


Setting up the SQL Server Data Link Properties

Setting up the Microsoft Access Data Link Properties

© 2020 Altova GmbH