Thursday, March 5, 2015

Smart SQL Setup for Oracle - Datacap 8.1

  • Install Oracle client tools
  • Create folder if does not exists C:\app\<<UserId>>\product\11.2.0\client_1\network\admin
  • Copy  tnsnames.ora file to above folder with appropriate connection values.
  • Create TNS_ADMIN environment system variable and point to  C:\app\<<UserId>>\product\11.2.0\client_1\network\admin\
  • Create Oracle System DSN:
    • Open C:\Windows\SysWOW64\odbcad32.exe in Administrator mode.
    • Select “System DSN” tab.
    • Click on “Add” button.
    • Select “Oracle in OraClient11g_home1” driver

    • Enter required input values.
    • Click on “Test Connection” button. It would prompt for password.

  • Create DataSource in "Taskmaster Application Manager"
    • Click “Add New” in “Datasource Connection String Values in Taskmaster Format” section.
    • Enter required values in Connection String editor popup window.

  • Implement SmartSQL in Datacap model.

No comments:

Post a Comment