oConnection String: The connection string to the OLEDB data source. Double-clicking on the text box launches the Data Link Properties form which assists in the creation of the connection string. Begin by choosing the OLEDB provider to use for the connection, followed by the database name, credentials, and any additional options required for the selected provider. After completing any additional options, press OK to insert the generated connection string into the text box.
oConnection Timeout: The amount of time to spend attempting to make a connection to the database. The default time is 30 seconds.
oCommand Timeout: The amount of time to spend attempting to complete the commands or transaction before disconnecting. It is advised to use a higher command timeout if you are inserting a lot of data or working with a slow connection.
oUse Transactions: A transaction is a single unit of work. Enabling transactions allows for an all-or-nothing insert. If any lines encounter a problem, the transaction will roll back and all modifications will be erased. If a transaction is successful, all modifications were successful and become a permanent part of the database.
Copyright © 2023 pasUNITY, Inc.
Send comments on this topic.