question

Julian Sundermeier avatar image
0 Likes"
Julian Sundermeier asked Felix G2 edited

Discontinuing execution after computer restart

Hello everyone,

yesterday i made the SQL tutorial successfully. The connection via ODBC worked and the model does exactly what it was suposed to do. Today I wanted to mofify and expand the model but instead i got an error message about a "Discontinuing execution" (see picture below).

Of course i didn't changed anything in the model or the database so far.

I even did the tutorial exactly the same as yesterday (including creating the ODBC connection and the database) but the error message keeps popping up.

Has someone an idea how to fix this?

FlexSim 7.5.4
sqlodbcdiscontinuing execution.
error-sql.jpg (607.0 KiB)
· 3
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
1 Like"
Jason Lightfoot answered

You don't have to start anything in Windows to access data source names (DSN) through ODBC - but of course any database server it references needs to be started. This doesn't apply to Access/Jet file based databases, or when you're using Excel as a datasource.

18.1 Has native-like connectivity to MySQL which means that you shouldn't need to specify a DSN in the ODBC Data Source Administrator tool with which to then access your database. You specify the connection parameters directly in FlexSim's Database Connector which is found in the Toolbox under Connectivity.

· 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.

Felix G2 avatar image
0 Likes"
Felix G2 answered Felix G2 edited

Hi,

this is what solved it for me:

You get there by viewing the ODBC-Datasources, configure your MySQL Connection, Details and there under the tab "Connection".

After that it worked fine :)


unbenannt.jpg (30.6 KiB)
5 |100000

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

Emily Hardy avatar image
0 Likes"
Emily Hardy answered Emily Hardy converted comment to answer

When you restart your computer, the ODBC server doesn't automatically start up. After a restart, you need to make sure your ODBC server is started and you have to reconfigure it like you did the first time.

Additionally, 18.1 will work better for database support so if it's possible to use that, I would recommend upgrading your software.

· 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.