data connnection lost

[jenssedl]

I try to make testing with data base sqllite with ODBC in data module.

I log on to QMC and checking the data connection and we can find the new data connection is created.

I try several times still couldnot success then I try to clean the data connection.

I delete the new created connection from QMC.

I only select one lines to delete then I log out. 

later user told me data not updated and I log on and found many data connection record is lost.

It is very confuse I only delete one why so many lines is deleted also.

What reason lead to this and how I can know the exact reason?

BS

jens

[ajaykakkar93 · Accepted solution]

Hi,

Based on my understanding, you were attempting to establish a connection with SQLite using ODBC Connection. Although you tried to create a data connection in Qlik Sense, you were unable to do so on the first attempt. However, you were successful on your second attempt. Afterwards, you retrieved a single line using the same connection and attempted to delete a row in the database to verify its functionality. Unfortunately, all the data was deleted the next time you accessed the database, and the reason for this deletion is unknown. I suspect it may have been done manually or that the database became corrupted in some way.

Features of SQLite

• Embedded database: SQLite is a library that software developers embed in their apps.
• No configuration: SQLite requires no configuration.
• Serverless: SQLite has a server-less architecture.
• Zero-configuration: SQLite is a transactional SQL database engine.
• Uses .db files: SQLite uses .db files to store data.

Limitations of SQLite

• No CREATE DATABASE SQL statement: SQLite doesn't support the standard CREATE DATABASE SQL statement.
• No GRANT and REVOKE commands: SQLite doesn't support GRANT and REVOKE commands.
• No FOR EACH STATEMENT triggers: SQLite doesn't support FOR EACH STATEMENT triggers.
• No ALTER table statement: SQLite only allows adding a column or renaming a table using the ALTER table statement.

Creating a database in SQLite

• SQLite doesn't support the standard CREATE DATABASE SQL statement.
• You can create a database using a range of tools.
• You can use the SQLite function to create an SQLite object. You can use this object to connect to an SQLite database file using the MATLAB® interface to SQLite.