![]() You will see a new OLE DB connection object under Database Connections in the TOC. Verify the new connection by clicking Test Connection.Enter the Username and Password for connections that require them (Oracle, SQL Server, etc.) The DataLink Properties sheet (Connection tab) when using the Microsoft OLE DB Provider for ODBC. Add a valid RDBMS username and password in the appropriate boxes.The list may be different than this example, as proprietary and third-party OLE DB providers for other data sources may be installed on the machine being used. Microsoft OLE DB Providers are included with ArcGIS. On the first panel, make sure the Microsoft OLE DB provider for ODBC drivers is selected.Open up another search in the Start menu, and type ODBC Data Sources, and hit enter. The installation should still be complete. You won’t get a pop-up to confirm the process, but rest assured. Once the DSN is created, double-click the Add OLE DB connection option from within ArcCatalog or ArcMAP to call the Data Link Properties menu. Open the instantclient folder in your Oracle folder, and right-click odbcinstall.exe.Use an existing Oracle ODBC DSN (data source name) or set up a new Oracle ODBC DSN using the Windows Data Sources (ODBC) utility and an appropriate ODBC driver. ![]() Instructions provided are for making a connection to an Oracle database using the Microsoft OLE DB provider for ODBC drivers. ![]() How To: Use the Microsoft OLE DB provider for ODBC drivers to connect to an Oracle database Summary
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |