Adagio ODBC must be registered.
ADSPROF.??? should be present and have been initialize my the Adagio application so ODBC knows what version of the application data is present. When you copy the production data include the ADSPROF
You must use the correct version, 32 bit or 64 bit, that matches the calling application.
Don't use DBFILTER=*, select a single application or better yet single file for testing the connection.
Start with Excel or Access loading a single table.
Gridview RW will write to a record set directly to a SQL database, perhaps a better approach if you do not require a "live" connection.