Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, February 1, 2013 10:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 5, 2014 2:30 PM
Points: 24, Visits: 58
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

Post #1414907
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse