ODBC Connections to MSSQL Server 2000

[mfanas]

Hello Gurus, I've tried to search the previous postings but to no evail.I need help on setting up ODBC connections from AIX to a SQL Server 2000 db running on a Windows environment. I have edited the dsenv,.odbc.ini and uvodbc.config files with the relevant parameters. I also copied the uvodbc.config file to my project directory, but I seem not to get ir right as DataStage gives me an error calling subroutine: DSR_IMPORT (aCTION = 7) and tells me to check if DataStage is set up correctly in my project.

This is how I edited my files.
dsenv : no changes made as I'm using a Wire Protocol,
.odbc.ini : (Directory = Driver=/home/dsadm/Ascential/DataStage/branded_odbc)

[SQLServer]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=db
LogonID=uid
Password=pwd
Address=ip address,port no
QuotedId=No
AnsiNPW=No

port no used = 1433 (default not sure if its right to use default)


uvodbc.config : (Directory = /home/dsadm/Ascential/DataStage/DSEngine)
<SQLServer>
DBMSTYPE = ODBC
Another copy of uvodbc.config file is in the project directory).

Please gurus advise if there's anything that I might be doing incorrectly.

Thank you in advance.