Forum > problem firedac sqlite

07-07-2020, 05:25 PM:

Hi,

i have developped an intraweb application in delphi, with intraweb 15, with delphi 10.3.3 with firedac and sqlite database , intraweb applicaton is standalone

when i start my exe every thing is ready, that work in web navigation.

when i close web browser , is ok

when i want new session i have an error

if i use another web browser the first time that work well just one time

after i close web browser if i want start new sessio i have problem

Have you any idea ?

thank's a lot for your help

best regards

Patrice

07-07-2020, 06:20 PM:

1) "an error" is not very descriptive. This is like calling 911 and saying "Help I have a problem" and then hanging up.

2) I suggest you reproduce the error while running in the IDE and finding out where it occurs and what the error is.

07-07-2020, 07:49 PM:

the problem is

404 - Not found

Resource not found in JWData

if i use other webbrowser is ok

example, firefox first use ok second use firefox after close web browser, i have this message

[b]404 - Not found[/b]

Resource not found in [b]JWData

[/b]

[b]have any ideas ?[/b]

[b]what i must close in usersession unit ?[/b]

[b]what are doing when you close web browser ?[/b]

[b]thank' a lot[/b]

[b]best regards[/b]

07-08-2020, 10:41 AM:

hello,

i have resolve problem by using server controleur option wizzard !

why, i don't know !

now other problem

impossible use encryt database, i have test all encrypt,

work well wiith unencrypted database sqLite firedata delphi

the are delphi run time error in regist and i can't read database.

so have you source code example in delphi routine for open encryted database in intraweb use.

my code work well in normal delphi application but not in intraweb

Have you any soluce ?

thank's lot best regards

Patrice

07-08-2020, 03:17 PM:

Encryption and decryption is a function totally within whatever DB you are using, not IntraWeb. Likely you have some options wrong or are missing a required decryption option or key in your DB connection options.

07-10-2020, 01:43 AM:

(07-08-2020, 10:41 AM)softdev85 Wrote: [ -> ]hello,

i have resolve problem by using server controleur option wizzard !

why, i don't know !

now other problem

impossible use encryt database, i have test all encrypt,

work well wiith unencrypted database sqLite firedata delphi

the are delphi run time error in regist and i can't read database.

so have you source code example in delphi routine for open encryted database in intraweb use.

my code work well in normal delphi application but not in intraweb

Have you any soluce ?

thank's lot best regards

Patrice

What do you mean by encrypt database? Are you trying to encrypt the content of some field before posting it back?

Basically anything can be used withing IntraWeb applications, so I don't see exactly what kind of problem you are having