December 15, 2011 at 1:34 am
Hello!
I created a Linked Server (named LS_DBF) on the SQL Server 2005 32-bit and this query is work: SELECT * FROM LS_DBF...tavszall
I created Linked Server (named LS_DBF) on the SQL Server 2008 R2 64 bit, then this query is not work: SELECT * FROM LS_DBF...tavszall
I'm sysadmin on both SQL servers, and I'm sysadmin on the windows servers.
What is the problem?
This is the Linked Server create script:
EXEC master.dbo.sp_addlinkedserver @server = N'LS_DBF', @srvproduct=N'Microsoft Jet', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'C:\adatbetoltesek\tavszall\betoltetni\dbf\', @provstr=N'dbase 5.0'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LS_DBF',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
This is the error message:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "LS_DBF" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "LS_DBF".
December 15, 2011 at 2:05 am
Did you install the 64-bit version of the ACE OLE DB provider?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 15, 2011 at 2:49 am
Yes, I did.
December 15, 2011 at 3:17 am
And you also used the same provider on SQL Server 2005? (The ACE OLE DB, not the JET provider)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 15, 2011 at 3:41 am
Hopp, i was wrong. SQL Server 2005 use Microsoft Jet 4.0 provider.
I looking for Microsoft Jet 4.0 provider on SQL Server 2008 x64 (or Windows Server 2008 x64) on the internet, but I can't find it.
Are there Microsoft Jet 4.0 provider on SQL Server 2008 x64 (or Windows Server 2008 x64)?
April 27, 2012 at 9:05 am
It's time to walk away from Jet 4.0. Setup your 64bit server to use Microsoft.ACE.OLEDB.12.0 too. Go to microsoft's download here grab and install the 64bit one: http://www.microsoft.com/en-us/downl...ng=en&id=13255 Refresh your provider list and it should be there. Works great.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply