Devin - thanks for the idea but that's not it. I just checked and
everything on my Windows 8.1 system matches case with the database file
path on the Linux server. I even tried changing the name of the
database file to all lower case but that didn't work either. Thanks...
On 4/5/2016 3:38 PM, Devin Asay wrote:
Ray,
You may have moved your DB file from a system that is not case sensitive, like
MacOS, to one this is case sensitive, like Linux. Do all of your folders and
file names have the same exact spelling, including upper and lower case
letters, as the string in your path variable?
Devin
On Apr 5, 2016, at 12:39 PM, Ray <r...@linkit.com> wrote:
...one other note. I'm guessing calls to sqLite need drivers. These drivers
are probably built in to Livecode and the OnRev server which would explain why
LC's database commands works so well locally and with the OnRev based samples.
If this is the problem, does anybody know how I could install these drivers on
my own server?
On 4/5/2016 1:18 PM, Ray wrote:
I've never worked with sqLite databases before but it appears I should be able
to access one on a server pretty much the same as I do locally.
Here's what I've done:
put revOpenDatabase("sqLite",localPath) into theDbId --
this creates a zero K local database file
put "CREATE TABLE bugs(Name char(50), Date char(50))" into myQuery
revExecuteSQL theDbId,myQuery -- the local database file is no 2 K
revCloseDatabase theDbId -- close it or I won't be able to copy it to the
server
I then copy the local database file to a remote server and make sure all 9
permissions are checked (777).
I now load the well-tested server path into the variable dbPath and try this:
put revOpenDatabase("sqLite",dbPath) into myResult
but all I get back is:
Error: Unable to open the database file
Suggestions?
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
Devin Asay
Office of Digital Humanities
Brigham Young University
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode