Which DLL gets loaded first?

[blueb]

I am including "libmariadb.dll" with my program.

Since users may have an older version of MariaDB installed on their machines, would:

Code: Select all

str.s = GetCurrentDirectory() + "libmariadb.dll"
UseMySQLDatabase(str)

force the User's machine to use MY version of "libmariadb.dll" and not the one in their system?

[Mijikai]

The directory from which the application loaded is searched first.

msdn:

Standard Search Order for Desktop Applications:
1.The directory from which the application loaded.
2.The system directory. Use the GetSystemDirectory function to get the path of this directory.
3.The 16-bit system directory. There is no function that obtains the path of this directory, but it is searched.
4.The Windows directory. Use the GetWindowsDirectory function to get the path of this directory.
5.The current directory.
6.The directories that are listed in the PATH environment variable.

[blueb]

The reason I ask is because I spotted the following in the Help files...
Result = OpenLibrary(#Library, Filename$)
Filename$: "The filename of the library to load. If the filename does not include a path, then the operating system will search for the library in its system folders, the applications directory and the current directory".

Makes it sound like:
#1 - system folders
#2 - applications directory
#3 - current directory

And I was thinking if it grabs the systems folder first, my included DLL won't be loaded.

Thanks

[skywalk]

Yes, it is better to explicitly define the path to your library.

Code: Select all

CompilerIf #SQLITE_USE_DLL  ;-! USE sqlite3.dll
  #SQLITE_DLL_FNPATH$ = "C:\MyDB\sqlite3.dll"
  ;#SQLITE_DLL_FNPATH$ = "C:\Program Files\DB Browser for SQLite\sqlite3.dll"
  ;#SQLITE_DLL_FNPATH$ = "C:\Program Files\DB Browser for SQLite\sqlcipher.dll"
  UseSQLiteDatabase(#SQLITE_DLL_FNPATH$)
CompilerElse
  #SQLITE_DLL_FNPATH$ = #Empty$
  ;BUG;UseSQLiteDatabase(#SQLITE_DLL_FNPATH$)
  UseSQLiteDatabase()
CompilerEndIf

[mk-soft]

Put it in the same path as program

Code: Select all

program_path.s = GetPathPart(ProgramFilename())
libmariadb_path.s = program_path + "libmariadb.dll"
UseMySQLDatabase(libmariadb_path)

With macOS i use my tool MyAppData to copy the libraries into [APP]/Contents/Library

Code: Select all

Macro GetParentPath(Path)
  GetPathPart(RTrim(path, #PS$))
EndMacro

program_path.s = GetPathPart(ProgramFilename())
libmariadb_path.s = GetParentPath(program_path) + "Library/libmariadb.dylib"
Debug "Path = " + libmariadb_path

UseMySQLDatabase(libmariadb_path)

[blueb]

Thanks Fellas... good advice.

I hate leaving things to chance!