Linked server from from the Access database in SQL server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Linked server from from the Access database...

Linked server from from the Access database in SQL server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

ahmed_elbarbary.2010

Posted Friday, February 01, 2013 10:14 PM

Grasshopper

Group: General Forum Members
Last Login: Saturday, April 13, 2013 4:01 PM
Points: 14, Visits: 32

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 »

Permissions