dbopen gives exception in 2021/22 but works in 2019 and earlier

Question

question

pc neo asked Jan 3, '22 pc neo commented Jan 4, '22

dbopen gives exception in 2021/22 but works in 2019 and earlier

hi, the calling to dbopen() gives FlexScript exception in both 2021 version as well as 2022 version. As seen in the pic. dbopen_err.png

However, the same commands work in 2020/2019 and earlier as seen in dbopen_ok.png. All Flexsim versions are executed on the same machine and against the same database (MySQL). Is there something in 2021/2022 that needs to be done differently when using the db commands? Otherwise, will this be fix in upcoming release?

Software Version:

FlexSim 22.0.0

database odbc dbopen

dbopen-err.png (15.2 KiB)

dbopen-ok.png (28.0 KiB)

· 1

Jason Lightfoot ♦ commented · Jan 03, 2022 at 03:13 PM

Were yourDSN's defined as 32bit or 64? Were you using 32bit FlexSim in the earlier versions?

UPDATE: Ignore those questions I've confirmed it doesn't work using 64bit 2020 (works) and 2022 (doesn't work) and it's not working for table mode or query mode.

0 ·

Answer 1 · 2022-01-03T17:32:09Z

Phil BoBo answered Jan 3, '22 Jason Lightfoot edited Mar 31, '22

This may be a bug, but it is also unlikely to get fixed anytime soon if at all. You should update your model to use the Database Connector tool and Database FlexScript API instead of the old db..() odbc commands.

· 1

pc neo commented · Jan 04, 2022 at 02:47 AM

Thank you. We noted that this is acknowledge as a bug and that it may not get fixed immediately. We will explore the use of Database Connector tool and Database FlexScript API so as to make progress for our current project.

1 ·

Answer 2 · 2022-01-03T15:49:01Z

Jason Lightfoot answered Jan 3, '22 pc neo commented Jan 4, '22

Thanks for this I've reported the bug.

· 1

pc neo commented · Jan 04, 2022 at 02:38 AM

Thank you.

0 ·

question