Database connector Exception: file is encrypted or is not a database

[shanice_c]

[ FlexSim 21.2.0 ]

I try to import from database(thisistest.db) to GlobalTable1, the connection is successed, but couldn't import from database. I also tried to export globaltable content, it also display "unknown table list. Try testing the connection."

Did I miss anything so that it doesn't work? Since I have succeed with the same method before.

test database connetor.fsm

thisistest.7z

[philboboADSK · Accepted solution]

Your database file doesn't have any tables in it. It is a blank file.

Am I misunderstanding something? What did you expect it to do? What do you mean "[you] have succeeded with the same method before"? I don't understand.

If you want to import or export to a table, you need to actually have a table in the database. Try creating one:

test-database-connetor_1.fsm

[philboboADSK]

Edit: now I see that your zip file has a sql query in it. If I run that query to create a table in a database file, then it imports and exports just fine:

I'm confused as to what you are doing and what you expected to happen. (Perhaps because your attached images aren't working in the original question.)

[shanice_c]

@Phil BoBo Thanks for the reply. This was my first few times testing how to connect to database. It was myself unfamiliar with it, so that sometimes it worked, sometimes didn't. , I've tried using code to import and export as well, it's working well.