I'm testing ODBC driver for Ms CRM with :
- Windows 2016 server
- SQL Server 13.0.1728.2
- CRM Online
- Devart ODBC driver 1.01.03.00
- an Oracle OLE DB Provider and the Microsoft.ACE.OLEDB12.0 provider are also installed
- No problem with the ODBC settings, successfully connected
- The linked server does not work if 'allow inprocess'
- I'm not able to expand the catalog :
- querying CRM Online table directly works using a selectCannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDASQL" for linked server "CRM 365". The provider supports the interface, but returns a failure code when it is used. (Microsoft SQL Server, Error: 7311)