cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to Retrieve Data from the database.

Former Member
0 Kudos

getting the following error message stating that

Failed to retrieve data from the database.

Details:4200:[Microsoft][ODBC SQL server Driver][SQL server] Incorrect syntax near 'Category ID', [Database Vendor Code: 102],

i am not sure why I am getting above error message when running the report.

I have a view linked to table. The Category ID is in View that I have created.

need your help if you know what steps I should take to reslove the issue, thanks!

mansoor

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Are all your data in the View or each time you run a query it update the View? Please try to update your View then run the Report again, much better if you delete the original View and replace with a new one,

Regards,

CLint

Former Member
0 Kudos

Clint,

My view cotians bunch of other view and are joined as union, what would be the best option for me to run such report?

kind regards,

Mansoor

Former Member
0 Kudos

Hi,

You can try to delete all the Views and replace with a fresh data, then call the View which call of them,

Because the error seems to have corrupted data.

regards,

Clint

Answers (0)