Oracle uses HS ODBC connection mssql2008

1. Create ODBC

2. Copy the INITDG4ODBC under product\11.2.0\dbhome_1\hs\admin\ and change the name to Initcrmsql (the name of the ODBC created by init+)

Hs_fds_connect_info =crmsql #odbc名称HS_FDS_TRACE_LEVEL = 0hs_fds_recovery_account=sa  #要连接的数据库名称HS_FDS_RECOVERY_ pwd=123456  #要连接的数据密码

3. Configure Product\11.2.0\dbhome_1\network\admin folder under Listener, add

Sid_list_listener =  (sid_list = (    Sid_desc =      (sid_name = Clrextproc)      (oracle_home = E:\app\ Administrator\product\11.2.0\dbhome_1)      (program = extproc)      (Envs = "Extproc_dlls=only:e:\app\administrator \product\11.2.0\dbhome_1\bin\oraclr11.dll ")    )    # Increase Start     (Sid_desc =      (sid_name = crmsql)      (oracle_ HOME = E:\app\Administrator\product\11.2.0\dbhome_1)      (program =dg4odbc)     # Add end  )

　　

Add in TNSNames file

Crmsql= (description=    (address= (protocol=tcp) (host= 192.168.2.4) (port=1521) (connect_data=) (Sid=crmsql    ))    (Hs=ok)  )

3. Restart the Oracle listener.

4. Open SQL Plus to enter a continuous Oracle username and account.

Create public database link Crmsql  connect to SA indentified by "123456"  using ' crmsql ';

5. Verification

　　

Oracle uses HS ODBC connection mssql2008