Error: Unable to open the database file

Ray ray at linkit.com
Wed Apr 6 10:03:48 EDT 2016 

I actually haven't created the database yet so I guess it makes sense to 
use mySQL from the beginning instead of sqLite, thus eliminating the 
need to import one into the other.  Nonetheless, I'll still need 
middleware as I don't think Livecode can make direct calls to a mySQL 
database on a server as it does to a sqLite database locally (which was 
my original goal).

On 4/6/2016 9:54 AM, Ralph DiMola wrote:
> Ray,
>
> An http file reference is not a valid UNC for read/write file access. If you
> want to connect remote users to a DB then import the SQLite DB into a MySQL
> DB and have the users connect to the MySQL server and all the record locking
> would be in place. You could go LC server middleware but that would be a
> fair amount of work.
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdimola at evergreeninfo.net
>
> -----Original Message-----
> From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
> Of Ray
> Sent: Tuesday, April 05, 2016 10:51 PM
> To: use-livecode at lists.runrev.com
> Subject: Re: Error: Unable to open the database file
>
> Mike - if I set the folder to the area I've set up to work with this,
> "http://54.210.118.224/Downloads/", I get "can't open that directory"
> returned in the result.  I can read files at that location but I get an
> "error 405 method not allowed" if I try to write files to that location.
> Could that be the problem?
>
> Regarding mapping the server to a drive letter or mounting it to a folder on
> the local system, even if that worked I wouldn't be able to expect my end
> users to do that so it's kind of out unless I'm missing something.
>
> Thanks for your input and let me know if anything else comes to mind.
>
> On 4/5/2016 10:33 PM, Mike Bonner wrote:
>> can you map the server to a drive letter?  (or mount it to a folder on
>> the local system)  If so, that might help.
>>
>> Alternatively, can you "set the folder.." to a path on the server and
>> see "the files"?  If you can successfully set the default folder, then
>> you can just supply the filename and see if it behaves differently.
>>
>> On Tue, Apr 5, 2016 at 5:58 PM, Ray <ray at linkit.com> wrote:
>>
>>> I did read some about the file locking issues so I'll continue to
>>> look into that.
>>>
>>> Regarding testing with sqLite3, I'm not sure what to do with it.  I
>>> downloaded the pre-compiled binary for Windows 64.  It gave me 2
>>> files, sqlite3.def and sqlite3.dll but I'm not sure what to do with
>>> them.  Shell commands from within Livecode don't work.  Suggestions?
>>>
>>>
>>> On 4/5/2016 7:22 PM, Peter Haworth wrote:
>>>
>>>> I suppose I should also mention the usual caveat about using sqlite
>>>> over a networked file system, which is that sqlite relies on file
>>>> system locking to preserve data integrity and some networked file
>>>> systems are buggy in that area according to the sqlite website.
>>>>
>>>> On Tue, Apr 5, 2016, 3:57 PM Ray <ray at linkit.com> wrote:
>>>>
>>>> Peter - thanks for jumping in here.  Yes, I can read and write files
>>>> to
>>>>> this location and, as a matter of fact, I can even do a straight
>>>>> read of the database file on the server and get the same cryptic
>>>>> characters back I get when I read the local copy.  I just can't
>>>>> establish a connection to it for the purpose of issuing revDatabase
> calls.
>>>>> You're right when you say the "unable to open the database file" is
>>>>> not very informative.  I get the same message when I try that on an
>>>>> empty path 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 <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
>>>>>>>
>>>>>>> _______________________________________________
>>>>>> 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
>>>>>
>>>>> _______________________________________________
>>>> 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
>>>
>> _______________________________________________
>> 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
>
>
> _______________________________________________
> 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

More information about the use-livecode mailing list