Connecting Access database

Question

question

Tomi Kosunen asked Nov 12, '18 David Seo answered Sep 24, '19

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?

Software Version:

FlexSim 18.2.2

database connector access

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 · 2018-11-12T22:06:49Z

Jordan Johnson answered Nov 12, '18 Braydn T edited Aug 15, '19

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

Open a Tree view
Open the variables of the Database Connector you wish to edit
Remove the dbAddress value
Remove the dbName value
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

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

yuan zhang commented · Jul 22, 2019 at 05:53 AM

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

system-console-error.png (70.9 KiB)

script.png (15.6 KiB)

Answer 2 · 2019-09-24T08:57:55Z

David Seo answered Sep 24, '19

@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

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

Answer 3 · 2019-09-24T06:14:59Z

zhuhai S answered Sep 24, '19 zhuhai S edited Sep 24, '19

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

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

question