DSXchange

Hi,

I am trying to import metadata by using the datastage manager by using import->meta data->odbc.

My datastage is set up on a remote machine. I have an SQL server on my local machine.

When i am trying to connect to the SQL Server i am getting the following error.

DSR.MetaGeta(GET.TABLES)(SQLConnect('localhost','sa')): BCI Error:
SQLSTATE=IM002,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Data source name not found and no default driver specified

Please help.

Thanks,
Deepti

Is the DSN configured on the server to connect to sql server on your machine?
DSN should be configured in the datastage server and not in your system.