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