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

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

    Note: The OLEDB model depends on the installed drivers.

    Connect to an OLEDB 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 OleDb Provider.
      Report Data Source Dailog - OLEDB Data Source
    4. In the Connection Properties tab, specify the OLE DB Provider you want to use to connect to the data source.    
    5. To specify the Path of the file, click the Browse button and navigate to the desired folder on your system. For example, you can connect to the 'NWIND.mdb' sample data source which can be downloaded from GitHub.

      The Connection String tab displays the generated connection string as shown below:
      provider=Microsoft.Jet.OLEDB.4.0;data source=C:\NWIND.mdb;

      For more information, see the next section on 'Configuration Settings for OLEDB Data Source'.
    6. Click the Validate DataSource icon to verify the connection string. See Report Data Source dialog properties to learn about the properties available in the Credentials page of the dialog.
    7.  Click OK to close the Report Data Source dialog. Your report is now connected to the OLEDB data source successfully.

    Configuration Settings for OLEDB Data Source

    The OLEDB Data Provider provides the following configuration settings under the Connection section in the Report Data Source dialog. Based on the defined configuration settings, the OLEDB connection string is generated in the Connection String tab. 

    The Connection Properties tab gives access to properties specific to the following data types.

    Setting Description Example
    OLE DB Provider

    Choose which OLE DB Provider you want to use for the data source connection.

    You need to be selective in the choice of the provider. For example, Microsoft.Jet.OLEDB.4.0 is not supported in 64 bit OS while Microsoft.ACE.OLEDB.12.0 is supported.  

    See Troubleshooting article if an exception occurs on previewing reports connecting Microsoft Access OLE DB provider in a 64-bit system.

    Enter a server or file name Enter a server or a file name along with its location. C://NWIND.mdb
    Log on to server Select whether to use Windows NT integrated security or a specific user name and password. Check the Use Windows NT integrated security option

    Advanced Settings for Provider-Specific Connection Parameters

    The Advanced Settings tab gives access to the Microsoft Jet OLEDB provider-specific connection parameters.

    Setting Description
    Jet OLEDB: Compact Reclaimed Space Amount Indicates an estimate of the amount of space, in bytes, that can be reclaimed by compacting the database. This value is only valid after a database connection has been established.
    Jet OLEDB: Connection Control Indicates whether users can connect to the database.
    Jet OLEDB: Create System Database Indicates whether to create a system database when creating a new data source.
    Jet OLEDB: Database Locking Mode Indicates the locking mode for this database. The first user to open the database determines what mode to use when the database is open.
    Jet OLEDB: Database Password Indicates the database password.
    Jet OLEDB: Don't Copy Locale on Compact Indicates whether the Jet should copy locale information when compacting a database.
    Jet OLEDB: Encrypt Database Indicates whether a compacted database should be encrypted. If this property is not set, the compacted database will be encrypted if the original database was encrypted.
    Jet OLEDB: Engine Type Indicates the storage engine to access the current data store.
    Jet OLEDB: Exclusive Async Delay Indicates the maximum length of time, in milliseconds, that the Jet can delay asynchronous writes to disk when the database is opened exclusively. This property is ignored unless Jet OLEDB: Flush Transaction Timeout is set to 0.
    Jet OLEDB: Flush Transaction Timeout Indicates the amount of time before data stored in a cache for asynchronous writing is actually written to disk. This setting overrides the values for Jet OLEDB:Shared Async Delay and jet OLEDB: Exclusive Async Delay.
    Jet OLEDB: Global Bulk Transactions Indicates whether the SQL bulk transactions are transacted.
    Jet OLEDB: Global Partial Bulk Ops Indicates the password to open the database.
    Jet OLEDB: Implicit Commit Sync Indicates whether the changes made in internal implicit transactions are written in synchronous or asynchronous mode.
    Jet OLEDB: Lock Delay Indicates the number of milliseconds before attempting to acquire a lock after a previous attempt has failed.
    Jet OLEDB: Lock Retry Indicates the frequency of attempts to access a locked page.
    Jet OLEDB: Max Buffer Size Indicates the maximum amount of memory, in kilobytes, the Jet can use before it starts flushing changes to disk.
    Jet OLEDB: MaxLocksPerFile Indicates the maximum number of locks the Jet can place on a database. The default value is 9500.
    Jet OLEDB: New Database Password Indicates the new password for this database. The old password is stored in Jet OLEDB: Database Password.
    Jet OLEDB: ODBC Command Time Out Indicates the number of milliseconds before a remote ODBC query from the Jet will timeout.
    Jet OLEDB: Page Locks to Table Lock Indicates how many pages to lock within a transaction before the Jet attempts to promote the lock to a table lock. If this value is 0, then the lock is never promoted.
    Jet OLEDB: Page Timeout Indicates the number of milliseconds before the Jet will check if its cache is out of date with the database file.
    Jet OLEDB: Recycle Long-Valued Pages Indicates whether the Jet should aggressively try to reclaim BLOB pages when they are freed.
    Jet OLEDB: Registry Path Indicates the Windows registry key that contains values for the Jet database engine.
    Jet OLEDB: Reset ISAM Stats Indicates whether the schema Recordset DBSCHEMA_JETOLEDB_ISAMSTATS should reset its performance counters after returning performance information.
    Jet OLEDB: Shared Async Delay Indicates the maximum amount of time, in milliseconds, the Jet can delay asynchronous writes to disk when the database is opened in the multi-user mode.
    Jet OLEDB: System Database Indicates the path and file name for the workgroup information file (system database).
    Jet OLEDB: Transaction Commit Mode Indicates whether the Jet writes data to disk synchronously or asynchronously when a transaction is committed.
    Jet OLEDB: User Commit Sync Indicates whether changes made in transactions are written in the synchronous or the asynchronous mode.