Data problems on test machine
Posted: Wed Jan 31, 2007 11:05 am
Hi,
We Datastage server set up on a Windows Server 2003 Enterprise edition machine. We want to do a simple test so we decided to use a Windows 2000 SP4 desktop and installed Datastage server on it.
Our source data is coming from an AS/400 or SQL server 2005 using ODBC.
We then did a straight copy of a server job from our 2003 Development server to this test desktop, but when we do a view data on the test desktop, the data is truncated, strange characters, zeros or blank.
While debugging this problem we did a query using MS Query with the same ODBC datasources that Datastage uses. The Data looked fine. therefore we don't think it is the ODBC driver set up.
The Driver version is the same on both machines.
The Drivers are set up the same.
The MDAC level is the same.
The server job is the same.
The only difference is that one machine is Windows Server 2003 and the other is Windows 2000 SP4.
Any ideas?
thanks
Rich
We Datastage server set up on a Windows Server 2003 Enterprise edition machine. We want to do a simple test so we decided to use a Windows 2000 SP4 desktop and installed Datastage server on it.
Our source data is coming from an AS/400 or SQL server 2005 using ODBC.
We then did a straight copy of a server job from our 2003 Development server to this test desktop, but when we do a view data on the test desktop, the data is truncated, strange characters, zeros or blank.
While debugging this problem we did a query using MS Query with the same ODBC datasources that Datastage uses. The Data looked fine. therefore we don't think it is the ODBC driver set up.
The Driver version is the same on both machines.
The Drivers are set up the same.
The MDAC level is the same.
The server job is the same.
The only difference is that one machine is Windows Server 2003 and the other is Windows 2000 SP4.
Any ideas?
thanks
Rich