ODBC returning only 100 Records

Question

I have an OpenLink 64bt ODBC connection to as progress 83E database that only returns 100 records. If I use the same ODBC connection with an other application, all records are returned so it seems to be an issue with Alteryx only. Other ODBC connections to other sources that are run at the same time do not have any issues. There are not records limit set. Any help would be great. Thanks Jon

TrevorS · Answer

Hello @JonBlent

Upon looking on the Community, it looks like there is a way to connect.

This post has a discussion about the ODBC connection.

"It looks like you have to be Progress customer and login through their progress.com downloads portal. I believe that it was this driver: Progress® OpenEdge® ODBC Connector for Windows 32-bit

That we just configured as a Other>32-bit ODBC connection. Note the Visual Query Builder was not compatible but inputting SQL in the SQL Editor worked great."

Can you try to use the 32-bit connection and let me know if that helps?

Thanks!