I can think of one possibility offhand: The application is running as 32-bit and the extension DLL is 64-bit (or vice-versa).
Sent from my iPhone https://urn.to/r/mistachkin > On Mar 17, 2017, at 5:02 PM, Phil Pollock <philpoll...@hotmail.com> wrote: > > I can't get the LoadExtension() function to work under Visual Studio 2015 > Express C#. I have tried to load several extensions that do work under the > SQLite console but they will not load under C#. So I created the minimal > example of an example extension given on sqlite.org using the half.c source. > It loaded and worked under the SQLite console but failed to load it in a > simple C# program with the code snippets shown here: > > > ... > > using System.Data.SQLite; > ... > > SQLiteConnection m_dbConnection; > > ... > > string str_extension_path = @"C:\Users\Admin\Documents\Visual Studio > 2015\Projects\half_ext\half.sqlext"; > > ... > > string str_DB_Connect = "Data Source=" + > textBox_DBPath.Text.ToString() + "; Version=3;"; > m_dbConnection = new SQLiteConnection(str_DB_Connect); > m_dbConnection.Open(); > m_dbConnection.EnableExtensions(true); > m_dbConnection.LoadExtension(str_extension_path); > ... > > The program had this exception when the .LoadExtension() executed: > > "An unhandled exception of type 'System.Data.SQLite.SQLiteException' occurred > in System.Data.SQLite.dllexception > Additional information: SQL logic error or missing database > > The specified module could not be found." > > I've tried many other approaches, for example, using SELECT > load_extension('half.sqlext'), and rebuilt everything in x86 and x64 but to > no avail. > > Does anyone have a working example with source of an extension and a working > VS 2015 C# program that loads it? Or doesn't this feature work. > > TNX > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
