Analytics Software

We are using inetdae7 driver from many years to connect to Microsoft SQL Server 2000 database, wherein the data load was fine. The source was Microsoft SQL Server 2000 and target was IBM DB2 ver 8.1.
Recently in the source server the operating system was updated to Windows 2003 and database version to Microsoft SQL Server 2005. After this migration there has been no change in ODI code but data is not being loaded to work table itself. It is not giving any error but in the logs data loaded to work table (C$ table) is coming as 0. Please let us know what may be the issue (do we need to updgrade the JDBC driver ?)
This problem is typical. There are two databases in Microsoft SQL Server (database 1 and database 2). Both are defined as two physical schemas under the same Physical server in Topology. Schema representing database 1 is the default schema under the Physical server.
We use only tables from database1 and only views from database 2. When the query in the interface involves only a table from database 1 then it is not loading data to work table. When the query in the job involves only a view from database 2 then the data load in entire interface is fine. When the query involved a database1 table and database 2 view then also interface is running fine.
However when the query in the first scenario which is giving issue is run by right clicking the Model and checking data with the query, it is showing data :(
The above issue came after OS and Microsoft SQL server upgrade in source. Please comment.
Note: Stangely the query