Skip to main content

Error in Softdrink planning tutorial for professional

  • January 28, 2022
  • 2 replies
  • 65 views
Z
Forum|alt.badge.img+4

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: ODBC[-3500] : 42000 [Microsoft][ODBC 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?

 

 

    2 replies

    gdiepen
    AIMMS Champ
    Forum|alt.badge.img+7
    • gdiepen
    • AIMMS Champ
    • 155 replies
    • January 29, 2022

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

    Z
    Forum|alt.badge.img+4
    • zulfan.adiputra
    • Author
    • Enthusiast
    • 14 replies
    • February 4, 2022

    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


    Terms & ConditionsAccessibility statement

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

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