question

Tomi Kosunen avatar image
0 Likes"
Tomi Kosunen asked David Seo answered

Connecting Access database

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?

FlexSim 18.2.2
database connectoraccess
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

3 Answers

·
Jordan Johnson avatar image
2 Likes"
Jordan Johnson answered Braydn T edited

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.


15617-connect-to-access.png (18.3 KiB)
· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

yuan zhang avatar image yuan zhang commented ·

@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!

0 Likes 0 ·
system-console-error.png (70.9 KiB)
script.png (15.6 KiB)
David Seo avatar image
0 Likes"
David Seo answered

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


2019-09-24-175140.png (10.2 KiB)
2019-09-24-175247.png (18.5 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

zhuhai S avatar image
0 Likes"
zhuhai S answered zhuhai S edited

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.


01.png (12.1 KiB)
02.png (9.7 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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