Some of SecWin issues in NTWS

[estadok]

Hi All!

I have some of NTWS apps with integrated SecWin. During the program work I can see some of strange mistakes. For example, I have an increment error, when inserting record to operators table (in-memory drv), then might be an error accessing security file, or "file not found", or "table structure in dct vs SQL is incorect", and most strange issue is, sometimes I can't login to my app. I have to recreate all users in secwin. I can't post the example because these errors are not permanent and appears from time to time.... But I have screenshots. If someone has these issues or something heard about it, please give an advice how to fix it. It's very comfortable to used SecWin, but these errors are drive me crazy :-((

[attachment deleted by admin]

[kevin plummer]

Just a thought... if you are using SQL have you set Mars and Busy handling?

[estadok]

Hi Kevin!

Yes I have set MARS and Busy handling in dct. But I don't understand how MARS affects on table structure or other errors

[Bruce]

I'm not sure it's a secwin issue. (the second screenshot does not appear to be Secwin related.)

I suspect you have an issue connecting to the database, or possibly the connection to the database is being lost at some point.
Is the web server running on the same machine as the database?

BTW - what builds of Clarion / NetTalk are you using?

cheers
Bruce

[estadok]

Hi Bruce!

Yes, the web server running on the same machine as the database. Clarion is 9.0.10376 and NT is 7.26. Here are other errors screenshots. 

[attachment deleted by admin]

[kevin plummer]

Are you running FM3? If so there is a template setting to set MARS and Busyhandling driver string and you should use it as this driver string only needs to be set on the first table to connect with the DB which happens to be the FM3 table.

[estadok]

No I don't use the FM3. Kevin could you explain me how errors on "error3.png" depends on MARS and Busyhandling. Maybe I miss something in my dictionary?

[kevin plummer]

It depends how you set busy handling. Can you post your driver string? The other issue could be Table locking. I have never seen the invalid File error message.