Hi,
I am creating a linked server on my SQL 2008 on a server with MS Office 2007 installed. I ran the following :
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver @server = N'ACCESS', @srvproduct=N'access', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'\\blmcik\AccesQuery\SwitchDatabases\switch measures.accdb'
GO
USE [master]
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ACCESS', @locallogin = NULL , @useself = N'False'
GO
And I get the connection error saying:
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "Access". (Microsoft SQL Server, error: 7302)
I also ran the following with no success:
USE [master]
GO
EXEC master . dbo. sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1
GO
EXEC master . dbo. sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1
GO
Linked Server Access 2007
Posted - 11/08/2012 : 15:23:19
