Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Linked server from from the Access database in SQL server 2005 Expand / Collapse
Posted Friday, February 1, 2013 10:14 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 28, 2016 3:25 PM
Points: 46, Visits: 106
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',
@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
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

Post #1414907
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse