Connecting to SQL Server

deeptikorwar · Post by **deeptikorwar** » Wed Aug 23, 2006 5:20 am

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

balajisr · Post by **balajisr** » Wed Aug 23, 2006 5:25 am

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.