Publish - ODBC in MS Windows

EZSurvey can collect data in real time onto an ODBC database. This feature can be used separately from, or in combination with, ODBC as the primary EZSurvey database. Pro version only

Instructions:

1. First connect to an ODBC as your primary EZSurvey database type.
2. Select Publish Create a web form. If the Web form setup window opens, select the button Configure sites If the Web site configuration window opens, select a Site profile and select Windows server using CGI and select close.
3. In the Web form setup window, select the option Save to a database with ODBC. Then, select the Setup button.
4. The Advanced web form options window under ODBC are as follows:

   

   • Service name (on the server)
     The service name is the DSN entry found in the ODBC Data Source Administrator.

     Login account (on the server)

     This is the login name used for authorization. Depending on your database program, it will either be setup in your DSN entry or in your database program.

     Password

     This is the password used for authorization. Depending on your database program, it will either be setup in your DSN entry or in your database program.

     Table

     Your database will need to reference a table, you must specify the table name here.

     Database type

     If you the database type is listed select it from the list, otherwise leave blank.

     Autoincriment field

     If you use an SQL function to increment the primary key, please enter it here. To use a triggered auto increment field (MS, Watcom, Sybase), go to the key field's advanced options in the Edit Form Window and select 'This is an auto increment field'.

     Generate SQL to initiate the table?

     Checking this will generate an SQL string on the instructions page. This string may need to be put into your database program to generate the table.

Note: The ODBC database needs to be setup on a System DSN data source type.

Example:

DSN Service Name