ODBC Actions Plugin
Benefits
This plugins allows developers of AutoPlay Media Studio, Setup Factory, TrueUpdate or Visual Patch the connection to SQL databases, using the proper ODBC driver. These connections can be made through DSNs in the ODBC Administration panel, or may be DSN-less, allowing the developer to establish connections to databases without modifying the user's system, just by passing the driver name and connection parameters manually.
Once successfully connected to the database of his choice (which may be Firebird SQL, Microsoft Access, Oracle, Visual FoxPro, Sybase, SQL Server, or MySQL, just to name a few), the developer can perform any queries, and extract the resulting data (recordsets and column names), to be filled into tables, data grids, etc.
The full version of this plugin has additional advanced functions that return resultsets as tables, can executed stored procedures, and retrieve BLOB fields.
Quotes
“This is a welcome addition to AMS. Great job.”
“(...) This is a very good plugin, I recently downloaded the trial for this. And it is definitely the best option for databases.”
“I have downloaded and used it (just for try) with an application wich has been built in order to connect a external Oracle Database and I have to say that it was working very well.”
“Excellent, thank you! worked a treat. Managed to get project finished in time!”
“Excellent, it works a treat :)
Looking forward to the next step, looking ever more promising.
Congratulations on this build.”
Version comparison
Not all of the functions are available in the evaluation version. Some functions are not compiled into the code, and are available only in the full build. (Related info can be found here.)
| |
Evaluation |
Full version |
| ODBC.ExecuteDirect() |
|
|
| ODBC.QueryToTable() |
returns a single record |
returns the full resultset |
| ODBC.GetBlob() |
|
|
Download
Purchase
The plugin will work for 7 days, after this it you will need to unlock the program if you wish to keep using it.
Please use the form below to send your registration info. The cost for this plugin is US$ 19.95.
If you are unable to use PayPal, I accept Amazon Gift Cards as well for single purchases.
When making your payment, please inform the Site code and MID, as shown on the activation dialog displayed by the plugin, to allow us to create the correct unlock code. If you forgot to inform the data in the message sent through PayPal, you can reach us anytime later through our contact page.
The activation code does not expire, and will work with future versions, including updates and bug fixes. A new activation code may be required if you need to reinstall your operating system, and will be sent for free - just let me know.
Please use the trial period to evaluate if the product meets your needs - the software is provided "as is", and no refunds will be granted if you later decide that something is not working as you thought it would.
Change Log
2.0.2.0
- The MySQL Actions Plugin, with support for AutoPlay Media Studio 8.0, was added to this product.
2.0.1.0
- Plugin ported to AutoPlay Media Studio 8.0.
1.0.5.0
- New function GetFieldType().
With this action you can query the data type of a certain field in the resultset, ie. char, varchar, integer, date, timestamp, etc.
1.0.4.0
- New function GetBlob().
This function will return the contents of a binary field (Blob) from a database, used to store, for example, image or sound files.
1.0.3.2
- QueryToTable() now returns one full record of the recordset in the evaluation build. Full results will be returned in the registered version only.
- Inclusion of the plugin error messages in the global table, so now you can use _tblErrorMessages[...] to retrieve the error descriptions.
1.0.3.1
- New function QueryToTable().
1.0.3.0
- New function ExecuteDirect(), for the execution of stored procedures.
1.0.2.0
- New function IsDeleted();
1.0.1.0
- Additional fixes and update of libraries.
1.0.0.3
- New functions PrevRow(), FirstRow(), LastRow() and IsBOF();
1.0.0.2
- New function ExecuteSQL();
1.0.0.1
1.0.0.0
