locked
How to connect Microsoft Jet 4.0 oledb provider to SSRS? RRS feed

  • 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

    Monday, August 13, 2012 3:08 PM

Answers

  • 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

    • Proposed as answer by Charlie Liao Friday, August 17, 2012 2:34 AM
    • Marked as answer by Charlie Liao Wednesday, August 22, 2012 1:02 AM
    Monday, August 13, 2012 4:33 PM
  • 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

    • Marked as answer by Charlie Liao Wednesday, August 22, 2012 1:02 AM
    Friday, August 17, 2012 2:34 AM

All replies

  • 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

    • Proposed as answer by Charlie Liao Friday, August 17, 2012 2:34 AM
    • Marked as answer by Charlie Liao Wednesday, August 22, 2012 1:02 AM
    Monday, August 13, 2012 4:33 PM
  • 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

    • Marked as answer by Charlie Liao Wednesday, August 22, 2012 1:02 AM
    Friday, August 17, 2012 2:34 AM