question

Vinay S avatar image
0 Likes"
Vinay S asked Jordan Johnson commented

Connect SQLite db to Flexsim as DataBase connection

Hello, I'm using SQLite DataBase. I've a database file flexsim.db in c:\SQlite_DB folder. How to connect it to Flexsim model. I'm not running it in server. In Flexsim, to connect database it asks for user name and password. what to do in this case

FlexSim 23.0.0
database connectorsqlite
· 1
5 |100000

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

Jason Lightfoot avatar image Jason Lightfoot ♦ commented ·

Have you tried leaving them blank?

0 Likes 0 ·

1 Answer

·
Jordan Johnson avatar image
2 Likes"
Jordan Johnson answered Jordan Johnson commented

Here is an example where I connected to a SQLite database successfully:

1684422662662.png

@Jason Lightfoot is right, you can just leave the Login ID and Password blank. I also prefer placing the full path to the file in by checking the "Enter Full Connection String" box.


1684422662662.png (20.0 KiB)
· 2
5 |100000

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

Hey @Jordan Johnson I have done the same and connection succeed as well but I am unable to import or export any table and getting below error.

1713941424960.png

Could you please help me in export and import.

0 Likes 0 ·
1713941424960.png (565.5 KiB)
Jordan Johnson avatar image Jordan Johnson ♦♦ Brijesh Kumar commented ·
The SQLite connection always succeeds, even if the path is wrong. SQLite just makes a new file at the path. So I'd guess you need to double-check your path. If it still isn't working, please post a new question with an example model and db file (you can mark the question private if needed).
0 Likes 0 ·

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.