DSXchange

Posted: **Wed Oct 14, 2009 5:43 am**

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

Posted: **Wed Oct 14, 2009 5:48 am**

Sounds like you may not have configured the connection correctly. Can you post both the uvodbc.config and .odbc.ini entries you created?

Posted: **Wed Oct 14, 2009 5:58 am**

Actually i haven't created any config files and ini files..
Can you tell me how to enable this...
Thanks,

Posted: **Wed Oct 14, 2009 6:05 am**

Actually, I don't believe DataStage ships with any Teradata ODBC drivers. Did you purchase some? Why not use the native Teradata stages?

Posted: **Wed Oct 14, 2009 8:39 am**

So, what is your 'workaround'?

Posted: **Wed Apr 07, 2010 7:07 pm**

chulett wrote:So, what is your 'workaround'?

I am facing the same issue, Any ideas about the work around/Fix?

DSXchange

ODBC Connectivity Probs

ODBC Connectivity Probs