Database Vendor Code 208 after moving report to server
I am using CR 2008. The database environment is SQL Server 2000. I have written several reports, connecting via ODBC, which work fine. All reports are viewed from a VB.NET app. My latest report works on my development box, but when I migrate it to the server, the viewer throws an error on the NEW report: Failed to retrieve data from the database Database Vendor Code 208.
At first, I thought this was going to be caused by the fact that the ODBC connection is pointing to MyDatabase, and the production database does not yet contain the new tables I created, so I changed the DSN to point to MyDatabase_DEV, which does have my new tables.
The query works in Query Analyzer. I have no idea what Database Vendor Code 208 means, so I'm not even sure where to look to find the problem.
On the VB side, I am instantiating the Report Viewer with the same code I use for my other reports. That being said, it works on my computer, but not the server. Every other report works as expected
Any suggestions would be welcomed and appreciated.