

This log is for troubleshooting you should not turn logging on during normal operation as it will dramatically slow down ODBC performance. If selected, specifies the creation of a log file of ODBC client driver activities for all InterSystems DSNs. For the default username, the password is SYS (must be all upper case).

Specifies the password to be used by the ODBC connection. By default, this is _SYSTEM (not case-sensitive). Specifies the username to be used by the ODBC connection. Service Principal Name - Specify the name of the server to be used as a Kerberos principal. For this option, also specify the following settings:Ĭonnection Security Level - Select Kerberos, Kerberos with Packet Integrity, or Kerberos with Encryption, as appropriate (see the Client/Server section of About Kerberos and the Access Modes). Kerberos - authenticate with Kerberos (see Kerberos Authentication). Password with SSL/TLS - authenticate using an SSL/TLS-protected connection (see TLS Guide). Password - authenticate with standard username and password. For detailed information on these options, see Authentication Guide. The following illustration shows an instance of the InterSystems ODBC Data Source Setup dialog box with all required fields filled in:Īuthentication Method - Select one of the following options, depending on the security used for this database. Select InterSystems IRIS ODBC for the ODBC 2.5 driver or InterSystems IRIS ODBC35 for the ODBC 3.5 driver, and click the Finish button. In the Windows ODBC Data Source Administrator dialog, select the User DSN tab and click the Add. In the Windows Control Panel, select Administrative Tools and click the ODBC Data Sources icon (the actual icon name may vary depending on your version of Windows see “ Selecting the Correct ODBC Data Source Administrator Version” below). To create a DSN, you can use the Windows ODBC Data Source Administrator to access the InterSystems ODBC Data Source Setup dialog box: Creating a DSN with the ODBC Data Source Administrator
Best odbc manager courses drivers#
If InterSystems IRIS is installed on the host you are working on, the driver is already installed if not, download the InterSystems ODBC driver from the InterSystems IRIS Drivers page Opens in a new tab and execute the downloaded file. To create a DSN for an InterSystems database, the InterSystems ODBC driver for Windows must be installed.
Best odbc manager courses how to#
This chapter describes how to create a DSN for an InterSystems database on Windows, which you can do either via the Control Panel or by creating a file DSN.

