Importing table definitions from sql server 7 into Datastage

[admin]

I have create on the datastage server a system dns to connect to the sql sever which I have tested and it does work.

The problem that I have , is that when I go into manager - tools , import , odbc table definitions - the server logs me in but does not display any tables or files. I have also tick the box show system tables.

Is there perhaps a problem with the dsn setup or is their something else that I should set up on Datastage.

N.B: I can transfer data from datastage to the sql server.





CONFIDENTIALITY NOTICE: This e-mail may contain confidential information and is intended only for the use of the recipient named above. Should you receive this e-mail in error, please forward it to dmaharaj@netcare.co.za and delete from your in-box. Any disclosure, copying, distribution or action on the contents of this e-mail is strictly prohibited

Doshian Maharaj
TEL : 482 - 7202