|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/29/2007 2:33:00 PM
Posts: 3,
Visits: 1
|
|
Hi,
I have Informatica 8.1 and have to use Teradata as Backend. I created ODBC connection and I am able to import teradata tables as source and target. I created a relational connection for Teradata and tried to execute my workflow but I am getting error. In teradata relational connection I have given connection name as edw_dev , user_id and Password and data source name again as edw_dev as that is my system dsn name in ODBC connection. The database name is kept as blank.
The error which I am getting is
Severity Timestamp Node Thread Message Code Message
ERROR 8/22/2007 7:52:36 AM node01_nyrofclnxinformatica READER_1_1_1 RR_4036 Error connecting to database [
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [b_sott_dev] and connection string [edw_dev].].
What could be possible reason for this? Is there any problem with the relational database connection I have provided or is it problem with ODBC.
Any help will be highly appreciated.
Thanks,
Ritesh Kumar
|
|
|
|