If you choose SQL Database as the file type, the SQL Options tab becomes active. Enter additional information on the Required tab, and on the SQL Options tab.
On the Required tab, enter:
Data Source Name – the DSN you have associated with this database.
Driver Connect String – constructed by the program from the information you entered in the Data Source Name text box.
You may modify the driver connect string to include a username and password if they are required.
If you select Test SQL Connection, ECMap tests whether it can talk to the database associated with the DSN via ODBC. A message appears saying whether or not the test was successful.
After you have finished entering information on the Required tab, select the SQL Options tab to make it active.
On the SQL Options tab, enter:
When you select the Auto Commit check box, the program makes immediate updates to the database. As a result, the SQL Rollback function is disabled, and you cannot use the SQL Check point (and Backout Point) commands.
When you select the Insert Alphanumerics as Null When Blank check box, the program inserts octal null characters into fields that have no data characters.
When you select the Close and Drop Cursor After Insert arrow, you are given two choices:
Y = Yes. Perform automatic COMMITs
N = No. Do not perform automatic COMMITs
If you choose Y, you must provide two additional pieces of information:
Choose one of following for the Translation Isolation Option:
Database Default List
Highest Allowed
Transaction Serializable
Transaction Repeatable Read
Transaction Read Committed
Choose one of following for the Translation Commit Performed:
On Every EDI Message
On Map Switches and end of Program
No Preset Commit
