Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jenssedl
Contributor III
Contributor III

data connnection lost

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

 

Labels (1)
1 Solution

Accepted Solutions
ajaykakkar93
Specialist III
Specialist III

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.

 

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

View solution in original post

1 Reply
ajaykakkar93
Specialist III
Specialist III

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.

 

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting