SQL connection Problem - Error Code 2

Question

question

Philip Diem asked Nov 9, '17 Ben Wilson commented Nov 9, '17

SQL connection Problem - Error Code 2

I tried to follow the step-by-step SQL tutorial but i can`t get it to work.

I used mySQL workbench (oracle) to set up the database (is a schema the same as a database?) and the tables like i was told in the tutorial.

I also filled in the code as mentioned in the tutorial and ran the simulation.
But that just throws an error and FlexSim crashes:

(Transl: The name of the data-source was not found and it is no standard driver stated.)

I searched the Q&A and installed the ODBC driver/connector, but the issue remained untouched.
Can anybody suggest what I'm doing wrong?

Thanks :)

Software Version:

FlexSim 17.0.8

sql connection odbc

mysqlworkbench.png (265.2 KiB)

sql-problem.png (10.3 KiB)

5 |100000

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

Answer 1 · 2017-11-09T16:02:02Z

Ben Wilson answered Nov 9, '17 Ben Wilson commented Nov 9, '17

Hi @Philip Diem,

Are you using the tutorial in the version 2017 User's Manual? It doesn't really adequately cover configuring your ODBC data source (okay, so it doesn't mention it at all :(.

Steps 21-24 of this MySQL+ODBC tutorial cover creating and configuring your ODBC data source using Windows' ODBC Data Source Administrator. It's likely that you still need to do these steps.

FlexSim's User Manual was completely rewritten for version 2017 Update 2, and while this new User Manual does not yet have an ODBC+SQL tutorial, we'll make sure that when one is added it will more fully cover this topic.

5 |100000

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

question