Mac RealSQLDatabase connections in a network shared folder

[Greg <rbnuglist at stretchedout dot com>]

I'm creating a desktop app for helping with my daily billing tasks  
and wanted to use RealSQLDatabase (RB2006 Mac OS X 10.4.5).  
Everything runs fine if I run the app on my local computer (the  
database file is stored in the folder with the app), but if I  
transfer the app and the database file to our Mac OS X 10.4.5 Server,  
I get an error when trying to connect to the file about the database  
being locked. I can tell you that the file is not locked, I can run  
the app by going to the server, logging in as me, and the db opens  
just fine. My code looks like this:
Function connectdb() As boolean
  dim f as FolderItem
  dim tf as Boolean
  db = new REALSQLDatabase

  f = GetFolderItem("").child("backend.rsd") 'File will always be  
located in the directory with the app
  if f<>nil then
    db.DatabaseFile = f
    if f.Exists then 'If it exists, use it
      tf = db.Connect() '<----------- TF SET TO TRUE IF THE DATABASE  
FILE IS LOCATED ON OUR SERVER.
      return tf 'Doing it this way so we can look at the error code
    else 'if not, create a new one
      return db.CreateDatabaseFile()
    end if
  else
    return false
  end if
End Function

This code works just fine on Windows XP to the same server (using  
Apple's SMB sharing).
Anyone seen this? Workarounds? Help?

Greg

P.S. - I also tried running the app locally, connecting to the  
database in the remote directory. No Dice.
_______________________________________________
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>