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.
SQLSTATE=IM002,Code=0,Data source name not found
Moderators: chulett, rschirm, roy
SQLSTATE=IM002,Code=0,Data source name not found
Antonio D'souza
Hi
This occurs when the dsn is not set properly.
Did you create dsn in the server where datastage server is present?
--Balaji S.R
Code: Select all
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
Did you create dsn in the server where datastage server is present?
--Balaji S.R
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you see "#" characters in that style of error message it means that a job parameter of that name has not been found/resolved in the job. This probably means that it has been:
- omitted
- mis-spelled
- mis-cased
You must make sure that any job parameter reference in the job design - no matter where it occurs - exactly matches the job parameter name in the job properties.
- omitted
- mis-spelled
- mis-cased
You must make sure that any job parameter reference in the job design - no matter where it occurs - exactly matches the job parameter name in the job properties.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.