The problem was with the length of the package name in the odbc.ini file . It should not be more than 6 characters long .

Building the package , solved the problem.