Re: Error: Unable to open the database file

Ray Tue, 05 Apr 2016 15:58:48 -0700

Peter - thanks for jumping in here. Yes, I can read and write files tothis location and, as a matter of fact, I can even do a straight read ofthe database file on the server and get the same cryptic characters backI get when I read the local copy. I just can't establish a connectionto it for the purpose of issuing revDatabase calls.

You're right when you say the "unable to open the database file" is notvery informative. I get the same message when I try that on an emptypath on the server.


I'll try your sqLite3 suggestion and let you know how it works.

Thanks!

On 4/5/2016 6:34 PM, Peter Haworth wrote:

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 <r...@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 <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

_______________________________________________
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

Re: Error: Unable to open the database file

Reply via email to