Hi,
downloaded Talend Open Studio 6.0.1. Installation went fine, configured environment and started to create connections.
I try to connect to an MS SQL Server 2005.
TCP IP is enabled
SQL Server and Windows Authentication mode is enabled
Remote connections are allowed
It works fine using "localhost" in the connection url connecting to a local MS SQL installation on the same machine. And it works for both, JDBC and MS SQL (jtds) connections.
As soon, as I change "localhost" to a servername or an IP-address, I get the error message: "Login timed out". This behaviour is the same for JDBC and MS SQL (jtds) connections. This makes it impossible for me to connect to a database on a remote server.
Would be great, if someone faced the same problem and can provide a solution.
Thank you!
Hi
xdshi, Thank u so much for ur reply.
i got same error after check out "Die on error" option.
is there any limitaion of open source studio that it will not read and write more than 24 million row in mysql.
It happen 4 to 5 times that job is stoped after reading out 20 to 24 millions record.
==>> tMysqlInput -- tMap -- tMysqlSCD
Is there any solution to read and write 80 million row in Talend open studio.
I am using Talend 5.4 open studio.
.
.
please respond.
Thanks and Regards,
Anand Yadav
Hi,
There is no limitation for loading
24 million row in mysql.
Are you using tmysqlSCD component in your work flow? Have you tried to use tmysqloutput component instead to see if it works?
Thank you for ur reply xdshi, It work fine with tMysqlOutput but as our requirement is to maintain version control.
So can tMysqlSCD have any feature to load 80 million rows?
Regards,
Anand Yadav
