data connnection lost

jenssedl — Wed, 01 Nov 2023 04:55:05 GMT

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?

jens

Re: data connnection lost

ajaykakkar93 — Wed, 01 Nov 2023 07:13:37 GMT

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.

topic data connnection lost in App Development

data connnection lost

Re: data connnection lost