. . . . . . . "
    \n
  1. \n Prerequisites:\n
      \n
    • You MUST be proficient in using a Unix shell.
      • \n
    • You MUST be proficient in using a Unix editor such as vi.
      • \n
    • You MUST be in possession of relevant database connectivity details such as Database name, Username, password, etc.
      • \n
    \n
    2. \n
  2. \n Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi.\n
    3. \n
  3. \n Locate and edit the sample OpenLink PostgreSQL ODBC data source (DSN) created during the installation process and edit as follows:\n 
    \n      [postgres]\n      Driver            = <OPENLINK_INSTALL>/lib/pgr7_mt_lt.so\n      ServerType        = PostgreSQL\n      Options           = -H postgres.hostname\n      Database          = database\n      Username          = postgres\n      Password          =\n      FetchBufferSize   = 99\n      ReadOnly          = no\n      DeferLongFetch    = no\n      JetFix            = no\n      Description       = Sample PostgreSQL Lite Connection\n
    \n
    4. \n
  4. \n To test your data source, use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows:\n 
    \n      # cd <OPENLINK_INSTALL>\n      # . ./openLink.sh\n      # iodbctest postgres\n
    \n
    \n iODBC Demonstration program
    \n This program shows an interactive SQL processor
    \n Driver Manager: 03.52.0507.0105
    \n Driver: 06.02.1217 OpenLink Generic ODBC Driver (pgr7_mt_lt.so)
    \n
    \n SQL>\n
    \n
    5. \n
  5. \n You should now be able to issue SQL statements directly against the target database.\n
    6. \n
\n

\n Additional Notes:
\n The bitness of the ODBC Driver for PostgreSQL is determined by the bitness of your ODBC client application.
\n That is, if your ODBC client application is 32-bit then the Generic ODBC Driver component MUST also be 32-bit.\n

" . . . . . "Data Source Name Configuration Guide" . . . "OpenLink ODBC Driver for PostgreSQL (Lite Edition) Installation and Configuration" . "OpenLink ODBC Driver for PostgreSQL (Lite Edition) Configuration" . . . . . . . "OpenLink ODBC Driver for PostgreSQL (Lite Edition) Installation and Configuration" . . "
    \r\n
  1. \r\n Prerequisites:\r\n
      \r\n
    • You MUST be proficient in using a Unix shell.
      • \r\n
    • You MUST be proficient in using a Unix editor such as vi.
      • \r\n
    • You MUST be in possession of relevant database connectivity details such as Database name, Username, password, etc.
      • \r\n
    \r\n
    2. \r\n
  2. \r\n Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi.\r\n
    3. \r\n
  3. \r\n Locate and edit the sample OpenLink PostgreSQL ODBC data source (DSN) created during the installation process and edit as follows:\r\n 
    \r\n      [postgres]\r\n      Driver            = <OPENLINK_INSTALL>/lib/pgr7_mt_lt.so\r\n      ServerType        = PostgreSQL\r\n      Options           = -H postgres.hostname\r\n      Database          = database\r\n      Username          = postgres\r\n      Password          =\r\n      FetchBufferSize   = 99\r\n      ReadOnly          = no\r\n      DeferLongFetch    = no\r\n      JetFix            = no\r\n      Description       = Sample PostgreSQL Lite Connection\r\n
    \r\n
    4. \r\n
  4. \r\n To test your data source, use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows:\r\n 
    \r\n      # cd <OPENLINK_INSTALL>\r\n      # . ./openLink.sh\r\n      # iodbctest postgres\r\n
    \r\n
    \r\n iODBC Demonstration program
    \r\n This program shows an interactive SQL processor
    \r\n Driver Manager: 03.52.0507.0105
    \r\n Driver: 06.02.1217 OpenLink Generic ODBC Driver (pgr7_mt_lt.so)
    \r\n
    \r\n SQL>\r\n
    \r\n
    5. \r\n
  5. \r\n You should now be able to issue SQL statements directly against the target database.\r\n
    6. \r\n
\r\n

\r\n Additional Notes:
\r\n The bitness of the ODBC Driver for PostgreSQL is determined by the bitness of your ODBC client application.
\r\n That is, if your ODBC client application is 32-bit then the Generic ODBC Driver component MUST also be 32-bit.\r\n

" . . . . "OpenLink ODBC Driver for PostgreSQL (Lite Edition) Configuration" . . . . . .