locked
SQL Server 2012 - "Microsoft.ACE.OLEDB.12.0" error RRS feed

  • Question

  • I'm getting the following error in SQL 2012

    "Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "name".

    It's SQL 2012 on Server2012

    I've linked the server correctly
    I've installed MS Office on box
    I've installed MS Access Database Engine Drivers  (64bit)

    any help would be grealty appreciated. 
    thanks

    Wednesday, April 16, 2014 7:46 AM

Answers

  • Hi Visakh

    I followed the instructions in your blog post, and that seemed to do the trick - thanks Loads !
    However now I get a new error

    "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation."

    how do I resolve this ?

    Thanks in advance
    Pete

    • Marked as answer by Pete Repka Wednesday, April 16, 2014 8:51 AM
    Wednesday, April 16, 2014 8:15 AM

All replies

  • see if any of these helps

    http://visakhm.blogspot.in/2013/12/how-to-solve-microsoftaceoledb120-error.html

    followed by

    http://www.sqlservercentral.com/Forums/Topic564076-17-1.aspx


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, April 16, 2014 7:51 AM
    Answerer
  • Hi Visakh

    I followed the instructions in your blog post, and that seemed to do the trick - thanks Loads !
    However now I get a new error

    "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation."

    how do I resolve this ?

    Thanks in advance
    Pete

    • Marked as answer by Pete Repka Wednesday, April 16, 2014 8:51 AM
    Wednesday, April 16, 2014 8:15 AM
  • use COLLATE clause to override the collation. so place where you get error it would be mostly a comparison statement, just tweak it as below

    Column1 COLLATE database_default = Column2 COLLATE database_default

    add this in all places where you're comparing two character based fields ie datatype char,varchar etc


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, April 16, 2014 8:20 AM
    Answerer
  • Hi Visakh

    I followed the instructions in your blog post, and that seemed to do the trick - thanks Loads !
    However now I get a new error

    "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation."

    how do I resolve this ?

    Thanks in advance
    Pete

    If your original question is answered, I would appreciate if you could mark the relevant post as answered for others benefit.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, April 16, 2014 8:21 AM
    Answerer
  • Hi - i've done this. 

    Should i start a new thread for the subsequent "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation." error then ?


    Wednesday, April 16, 2014 8:52 AM