Creating an instance of OLE DB Provider " Microsoft.jet - OLEDB.4.0" for linked server "SNE_SNAP2014"


  • Msg 7302, Level 16, State 1, Line 2
    Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "SNE_SNAP2014".

    Below is a script to export data from access 2003 using SQL server 2012 in SQL server management studio.

    USE IDS_Snaps
    --- EXEC sp_dropserver 'SNE_SNAP2014'
    EXEC sp_addlinkedserver 
       @server = 'SNE_SNAP2014', 
       @provider = 'Microsoft.Jet.OLEDB.4.0', 
       @srvproduct = 'OLE DB Provider for Jet',
       @datasrc = 'T:\Data Management\Project -SNAP SNE\SNE SNAP2014 T-Drive.mdb'
    Print '======== Done with  Connection ==========='
    DELETE FROM dbo.tbl_Learner_Age_SNESnap WHERE DataYear = 2014
    INSERT INTO dbo.tbl_Learner_Age_SNESnap(NATEmis, DataYear, AgeCD, GenderCD, GradeCD, Quantity, TransactDate)
    SELECT NATEmis, DataYear, AgeCD, GenderCD, GradeCD, data, DataTime FROM
    OPENQUERY(SNE_SNAP2014, 'SELECT NATEmis, DataYear, AgeCD, GenderCD, GradeCD, SUM(Quantity) AS DATA, Now() AS DataTime
    FROM tbl_Learner_Age
    WHERE DataYear = 2014 AND NatEMIS Is Not Null AND NatEMIS <> 0
    GROUP BY NATEmis, DataYear, AgeCD, GenderCD, GradeCD')
    Print '======== Done with  Learner AGE Information ==========='

    I experience the above error messsage. Please help?

    Friday, April 10, 2015 1:31 PM


All replies