Hello,
We are in the process of moving our data warehouse from SQL 2005 to SQL 2008. Once the data warehouse was moved I change the server name on the warehouse connection in Data Manager 8.4 and now we keep getting errors stating that the object doesn't exists. The errors are:
DM-DBM-0400 UDA driver reported the following on connection connectioNAe:
UDA-SQL-0327 An invalid object name was detected in the SQL request.
UDA-SQL-0322 Unable to find the colum "column_name".
I have confirmed that the column does exist on the table. I have run a profiler to watch the connection and it all likes fine, no SQL server errors are generated. The last line that is sent to the DB is: exec [dw].[sys].sp_columns_100_rowset N'TABLE_NAME',N'SCHEMA',NULL.
I've tried using the SQL 2008 native client and for the OLE-DB provider and the SQL 2005 native client. Nothing seems to work. I'm thinking it's a 2008 version issue with Data Manager.
Please ignore this. I found the problem as soon as sent this in. It was a permission issue on the user that data manager was using to connect to the data warehouse.