在Windows配置DSN

  1. 确认InterSystems ODBC客户端驱动已安装
  2. 定义DSN(Data Source Names)

     

在Linux配置DSN

  1. 确认InterSystems ODBC客户端驱动已安装
  2. 配置DSN - 根据InterSystems IRIS服务器修改odbcinst.ini文件的配置信息
    [ODBC Data Sources]
    User = User
    Userunixodbc = Userunixodbc
    ​
    [User]
    Driver          = /isc/iris/bin/libirisodbc35.so
    Description     = IRIS ODBC driver
    Host            = localhost
    Namespace       = IRISAPP
    UID             = username
    Password        = pws
    Port            = 51773
    Protocol        = TCP
    Query Timeout   = 1
    Static Cursors  = 0
    Trace           = off
    TraceFile       = iodbctrace.log
    Authentication Method   = 0
    Security Level  = 2
    Service Principal Name = iris/localhost.domain.com
    ​
    [Userunixodbc]
    Driver          = /isc/iris/bin/libirisodbcur6435.so
    Description     = IRIS ODBC driver
    Host            = localhost
    Namespace       = IRISAPP
    UID             = username
    Password        = pws
    Port            = 51773
    Protocol        = TCP
    Query Timeout   = 1
    Static Cursors  = 0
    Trace           = off
    TraceFile       = iodbctrace.log
    Authentication Method   = 0
    Security Level  = 2
    Service Principal Name = iris/localhost.domain.com