[resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2

[cwaras]

Hello
This is my first post here so sorry if I'm not using best practices.
This is my problem:
I have a SQL Server 2008 R2 hosted on a Windows Server 2003 64 bit.
On this database I created two schemes and dedicated users/connections owners of these schemes in SQL Server authentication.
I attack these schemes since Talend V5.0.2 deployed on a desktop Windows XP 32-bit.
No problem to create connections "MS SQL Server" (jtds).
But when I try to retrieve schemes of my tables, Talend tell me "waiting" indefinitely.
I tried everything in terms of rights on my users (sysadmin, dbowner etc.) but nothing changes.
It happens the same thing if I use the "sa" user.
In fact, what I do, the only schemes I can retrieve my tables schemes are dbo and sys. I can not retrieve the tables schemes from other database schemes.
Odbc connection is worst, I can not recover tables schemes at all.
Does anyone here have a solution and / or the same problem?
Thank you for your answers, and please come back to me if you need additional information.
Rergards

[Anonymous]

I can get the structures, but selecting a schema in MS SQL causes the same problem.. sits on pending indefinately.

[cwaras]

Hi
This problem is resolved in v5.0.3.
Regards

[Anonymous]

The issue still exists in 5.1.1

[alevy]

5.0.3 was released after 5.1.1. 5.1.2 should be out in a week and contain the fix.

[_AnonymousUser]

SQL Server table data gets corrupted when internal Server errors or virus attacks etc affects entire database of MDF file. To get back or retrieve data from table with schema is possible by using SQL data recovery tool. It recovers all damaged or corrupt MDF file table data and user can easily open their columns, keys and indexes etc. It also helps to retrieve deleted table data. To get more information visit: http://www.ms.sqldatarecovery.net/