{"id":2301,"date":"2014-12-18T19:31:30","date_gmt":"2014-12-18T19:31:30","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2301"},"modified":"2014-12-18T19:42:24","modified_gmt":"2014-12-18T19:42:24","slug":"odbc-front-page-database-connector","status":"publish","type":"post","link":"https:\/\/www.minisoft.com\/support\/odbc-front-page-database-connector\/","title":{"rendered":"ODBC Front Page Database Connector"},"content":{"rendered":"

The three basic files needed to get started are shown in the next sections. This sample provides instructions in creating a query form that can be used to retrieve information from your Image database using most browsers and Microsoft’s IIS (Internet Information Server) and FrontPage.<\/p>\n

Download this sample: HTTP<\/span><\/span><\/a><\/a><\/p>\n

The HTX file<\/strong><\/p>\n

    \n
  1. Create the results (.htx) page.<\/li>\n
  2. The field (Image Item) names appear in place of the <%name%> sequences in the result form<\/li>\n<\/ol>\n

    .\"ODBC_n08\"<\/a><\/p>\n

      \n
    1. Use the saved form when creating the (.idc) file.<\/li>\n<\/ol>\n
      \"ODBC_n05\"<\/div>\n
      \n

      <\/a>The IDC file<\/strong><\/p>\n

        \n
      1. Create an Internet Database Connector file using the wizard<\/li>\n<\/ol>\n

        \"ODBC_n04\"<\/p>\n

          \n
        1. Reference the DataSource that is configured on the server as a System DSN.<\/li>\n
        2. Enter the SQL statement for the query with a reference to the query form field that will be substituted in when the query is executed.<\/li>\n<\/ol>\n<\/ol>\n

          \"ODBC_n05\"<\/p>\n

            \n
          1. Assign a default value if needed<\/li>\n<\/ol>\n

            \"ODBC_n06\"<\/p>\n

            \n

            <\/a>The HTM file<\/strong><\/p>\n

              \n
            1. Create a page with a simple query form<\/li>\n<\/ol>\n

              \"ODBC_n09\"<\/p>\n

                \n
              1. Set ‘Internet Database Connector’ as the Form Handler type.\"ODBC_n02\"<\/a><\/li>\n
              2. Enter the name of an Internet Database Connector File:<\/li>\n

                \"ODBC_n03\"<\/p>\n

              3. Set the name and properties of the query form text box.<\/li>\n

                \"ODBC_n07\"\n<\/ol>\n

                \n

                \u00a0<\/a>How this sample appears:<\/strong><\/p>\n

                \"\"<\/p>\n

                \"ODBC_n10\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

                The three basic files needed to get started are shown in the next sections. This sample provides instructions in creating a query form that can be used to retrieve information from your Image database using most browsers and Microsoft’s IIS (Internet Information Server) and FrontPage. Download this sample: HTTP The HTX file Create the results […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2301"}],"collection":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2301"}],"version-history":[{"count":3,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2301\/revisions"}],"predecessor-version":[{"id":2312,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2301\/revisions\/2312"}],"wp:attachment":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}