Database Connection Error

[khan82]

I am trying to create a crystal financial report but the problem is that i try to create a "Add Command" under the data source i have, i get the error

"Database Connection Error" '42000:[Sage Timberline Office][Sage Timberline Office ODBC Driver]syntax Error"

what is it referring to?

 

[hilfy]

Sage doesn't like something you're trying to do in the command. With the exception of using parameters in the query, the SQL syntax MUST match the syntax that the database expects.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com