[Very Importan] Erorr connect sqlite with password and error with type Long in ling

[tinamore]

Hi Everybody.
I just bought LinqConnect Professional single license.
But I have 2 issues that need resolving with LinqConnect Professional with SQLite :
1.Can't Connect database file SQLite with Password Encrypted. An error occurred :"File opened that is not a database file
file is encrypted or is not a database".
- I've filled out the correct password in Connection editor, Other management programs SQLite are connected with password that normally.
- Image error occurred :


2. Can't submit with add value Int64 to colums Long type in Ling An error occurred :{"Value was either too large or too small for an Int32."},
- Image error occurred :

(Please open image to new tab to see full size)

Please Help me fix 2 error. Thanks.

[MariiaI]

When configuring the connection properties, you should select the type of encryption (e.g., SEE, CEROD, SQLiteCrypt) and set a password in the Advanced options menu.
In case the Encryption type is set to "None" - there is no sense to set up a password, and no action will not be performed.
JIC: If you use an assembly, that differs from the one that is included into our installation, make sure that it supports encrypted databases.

As for the second issue, we have reproduced this error. We will investigate it and inform you about the results as soon as possible.
As a workaround, you can use DbType "BIGINT" for the "MoneyFirst" property. To do this:
- open Property Editor for the MoneyFirst property and set "Server Data Type" to "BIGINT";
- save changes.

[tinamore]

Thanks for support.
- The second Error was solved very well.
I set "Server Data Type" to "BIGINT" and my project is worked.
(But to default "Server Data Type" INTEGER is error, please fix this error as soon as possible)

- As for The first issue. I see only [ SEE, CEROD ] . Not see "SQLiteCrypt". The database is normal encryption . I've used "Navicat for SQLite" to Encrypted.Link http://navicat.com/en/products/navicat_ ... rview.html

[Pinturiccio]

We have not found any information about which encryption algorithm is used by Navicat for SQLite. There is no information about SQLiteCrypt encryption algorithm on http://navicat.com. We dont support third-party encryption algorithms except for the ones that can be used by SQLite engine as extensions.

Maybe, Navicat for SQLite uses its own encryption algorithm and only Navicat for SQLite can open a database, encrypted with it.

Or, if it uses SEE or CEROD encryption algorithms, you need to purchase the respective SQLite extension, because our provider works with SEE and CEROD encryption only if you have the corresponding extension.

But to default "Server Data Type" INTEGER is error, please fix this error as soon as possible

We will definitely inform you when the issue with the types long(System.Int64) and integer is fixed.

[MariiaI]

But to default "Server Data Type" INTEGER is error, please fix this error as soon as possible

The bug with the types long(System.Int64) and integer has been fixed. It will be available in the next build of dotConnect for SQLite. We will inform you when the corresponding build is available for download.

[MariiaI]

New build of LinqConnect 4.1.82 is available for download now!
It can be downloaded from http://www.devart.com/linqconnect/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=31&t=24844