Post reply

SQL Server 2008 R2 64 bit linked server problem

  • December 15, 2011 at 1:34 am

    #252149

    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

    #1421779

    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

    #1421793

    Yes, I did.

  • December 15, 2011 at 3:17 am

    #1421803

    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

    #1421810

    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

    #1480501

    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