How to connect Microsoft Jet 4.0 oledb provider to SSRS?

Question

Hello,

I have SQL server 2008 on my server and i want to connect the access db in order to access the Two databases at the same time.

I have tried using the OLEDB connection string , but was not able to connect.

Please can anyone assist me ?

Thanks

Kalwa

Answer 1

I have tried using the OLEDB connection string , but was not able to connect.

Hello Kalwa,

And which error message do you get?

See http://www.connectionstrings.com/access-2007#p84  for connections strings for OleDB Provider for MS Access.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hi Kalwa,

OLE DB is a data access technology that enables clients to connect a variety of data providers. After you select the data source type OLE DB, you must select a specific data provider. To include data from an OLE DB data provider, you must have a dataset that is based on a report data source of type OLE DB.

The connection string for OLE DB data processing extension depends on the data provider that you want, A typical connection string contains name/value pairs that supported by the data provider, for example:
Provider=SQLNCLI10.1;Data Source=server; Initial Catalog=AdventureWorks

For more information about OLE DB Connection, please see:
http://msdn.microsoft.com/en-us/library/dd239343.aspx

Regards,
Charlie Liao