• Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » Connect DB2 (by ODBC) to Mysql

#1 2006-09-27 14:23:40

ggy
Guest

Connect DB2 (by ODBC) to Mysql

When I connect DB2 to MySQL for extract table, i have this messge.

Code:

Starting process Hiearchie at 14:21 27/09/2006.
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: D:\Talend\plugins\org.talend.designer.codegen.perlmodule_0.9.0.20060919-1637-beta\perl\ D:\Talend\workspace\.Perl D:/Perl/site/lib D:/Perl/lib .) at (eval 7) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
 at D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie.pl line 181

  Copyright (c) 2005-2006, Talend SA

  This source code has been automatically generated by talend
  OpenStudio / ProcessDesigner (CodeGenerator version 0.9.0.20060919-1637-beta).
  You can find more information about talend products at www.talend.com.
  You may distribute this code under the terms of either the GNU General
  Public License or under the Artistic License just like Perl itself.

tsInfo>  Running process with context: D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl (./tUser/parameters_D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl.pl)

Process Hiearchie ended at 14:21 27/09/2006. [exit code=2]

And when connect DB2 to Output file, I have this message

Code:

Starting process Hiearchie at 14:23 27/09/2006.
install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC contains: D:\Talend\plugins\org.talend.designer.codegen.perlmodule_0.9.0.20060919-1637-beta\perl\ D:\Talend\workspace\.Perl D:/Perl/site/lib D:/Perl/lib .) at (eval 7) line 3.
Perhaps the DBD::ODBC perl module hasn't been fully installed,
or perhaps the capitalisation of 'ODBC' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, SQLite, Sponge.
 at D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie.pl line 229

  Copyright (c) 2005-2006, Talend SA

  This source code has been automatically generated by talend
  OpenStudio / ProcessDesigner (CodeGenerator version 0.9.0.20060919-1637-beta).
  You can find more information about talend products at www.talend.com.
  You may distribute this code under the terms of either the GNU General
  Public License or under the Artistic License just like Perl itself.

tsInfo>  Running process with context: D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl (./tUser/parameters_D:\Talend\workspace\.Perl\ENTREPOTDEDONNESTATISTIQUEETTECHNIQUE.process_Hiearchie_Default.pl.pl)

Process Hiearchie ended at 14:23 27/09/2006. [exit code=2]

Drive ODBC and mysql aren't installed ?

#2 2006-09-27 14:37:33

cantoine
Talend team
Registered: 2006-09-19
Posts: 715
Website

Re: Connect DB2 (by ODBC) to Mysql

You must install the following module perl to activate perl's connection perl with mysql and Odbc.

In console, type the following command :

ppm -install DBD-ODBC
ppm -install DBD-mysql

Regards.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » Connect DB2 (by ODBC) to Mysql

Board footer

Powered by FluxBB