Database Query ODBC Tool
Database Query: RowCount property not reflecting the amount of rows produced by a recordset
Last Updated: August 3, 2022Symptom The Database query step’s RowCount property does not reflect the number of rows returned by the query. It may contain a value such as -1, or 0 (zero) in place of the expected number of rows. Please follow the below link for a similar symptom encountered with the RowsProcessed property of the Filter Data:...
Global ODBC connection test fails with error 0x80040154
Last Updated: July 4, 2022Symptom When you click the Test button after creating an ODBC connection it fails with the following error code: 0x80040154 Cause Caused by the Microsoft Data Access objects not being registered. Resolution Register the dao350 and dao360 dlls found in C:\Program Files\Common Files\Microsoft Shared\DAO\ with the RegSvr32 utility.
Locked solutions ODBC Memory works at runtime but shows error at design time
Last Updated: September 28, 2022ODBC Memory events in a task that have been exported from the original task creation machine are functioning correctly at runtime however, at design time an error is displayed. This article provides details about the issue and how it can be resolved: Cause This issue is caused by the export from the original task creation...
