none
OLEDB PROVIDER MICROSOFT.ACE.OLEDB.12.0 FOR AQL SERVER 2005 RRS feed

  • Domanda

  • HI at all!
    I have this T-SQL statement : "SELECT * into #tbltemp
    FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0', 'Data Source=C:\CFF.accdb')...[T_prodotti] "
    I have this error " OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode."
    I note that in the SSMS Server > Server Objects > Linked Servers > Providers folder I don't have the "MICROSOFT.ACE.OLEDB.12.0".
    Could anyone help me, please ?

    Antonio 


    • Spostato Valter MinuteMVP martedì 12 gennaio 2010 15:57 This thread is about SQL server 2005 and not Windows Embedded (unless the problem is specific for Windows Embedded Standard/XPE, but the O.P. forgot to specify that, then) (Da:Microsoft Windows Embedded Forum)
    martedì 12 gennaio 2010 08:04