Msg 7301 Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "LinkToAceess"

While executing example given in my previous article, one ofthe reader faced an issue so he sent an email to me by complaining that he isfacing following error:
Msg 7399, Level 16,State 1, Procedure sp_tables_ex, Line 41
The OLE DB provider”Microsoft.ACE.OLEDB.12.0″ for linked server “LinkToAceess”reported an error. Access denied.
Msg 7301, Level 16,State 2, Procedure sp_tables_ex, Line 41
Cannot obtain therequired interface (“IID_IDBSchemaRowset”) from OLE DB provider”Microsoft.ACE.OLEDB.12.0″ for linked server”LinkToAceess”.
This is really very simple error regarding the setting ofthe provider you have used in your linked server. In our case, we have used “Microsoft.ACE.OLEDB.12.0” so we have to set theproperty of the same.
In your SSMS, go to “Object Explorer” and follow the belowpath:
Server->Server Objects->LinkedServer->Providers->Microsoft.Ace.Oledb.12.0
Right click on it and click on “property” from popup menu, thenset “Allow process” to true.
Click on “Ok” button and enjoy you OPENQUERY.
Reference: Ritesh Shah

http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: