Put to ODBC Database

Sends data to any ODBC-capable database such as MySQL, Microsoft Access, and Oracle databases.

 

Input Arguments

 

0

Connection String

Connection String

The connection string to the database.

1

Table Name

Table Name

The name of the table to update.

2- >n

USER

USER

ADDITIONAL CUSTOM ARGUMENTS

 

Return Arguments

None.

 

Returned Status

 

SUCCESS

The data was successfully saved to the database.

FAILURE

The database or table could not be accessed.

 

Remarks

Unless you know how to format the connection string, the easiest thing to do is to change the entry method to Browse and then click the down-arrow button in the Value field. This opens the Windows ODBC data source picker, which guides you through selecting the proper database.

Unless you know how to format the table name string, the easiest thing to do is to change the entry method to Browse

(once the connection string has been specified) so that you can enter the value using a graphical user interface.

To add, remove, or edit any number of arguments, use the buttons listed under the comment area of the MP editor. When adding arguments, the Description should match the column name, and the data type should be compatible with the data type in the database (values will be converted to the proper type, if possible). To enter the values using a graphical interface, use the Add Using Column Picker button, but be aware that a valid connection string must be specified first before using this option.