Failed to retrieve data from the database.DB Vendor Code 156

Hi,

We recently migrated our scheduled Crystal Reports from BO XI R2 platform to BO XI 3.1, and are having issues with select reports that pull from the same SQL database. The tables and fields exist in the database - and I ran the SQL in a different tool and the syntax is correct. When I try to run an on-demand or schedule one of these reports in 3.1 Infoview I receive the following error:

Failed to retrieve data from the database. Details: [Database Vendor Code: 156 ]

Running:

CR 2008 SP2

BO XI 3.1 SP2 (FP 2.7)

Please advise! Thanks!