SQLite Database on USB using Comfort Panels (MTP1500)

Hello,

I am trying to connect to a SQLite database located in a usb that has been inserted in the X61 port of MTP1500 hmi. I am using TiaPortal V19.2 and the hmi runtime is V19 (since Siemens didn't release V19.2 yet...)

I followed this https://support.industry.siemens.com/cs/mdm/109828368?c=170611996171&lc=en-US

If I understood correctly the V19 firmware should already have all the ODBC drivers required built-in, so I copied the example connection string and modified according my use case

let connectionstring = "Driver={SQLite3}; Database=/media/simatic/X61/test.db; trusted_connection=yes;";

 Then I modified the example code provided and put into a pushbutton event

Hi!

And have you tried the X62 USB port?

In any case, the use of USB for registration is not recommended due to the number of writes and reads that can quickly damage the UBS.

Better to use the SD.

In the following link you can find information about the storage locations.

-> Storage locations of logs

https://support.industry.siemens.com/cs/ww/en/view/109828368/172650134411

 Thanks! This solved the problem, the connection string should not have spaces.....maybe that example should be fixed.

Stefan Arcularius

Hi,

Make sure there is no space before Database in your connection string.

Kind regards
Stefan

 Hello, thanks for your reply, I was not aware about the risks about using USBs. In my office we always use the SD but recently we noticed using USB can increase the speed of the trend pages quite a lot.

ALP00

Hi!

And have you tried the X62 USB port?

In any case, the use of USB for registration is not recommended due to the number of writes and reads that can quickly damage the UBS.

Better to use the SD.

In the following link you can find information about the storage locations.

-> Storage locations of logs

https://support.industry.siemens.com/cs/ww/en/view/109828368/172650134411