Hello Friends,
If you face the error like below while use "OpenRowset" in Sql server 2008 using the 32 bit Operation system.
Error :
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
Than follow the below steps :
1) Go to the SQL Server Management studio --> Server Objects--> Linked Server --> Providers --> Microsoft.ACE.OLEDB.12.0
2) Right click on "Microsoft.ACE.OLEDB.12.0" and goes to Properties --> Uncheck the checkbox of "Allow in Process".
Please note this solution is for 32 bit operating system. :)
Regards
Jignesh Patel
