Linked server from from the Access database in SQL server 2005

  • I try to execute linked server first from my local system i have sql server 2005 and i bring database access and put it in this path 'D:\SHARED HOM\Hom.mdb' in my local system and i use provider Microsoft jet oledb.4.0 because database i bring created to version before 2010

    then i write this code in query analyses

    exec sp_addlinkedserver @server='DATTA6',

    @srvproduct='ACCESS',

    @provider='Microsoft Jet OLEDB.4.0',

    @datasrc='D:\SHARED HOM\Hom.mdb'

    exec sp_addlinkedsrvlogin

    @rmtsrvname = 'DATTA6',

    @useself = 'false',

    @locallogin = null,

    @rmtuser = 'Admin',

    @rmtpassword = null

    To test i use below query

    SELECT * FROM OPENQUERY(DATTA6, 'SELECT * FROM CityDirectory')

    then after this message below error show to me why

    Msg 7403, Level 16, State 1, Line 1

    The OLE DB provider "Microsoft Jet OLE DB.4.0" has not been registered.

    why it give me this error

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply