Hi,
I post here because is not really DB related.
Question n.1
I have an app that connect to an SQLITE DB.
If the EXE is on a shared folder the DB in the same folder (so I use relative path), can the remote user launch the EXE and using it or the path is messed?
Question n.2
I have an app that connect to an MySQL DB (MariaDB).
If the EXE is on a shared folder and the DB in the localhost, can the remote user on another PC launch the EXE and using it or the server path is messed?
Complex situation and DB
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Complex situation and DB
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
Re: Complex situation and DB
Hi,
In your case this may work - the target db should be the same, no matter from where the .exe is called. Assuming Win as OS (".exe") and a fixed LC version (because you'll find differences in working/ not working of relative paths in different OS and LC versions).
Have fun!
I've found out that using relative paths with databases is calling for problems. So I'd strongly suggest the use of absolute paths - they are easy enough to construct.
In your case this may work - the target db should be the same, no matter from where the .exe is called. Assuming Win as OS (".exe") and a fixed LC version (because you'll find differences in working/ not working of relative paths in different OS and LC versions).
I'd assume the db is searched on the machine from where the .exe is called.
Have fun!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
Re: Complex situation and DB
I have done some tests for the sqlite DB.
Using local path and same folder of exe and sqlite file is the best option.
This way many users on different PCs can use the same EXE and the same DB those are on a shared folder.
I'll investigate on the MySQL case.
Using local path and same folder of exe and sqlite file is the best option.
This way many users on different PCs can use the same EXE and the same DB those are on a shared folder.
I'll investigate on the MySQL case.
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w