Problem with connecting to SQLDatabaseMBS

Add-Ons
1

One of my users has a problem with connecting to an SQLDatabaseMBS on an external hard disk. The code is:

try
  Call InternalSQLiteLibraryMBS.Use
  dim OriginalName as String = OriginalFolderitem.NameWithoutExtensionMBS
  dim DBIndex as FolderItem = OriginalFolderitem.Parent.Child(OriginalName + "." + FileTypes.Index.Extensions)
  if not DBIndex.Exists then NeedToCreateIndex = True
  
  SQLiteIndexDBMBS = New SQLDatabaseMBS
  SQLiteIndexDBMBS.DatabaseName = "sqlite:" + DBIndex.UnixpathMBS
  SQLiteIndexDBMBS.AutoCommit = SQLDatabaseMBS.kAutoCommitOn
  
  'connect
  if SQLiteIndexDBMBS.Connect then
    ConnectedToSQLite = True
  else
    globals.theErrorLog.LogItem CurrentMethodName + " connect"
    globals.theErrorLog.DialogErrorProceed(kErrorConnectLocal)' + " " + kError + " " + SQLiteIndexDBMBS.ErrorMessage)
    ConnectedToSQLite = False
    Return False
  end if
catch Err as OutOfBoundsException
  Globals.theErrorLog.logitem(currentMethodName + " 1 ")
  Globals.theErrorLog.DialogErrorProceed(kErrorConnectLocal + EndOfLine + EndOfLine + kContact)
  Return False
end try

if NeedToCreateIndex then
  ConnectedToSQLite = CreateDatabaseLocalMBS
end if

try
  if ConnectedToSQLite and not IsICULoaded then
    
    IsICULoaded = InternalSQLiteLibraryMBS.LoadICU '<---- error here
    if not IsICULoaded then ConnectedToSQLite = False
    
  end if
catch Err as OutOfBoundsException
  Globals.theErrorLog.logitem(currentMethodName + " 2 ")
  Globals.theErrorLog.DialogErrorProceed(kErrorConnectLocal + EndOfLine + EndOfLine + kContact)
  Return False
end try

The ICU library can’t be loaded (see line “error here”). This lovely problem showed up a couple of times before. For this user the problem is reproducible. Any ideas about what causes this behaviour?

Xojo 2021r2, MBS Xojo Plugin 22.3, macOS 12.2

2

on macOS?

Did you get a Mac to reproduce it?
We simply load “/usr/lib/libicucore.A.dylib” here and I can add debug output to include dlerror() message.

3

Nope, never could. It’s been at least a year since the error showed up. A test plugin with more error messages would be helpful.