Welcome to the SQLitening support forums!
Started by Fim, May 20, 2017, 07:16:09 am
Quote--- Local Mode ---If the FileName is not fully pathed then it is assumed to be relative to the current folder which is the same folder, unless changed by chdir, that the first .Exe was run from. If fully pathed then no assumptions are made. Since this running on a local computer SQLitening allows the files to be located anywhere on the local hard drives or local network drives.Examples: If your .Exe started in C:\Apps\MyApp then:If FileName is X\Y\Able.Sld then will assume file is in C:\Apps\MyApp\X\Y.If FileName is ..\Y\Able.Sld then will assume file is in C:\Apps\Y.If FileName is C:\Able.Sld then no assumption.--- Remote Mode ---The FileName is assumed to be relative to the folder which the service is running from. Since this is running on a remote server SQLitening can not allow the user to access files anyplace on the server. Access is denied to any FileName that has a colon, a double dot, or begins with a backslash. This will insure that the file is in same folder as the service or below it.Examples: If your service is running from C:\SQLitening then:If FileName is Data\Able.Sld then will assume file is in C:\SQLitening\Data.If FileName is ..\Y\Able.Sld then will get error -8 Access Denied.If FileName is C:\Able.Sld then will get error -8 Access Denied.Code Example:' Create a new databaseslOpen "DBFirst.db3", "C"slExe "Create Table If Not Exists Table1 (Field1, Field2, Field3)"slClose' Create a second database and attach the firstslOpen "DBSecond.db3", "C"slExe "Create Table If Not Exists Table1 (Field1, Field2, Field3)"slAttach "ExampleB_New1.Sld", "One"