Making an HS connection is, like any network operation, a chain of events, that need to be run down one link at a time, in succession. You could very well have an issue before you even get to your init file.
Perhaps this will help:
To answer the question about HS_FDS_SHAREABLE_NAME ... what you have is incorrect. I must be set to the directory path and file name of a 64-bit ODBC driver manager. On linux, check to see if you have /usr/lib64/libodbc.so. If you do, make that the value for this parameter.
Beyond that, you need to refer to configuration documentation. Have a look at what Ed suggested, and
Hello , thank you for your answers .
I don't have libodbc.so file @ /usr/lib64/ . What do I need to do to have it there ?
Do I need to use yum install to try to install that package `?
just wanted to inform you I managed to get /usr/lib64/libodbc.so , so I will proceed with the configuration and see if it will work
with libodbc.so set for HS_FDS_SHAREABLE_NAME .