question

pc neo avatar image
1 Like"
pc neo asked pc neo commented

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?

FlexSim 22.0.0
databaseodbcdbopen
dbopen-err.png (15.2 KiB)
dbopen-ok.png (28.0 KiB)
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

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 Likes 0 ·
Phil BoBo avatar image
1 Like"
Phil BoBo answered Jason Lightfoot edited

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
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

pc neo avatar image pc neo commented ·

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 Like 1 ·
Jason Lightfoot avatar image
1 Like"
Jason Lightfoot answered pc neo commented

Thanks for this I've reported the bug.

· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

pc neo avatar image pc neo commented ·
Thank you.
0 Likes 0 ·