Microsoft OLEDB Provider

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

type=note
Note: The OLEDB model depends on the installed drivers.

Connect to an OLEDB Data Source

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.
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.
Under the Type field, select Microsoft OleDb Provider.
In the Connection Properties tab, specify the OLE DB Provider you want to use to connect to the data source.
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'.
Click the Validate DataSource icon to verify the connection string. See Connect to a Data Source to learn about the properties available in the Credentials page of the dialog.
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.	Microsoft.Jet.OLEDB.4.0
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.