Error: Unable to open the database file
    Ray 
    ray at linkit.com
       
    Tue Apr  5 13:18:33 EDT 2016
    
    
  
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?
    
    
More information about the use-livecode
mailing list