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