ActiveReports 17 .NET Edition
Report Authors: Designer Components / Data Binding / Data Binding in Page/RDL Reports / Connect to a Data Source / Microsoft ODBC Provider
In This Topic
    Microsoft ODBC Provider
    In This Topic

    This article explains connecting a Page or an RDL report to an ODBC data source.

    Note: The ODBC model depends on the installed drivers.

    Connect to an ODBC Data Source

    1. In the designer, go to the Report Explorer, right-click the Data Sources node and select the Add Data Source option or click the Add button and then select the Data Source option.
    2. In the Report Data Source dialog that appears, select the General page and enter the name of the data source in the Name field. By default, the data source name is set to DataSource1. This name appears as a child node to the Data Sources node in the Report Explorer.
    3. Under the Type field, select Microsoft Odbc Provider.
      Report Data Source Dialog - Microsoft ODBC Provider
    4. On the same page under the Connection section, enter the connection string to connect to an ODBC data source. The following sample connection string specifies the type of the ODBC Driver along with location of the file required for an ODBC data source connection.
      For example, you can connect to the NWIND.mdb sample data source which can be downloaded from GitHub.

      Driver=Microsoft Access Driver (*.mdb);Dbq=C:\NWIND.mdb;

      For more information about the Credentials page in the Report Data Source dialog, see Report Data Source dialog properties.
    5. Click OK to save the changes and close the Report Data Source dialog box.