topic Esri GeoDatabase OLE DB Provider as data source in SQL Server in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/esri-geodatabase-ole-db-provider-as-data-source-in/m-p/879622#M6666 <HTML><HEAD></HEAD><BODY><P>For some years now, I've noticed Microsoft SQL Server Management Studio has an option to import from an "Esri GeoDatabase OLE DB Provider."&nbsp; However, trying to look up properties or clicking next pops up an error saying that "ClassFactory cannot supply requested class (Microsoft OLEDB Service Components)."</P><P></P><P><IMG alt="SQL Server Import and Export Wizard - The operation could not be completed." class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/411454_Capture.PNG" /></P><P></P><P>I know we should do import/export through ArcCatalog, but I am just curious as to why this option appears in MS SSMS or maybe how to take advantage of it.</P><P></P><P>What little discussion there is on StackOverflow or MS forums seems to indicate it's not native to SSMS and was probably added by ArcMap installation.</P><P></P><P>Thanks,</P><P>Ryan</P></BODY></HTML> Thu, 14 Jun 2018 17:55:51 GMT RyanDavis1 2018-06-14T17:55:51Z Esri GeoDatabase OLE DB Provider as data source in SQL Server https://community.esri.com/t5/geodatabase-questions/esri-geodatabase-ole-db-provider-as-data-source-in/m-p/879622#M6666 <HTML><HEAD></HEAD><BODY><P>For some years now, I've noticed Microsoft SQL Server Management Studio has an option to import from an "Esri GeoDatabase OLE DB Provider."&nbsp; However, trying to look up properties or clicking next pops up an error saying that "ClassFactory cannot supply requested class (Microsoft OLEDB Service Components)."</P><P></P><P><IMG alt="SQL Server Import and Export Wizard - The operation could not be completed." class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/411454_Capture.PNG" /></P><P></P><P>I know we should do import/export through ArcCatalog, but I am just curious as to why this option appears in MS SSMS or maybe how to take advantage of it.</P><P></P><P>What little discussion there is on StackOverflow or MS forums seems to indicate it's not native to SSMS and was probably added by ArcMap installation.</P><P></P><P>Thanks,</P><P>Ryan</P></BODY></HTML> Thu, 14 Jun 2018 17:55:51 GMT https://community.esri.com/t5/geodatabase-questions/esri-geodatabase-ole-db-provider-as-data-source-in/m-p/879622#M6666 RyanDavis1 2018-06-14T17:55:51Z Re: Esri GeoDatabase OLE DB Provider as data source in SQL Server https://community.esri.com/t5/geodatabase-questions/esri-geodatabase-ole-db-provider-as-data-source-in/m-p/879623#M6667 <HTML><HEAD></HEAD><BODY><P>Just encountered this in Excel 2016 as an available OLE data source. Curious as to it's origination and usefulness and if we can use it to connect to file geodatabases.</P></BODY></HTML> Wed, 08 May 2019 22:27:40 GMT https://community.esri.com/t5/geodatabase-questions/esri-geodatabase-ole-db-provider-as-data-source-in/m-p/879623#M6667 ErikLash1 2019-05-08T22:27:40Z