In addition, different versions of the ODBC driver support. If the test does not succeed, review your settings. For details, see the individual installation and configuration instructions for each platform. If the test succeeds, click on the OK button to complete the configuration. Click the radio button 'User Data Sources' 7.

Click on the 'Machine Data Source' tab 5. Find the table in MS Access not in Oracle (make sure all the column names and table names are Upper Case) 2. The TNS Service Name (click on the drop down arrow and select from the list)Ĭlick on the Test Connection button and enter the Oracle user password to confirm that the details are correct. I created the Microsoft ODBC drivers for Oracle this way, 1.The 'Oracle ODBC Driver Configuration' dialog displays. Select 'Oracle in OraDB11g_home1' from the list (or similar, depending on the ODBC installation). The 'Create New Data Source' dialog displays, enabling you to add a new DSN. The ODBC Data Source Administrator window displays. You can quickly load the correct 32-bit ODBC Data Source Administrator by selecting the 'Configure > User Tools > ODBC Data Sources' ribbon option. In the search box, type troubleshooter, and then click Troubleshooting. sources such as Oracle, Microsoft SQL Server, and MySQL Community Edition as ODBC. Open the Program Compatibility troubleshooter by clicking the Start button, and then clicking Control Panel. Under both 32-bit and 64-bit operating systems, Enterprise Architect requires 32-bit ODBC drivers to connect to a repository through ODBC. Additionally, data source configuration can vary from one ODBC driver.

Microsoft odbc for oracle setup guide