question

IEThai avatar image
0 Likes"
IEThai asked Phil BoBo answered

Can i connect Flexsim with IBM DB2 Database

I will try to use database connector and i have a question.

Can i use IBM DB2 Database connect with flexsim like a MS SQL , MySQL

Thank you very much

FlexSim 20.2.0
flexsim 20.2.0database connect
5 |100000

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

1 Answer

Phil BoBo avatar image
0 Likes"
Phil BoBo answered

We have not tested connecting directly to an IBM DB2 database, but the SQLAPI++ library used by the Database Connector tool has support for DB2.

You can try modifying the connection settings in the tree. Although it doesn't appear in the GUI dropdown, you can set the dbType value to DB2:

The DB2 connection may rely on additional dependency dlls, such as db2cli.dll. You may need to install drivers from IBM and ensure that the flexsim.exe application can access those dlls.

https://www.ibm.com/support/pages/db2-odbc-cli-driver-download-and-installation-information

If using the DB2 connection type directly doesn't work, you can configure the Database Connector to use ODBC, and then configure an ODBC connection to your DB2 database.


1597335148142.png (43.4 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.