I am trying to move our Sage Accpac db from db2 9.1 to 10.1 by doing an accpac dump and load. Accpac requires an odbc connection to communicate with db2 which in v9.1 is done via the "First Steps" application that comes with db2 server client 9.1. Unfortunately in v10.1 that capability has been removed from "first steps" and the odbc connection needs be done manually. My server is a CentOS machine running db2 10.1 32bit.
I have configured the odbc connection manually and when i test it, it's giving me a positive reply, but when i try to connect Accpac, the connection fails with an error that states the db is unaccessible. Now going back to db2 v9.1, if i attempt to configure the odbc connection manually, i get a similar error.
Is there an automated way of configuring the odbc connector in v10.1?