At 6:44 PM -0400 13/8/06, Roger Clary wrote:
I guess I need a crash course in DB management because I don't
completely understand what's going on here.
I am creating a RBSQLDatabase in my app and working with it on my
local machine very successfully. Today I wanted to test putting the
DB on one of the other machines in our home network. My app will
programatically place the new DB on the remote machine, and I can
see the file, but I get a "File locked" error when the DB tries to
connect (DB.connect)
I even tried just starting a new project and adding a new RB DB.
Choosing "New Database" adds the Db to my project and I can see the
file on the remote machine, but when I double click the DB file I
get the msg "Cannot connect to database"
The volumes where I am placing the DB are mounted on my Mac via smb
(They are both Windows XP machines)
What do I need to do to connect successfully? Am I even able to do
this using "included" RBSQLdatabase?
Thank you in advance for helping to clear up my confusion.
I thought that SQLite didn't like being served from remote disks and
that they had to be local.
Perhaps this is what you are seeing?
At 7:57 AM -0400 25/10/05, wrote:
> I'm currently investigating a problem with my application, SQLite
3.2.5 and a database located on a Mac OSX Server network share that
does not seem to repro with the SQLite 3.1.3 that ships with Mac OSX
4.1. Specifically if I place a SQLite database file on a folder on a
remote network share and attempt to access it using the sqlite3
utility, I get different results.
Apple added special hacks to their release of SQLite 3.1.3 that
allow it to work on remote filesystems with broken file locking.
For various reasons, those hacks have not been incorporated into
the SQLite core, yet.
--
D. Richard Hipp
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
http://www.macsos.com.au
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
