ODBC Unix connectivity

[rasi]

Hi All

I am configuring ODBC to acces SQL Server Data from different server. It shows the DSN name but finally gives the following error message.
"
DSR.MetaGeta(GET.TABLES)(SQLConnect('dmssqlserver','ers2admin')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified"

The change i made in the files are as follows:

uvodbc.config


DBMSTYPE = ODBC
network = TCP/IP
service = SQLServer
host = 165.238.87.33

odbc.ini


[dmssqlserver]
Driver=/data/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss18.so
Description=DataDirect SQL Server Wire Protocol
Database=ERS
LogonID=ers
Password=ers
Address=165.238.87.33,1433
QuotedId=No
AnsiNPW=No

Is there anything I should do to make it work

Thanks
Rasi