Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
gssr
- Participant
- Posts: 243
- Joined: Fri Jan 09, 2009 12:51 am
- Location: India
Post
by gssr »
I am using the ODBC stage to connect to netezza database to fetch records, but i could not able to connect..The ERROR message says,
Could not connect to datasource[DataDirect][ODBC lib] Data source name not found and no default driver specified
I tried to connect to drivers, anyone can suggest me a solution for this...
Thanks in advance
RAJ
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Sounds like you may not have configured the connection correctly. Can you post both the uvodbc.config and .odbc.ini entries you created?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
gssr
- Participant
- Posts: 243
- Joined: Fri Jan 09, 2009 12:51 am
- Location: India
Post
by gssr »
Actually i haven't created any config files and ini files..
Can you tell me how to enable this...
Thanks,
RAJ
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Actually, I don't believe DataStage ships with any Teradata ODBC drivers. Did you purchase some? Why not use the native Teradata stages?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
So, what is your 'workaround'?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
Nagin
- Charter Member
- Posts: 89
- Joined: Thu Jan 26, 2006 12:37 pm
Post
by Nagin »
chulett wrote:So, what is your 'workaround'?
I am facing the same issue, Any ideas about the work around/Fix?