This article explains connecting a Page or an RDLX report to an OLEDB data source.
Note: The OLEDB model depends on the installed drivers.
provider=Microsoft.Jet.OLEDB.4.0;data source=C:\NWIND.mdb;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. |