does sqla12 create .lnk files?

[Former Member]

I was setting up sqla12 with a new customer and noticed that the sqla12 engine suddenly quit. I looked at the event log and found this event: Blocked by access protection rule. Access to object c:\\users...\\AppData\\Roaming...\\resq.lnk.

Does sqla12 create any *.lnk files when processing? Does it create any other files in the Users...\\AppData\\Roaming... directory?

Thanks, Doug

[Breck_Carter]

.lnk files are generally shortcuts. I have never known any running SQL Anywhere engine to ever create a shortcut anywhere.

Why do you suspect that this event log entry has anything to do with SQL Anywhere?

A google search indicates "Blocked by access protection rule" comes from McAfee.

[Former Member]

Breck, I guess I suspected sqla because the sqla engine stopped and the event log mentioned blocked access due to a protection rule. I will ask the customer to turn off McAfee for a trial period to see if sqla stays up and running. Thanks!

[g_g_99]

off topic: can't configure McAfee to check a directory or file/ file type like Symantec's end point protection and others?

I prefer not to totally turn off any malware protection whenever possible

[Breck_Carter]

IMO McAfee **is** malware but that's just me talking 🙂

[regdomaratzki]

Unlikely, but I don't suppose SQL Remote is involved? The FILE and FTP SQL Remote message system will create files with these extensions (right after writting a file with the .lnl extension), but I can't imaging how that would cause the database engine to shut down, or why they'd be written to the AppData\\Roaming directory, unless that was the current directory of the dbremote executable and you haven't specified a root directory. As I continue to type, I feel like the odds of this being the case are smaller and smaller and I'm wasting my time here.

If this is the case, I can imagine virus/malware software on a machine getting upset about SQL Remote creating files with a .lnk extension, which is exactly why we have the 'invalid_extensions' SQL Remote option for the FILE and FTP messaging system.

http://dcx.sybase.com/index.html#sa160/en/sqlremote/set-remote-option-statement.html

[MarkCulp]

SQLAnywhere will create some files in a subdirectory (SQL Anywhere [ver]) of the %APPDATA directory which, on Windows (depending on version), will default to be in the user's AppData\\Roaming\\ directory.

I am not aware of any .LNK files being created by SQL Anywhere (in the "SQL Anywhere [ver]" directory). Other products using SQLA may create these files?