InterSystems provides a fully compliant (ODBC 3.5) ODBC driver, which you can use to access an InterSystems IRIS™ database via ODBC. The driver is installed by default when you install InterSystems IRIS — you simply need to configure it.
To use this procedure, you need a Windows systems with an installed instance of InterSystems IRIS.
Setting up ODBC on Windows
The instructions in this section assume that you have the InterSystems ODBC driver installed. By default, the standard InterSystems IRIS installation process installs the driver, so unless you performed a custom installation, the driver should be present on your instance.
To enable your applications to access an InterSystems IRIS database via ODBC, you need to create a DSN that defines the location of the database for the ODBC client driver. On Windows, you can do this from the Windows Control Panel, as follows:
Open the Windows Administrative Tools control panel.
Select Data Sources (ODBC).
On the User DSN tab, select Add.
Select InterSystems ODBC and click Finish.
The DSN is created, and the InterSystems ODBC Data Source Setup dialog box is shown.
Enter the necessary configuration details:
Enter a name and description for the DSN.
Enter the IP address, port number, and namespace corresponding to the InterSystems IRIS database that this DSN represents.
Select an authentication method, and enter or select other security information as appropriate for the InterSystems IRIS instance.
Select the Test Connection button to test that your setup is correct.
If the connection test was successful, congratulations! You have finished setting up your InterSystems IRIS database to use ODBC. Now you can modify your ODBC-aware applications to use the DSN that you just created.