Skip navigation
Contact Us
3626 Views 2 Replies Latest reply: Nov 15, 2012 6:44 PM by Viral Raichura RSS
lolo lololo Newbie 1 posts since
Mar 14, 2012
Currently Being Moderated

Mar 14, 2012 2:19 AM

not able to connect to Mysql Server (relationnal)

Hello all, im new to informatica and i want to load data from oracle DB to Mysql DB. the probleme is : when i try to create a relationnal connection to MySQL DB, it dose'nt work.


here it is the log :


INFO     13/03/2012 11:04:50     Reader: Source IS [C182CFR], user [user12]
INFO     13/03/2012 11:04:50     Source DATABASE connection [oracle_S] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
INFO     13/03/2012 11:04:51     Initialization completed successfully.
INFO     13/03/2012 11:04:51     Writer: Target IS DATABASE [localhost], user [root], bulk mode [N/A]
ERROR     13/03/2012 11:04:51     Error connecting TO DATABASE...
WRT_8001 [Session s_session_MySQL Username root 
DB Error -1805 [DataDirect][ODBC lib] 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 [root] AND connection string [localhost].]




have you any solution please.

thank you

More Like This

  • Retrieving data ...

Bookmarked By (0)


  • Correct Answers - 10 points
  • Helpful Answers - 5 points