SQLSTATE=IM002,Code=0,Data source name not found
Posted: Thu Jan 05, 2006 11:26 pm
Hi,
Error obtained when a job is been ran in datastage designer.
steps:
1. I created database in sql server box (which is also hosting Datastage Server).
2. Designed the job to transfer data to another table using transformer.
3. Created DSN in the client box to connect to server box (For SQL Server).
4. Changed the properties in the Job Properties section with parameter values included to connect to SQL Server.
5. Ran the transformer and the following error is thrown.
dsr.metageta(get.dsninfo)(sqlconnect('#TargetConnection#','#T...
BCI Error:
SQLSTATE=IM002,Code=0,[datastage][sql client][odbc][Microsoft][..
Data source name not found and no default driver specified
Can anyone suggest me what might be the problem.
Error obtained when a job is been ran in datastage designer.
steps:
1. I created database in sql server box (which is also hosting Datastage Server).
2. Designed the job to transfer data to another table using transformer.
3. Created DSN in the client box to connect to server box (For SQL Server).
4. Changed the properties in the Job Properties section with parameter values included to connect to SQL Server.
5. Ran the transformer and the following error is thrown.
dsr.metageta(get.dsninfo)(sqlconnect('#TargetConnection#','#T...
BCI Error:
SQLSTATE=IM002,Code=0,[datastage][sql client][odbc][Microsoft][..
Data source name not found and no default driver specified
Can anyone suggest me what might be the problem.