![]() Enter the name of the project and select a color you like. Now you are ready to use the defined connection in your project.Ĭreate a new or open an existing project in SelectCompare. Use connection in your comparison project You can also test the connection in SelectCompare:Įnsure that you save the connection before you exit the screen. Select the ODBC connection that you created in the ODBC connection manager.Įnter username and password and click Test Connection.Ĭlick OK on the connection properties dialog. Select “ Microsoft ODBC Data Source” and select the provider displayed on the screenshot. Open SelectCompare and switch to the Connections screen.Ĭlick the "Create new connection" button:Įnter the name of the connection and choose its color. Set up Oracle connection in SelectCompareįinally, you are ready to set up a connection in SelectCompare. Click OK - you are ready to use the data source in SelectCompare! You should see the newly created data source on the main screen of the ODBC Data Source Administrator. Click OK.Ĭlick OK on the Oracle ODBC Driver Configuration screen. When everything is set up correctly, you should see a confirmation of the successful connection. Click "Test Connection"Įnter the user password when prompted and click OK: Click the "Finish" button.Įnter the name of the data source, any description you might find useful, the TNS service name, and the username. Select the appropriate driver from the list that will appear. Open ODBC Data Source Administrator (32-bit) and click the "Add" button. Note that you need to have your TNSNAMES.ORA file in working order. If everything went fine, you should see the confirmation of the successful installation of the driver on your workstation.įirst, we will start with the setup of the ODBC data source in the ODBC Data Source Manager. ![]() On the first screen, select the InstantClient option and click Next.įollow the installation process using default settings. An installation wizard will appear, guiding you through the process of installation. When the package is downloaded, run the setup.exe. Select the Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit) If you wonder how SelectCompare might be used with Oracle, have a look at the second use case from this post.ĭownload and install the Oracle ODBC driverįor this post, I chose the 32-bit InstantClient implementation of the driver. ![]() This post outlines the process of installation and configuration of the Oracle ODBC driver, setup of the ODBC data source, and configuration of a connection in SelectCompare. One of the most important database technologies on the market is undoubtedly Oracle and SelectCompare can use Oracle as a data source without any problems. SelectCompare can be used to fetch data from multiple data sources, as long as there is an OLEDB or ODBC driver available for them. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |