Rumba ODBC driver on Windows 10

For the last couple years I've been using the Rumba ODBC driver to allow an application I wrote to receive and send data to our AS/400 over an ODBC connection. I recently wiped my computer and did a fresh install of Windows 10 (I was previously on 7) and now I can't get the ODBC connection working.

I get an ODBC error message saying "Driver not capable" when my app attempts to use the connection.

I thought maybe the Rumba version wasn't compatible with Windows 10 so I installed a trial version of Rumba 9.4.1 (I was using 9.2) to see if that solved the problem and the error message changed to 'Attempted to read or write protected memory. This is often an indication that other memory is corrupt.'

Is there a specific version I need that works with Windows 10? Or is it possible the setup process is different from 9.2 to 9.4.1?

Thanks!

Parents
  • Hi,

    generally it should work with your RUMBA version under windows 10.
    Since you are not getting an architecture mismatch between the Driver and your Application I assume your application is a 32bit Application, right ?
    Try to open the Rumba AS/400 Filtransfer and establisch a connection to your AS/400.
    The Rumba Optimized Server ODBC driver is  incorporated in the AS/400 File Transfer subsystem.

    Using the ODBC Administrator should give you more information , turn on tracing and try your application and look at the log file. Your trace will show SQL_ERROR instead of success

    AS400FTX        31c4-4584 EXIT  SQLAllocEnv  with return code 0 (SQL_SUCCESS)

    HENV *              0x00C4E0C4 ( 0x0130EF30)

    AS400FTX        31c4-4584 EXIT  SQLAllocConnect  with return code 0 (SQL_SUCCESS)

    HENV                0x0130EF30

    HDBC *              0x00C4E0C8 ( 0x075F2D58)

Reply
  • Hi,

    generally it should work with your RUMBA version under windows 10.
    Since you are not getting an architecture mismatch between the Driver and your Application I assume your application is a 32bit Application, right ?
    Try to open the Rumba AS/400 Filtransfer and establisch a connection to your AS/400.
    The Rumba Optimized Server ODBC driver is  incorporated in the AS/400 File Transfer subsystem.

    Using the ODBC Administrator should give you more information , turn on tracing and try your application and look at the log file. Your trace will show SQL_ERROR instead of success

    AS400FTX        31c4-4584 EXIT  SQLAllocEnv  with return code 0 (SQL_SUCCESS)

    HENV *              0x00C4E0C4 ( 0x0130EF30)

    AS400FTX        31c4-4584 EXIT  SQLAllocConnect  with return code 0 (SQL_SUCCESS)

    HENV                0x0130EF30

    HDBC *              0x00C4E0C8 ( 0x075F2D58)

Children
No Data