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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy