U2 Rocket ODBC issue

We are setting up a connection on a new server to connect to our Prelude (UNIDATA) database.

I can test the ODBC connection and get success. When we try to use the connection, we get the error below.

Error code: 9603
Details: Error [0000] [Rocket U2] [U2ODBC] [0302809] Unable to allocate sufficient memory!
Error [0000] {Rocket U2] {u2ODBC] [0400182] Connection not open.
Activity ID: 47fd30ba-cfa2-4f5b-806c-5f5eb28dc60f.


ODBC installed on Windows Server 2022

U2 64-bit ODBC Driver  7.241.02.9003

when I test the connection to the UNIDATA DB my connection passes. When the connection is used to pull data we get the error.

• Try using smaller data sets and smaller numbers of columns, a specific column or volume or combination

• Make sure that you use Associations for all associated multi-values
• Data volume too large for the maximum memory size on the (usually UNIX) server - check the UNIX kernel limitations
• Check VFIELDSIZE in case it needs to be increased
  • VFIELDSIZE Increases the size for the stack of C routines used to process
    formulas created in virtual fields. Default is 300. Define a larger
    number if users see "virtual field too big" errors in UniQuery
• Try running the same SQL query at the ECL / SQL prompt - errors can be far more informative.