Skip to main content

Hi, 

 

I’m new to AIMMS and I’m following the tutorial for professional. I’m in page 80 now and while running the procedure ‘ReadFromDatabase’, I encounter an error saying, 

“Executing SQL query "TotalDemand" of database procedure "TotalDemandQuery" failed: ODBCy-3500] : 42000 -Microsoft]0ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. ,while calling the query TotalDemand].”

 

I don’t understand this error as the tutorial does not say anything on this issue and I think I’ve followed the tutorial completely. 

 

Any help, please?

 

 

Can you check if you have selected “Stored Procedure” and not “Sql Query” in the TotalDemandQuery identifier?

Yes, I’ve selected for the “Stored Procedure” in the identifier. It still gave the error. 

Strangely enough, I open again the case just now and it works perfectly :smile: . Thanks anyway ya

Reply


Terms & Conditions

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator