ODBC |
|
•Commit transaction
•Connection Tab
oChoose DSN: Select an existing DSN for your connection string.
oODBC DSN Editor: Launches the ODBC Data Source Administrator form to manage database drivers and data sources. Click here for more information at MSDN.
oConnection String Help: This links to the MSDN web page on the .NET Framework implementation of the ODBC connection string, along with examples.
oConnection String: The connection string to the ODBC data source.
•Advanced Tab
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 © 2024 pasUNITY, Inc.
Send comments on this topic.
Created with an evaluation copy of HelpSmith.
To remove this notice, you should purchase the full version of the product.