Error: Unable to open the database file

[Peter Haworth]

You might want to try opening the database with something other than
Livecode in hope that you will get a more informative error message.
 sqlite3 is the official sqlite command line tool.  It's distributed with
OSX but not sure if it's included with Windows.

Are you able to access any other files in the same directory as the sqlite
db?

On Tue, Apr 5, 2016 at 1:31 PM Ray <ray at linkit.com> wrote:

> 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 <ray at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>