Connecting Access database

[tomi_kosunen]

[ FlexSim 18.2.2 ]

Hi

I tried to connect Access database to FlexSim with database connector. I'm having troubles with the connection. It says: "Connection failed with Error: IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.".

I have configured the Access database into System DSN.

Can you help me?

[JordanLJohnson · Accepted solution]

You can try connecting using the Database Connector tool using ODBC. Just follow these steps to customize the connection string:

1. Open a Tree view
2. Open the variables of the Database Connector you wish to edit
3. Remove the dbAddress value
4. Remove the dbName value
5. Put the DSN name as the dbString value

If the dbString value is specified in the tree, then it will use that as the connection instead instead of concatenating the dbAddress and dbName fields.

You could also use the old db*() commands.

[yuan_zhang]

@jordan.johnson

I have tried to follow the steps you described to connect to the access database.When I clicked the "Test Connection" button,it shows "Connection Succeeded", but the system console reported the following error:

exception: Exception thrown in database table list update: HY000 [Microsoft][ODBC Microsoft Access Driver] ֒һսτݾ 'C:\Program Files\FlexSim 2019 Update 1\program\INFORMATION_SCHEMA.mdb'c

When I used the code to connect the test, it was good.

How to solve the problem of manual connection error?Could you help me? @jordan.johnson

Version: FlexSim 19.1.0

Thanks a lot!

[zhuhai_s]

Hi ALL, I faced the same issues as the picture showing. have you solved this problem？if so, could you help me to do that? thank you in advance.

[support5CRPZ]

@zhuhai S

I upload my setting when using AccessDB. You need to set the information of dbtype and dbstring like above in tree not odbc wizard screen.

dbstring is DSN name you set in ODBC connection.