Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL
Thanks for persisting with me on this, I recompiled it as your email below and it now runs in both windows and linux. I have not tried the Debug version again, so the problem first time around could have been finger trouble. On a side note it look like I'm also getting a memory leak in linux. Will keep investigating and open a new thread if I find anything. Thanks again. Grant On 25 July 2011 05:47, Joe Mistachkin wrote: > Very odd, with the "UseSqliteStandard" property enabled, that error message > should not be possible. > > How are you compiling the SQLite.Interop project? > > When you compiled the System.Data.SQLite assembly, did you use the real > MSBuild (i.e. not XBuild)? > > The command line I gave you would have produced a "Debug" build, did you > grab > the assembly from that directory? > > For a "Release" build, you can use the following command line (all on one > line): > >MSBuild System.Data.SQLite.2008.csproj /t:Rebuild > /p:Configuration=Release > /p:UseInteropDll=false /p:UseSqliteStandard=true > > One potential problem I thought of the other day was the casing of the file > extension on the DLLs. I checked in a change to make the file extensions > for > the DLLs all lower case. > > Another possible issue is (although, this was Windows specific): > >https://bugzilla.novell.com/show_bug.cgi?id=636915 > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Grant Dunoon www.TryBooking.com Tel: +61 (0) 402 993 808 Tel: +61 (3) 9012 3460 Skype (W): grant.dunoon Email: gr...@dunoon.com.au ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL
Very odd, with the "UseSqliteStandard" property enabled, that error message should not be possible. How are you compiling the SQLite.Interop project? When you compiled the System.Data.SQLite assembly, did you use the real MSBuild (i.e. not XBuild)? The command line I gave you would have produced a "Debug" build, did you grab the assembly from that directory? For a "Release" build, you can use the following command line (all on one line): MSBuild System.Data.SQLite.2008.csproj /t:Rebuild /p:Configuration=Release /p:UseInteropDll=false /p:UseSqliteStandard=true One potential problem I thought of the other day was the casing of the file extension on the DLLs. I checked in a change to make the file extensions for the DLLs all lower case. Another possible issue is (although, this was Windows specific): https://bugzilla.novell.com/show_bug.cgi?id=636915 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL
Thanks Joe but no luck. I tracked down the folders that are referenced by LD_LIBRARY_PATH in the Linux OS and copied in SQLite.Interop.DLL into it with no luck. >>MSBuild System.Data.SQLite.2008.csproj /t:Rebuild /p:UseInteropDll=false /p:UseSqliteStandard=true I then created the dll as above except now I'm getting: Unable to find an entry point named 'sqlite3_open_interop' in DLL 'System.Data.SQLite.DLL'. In both Windows and Linux. Not sure what is going on. Thanks Grant On 23 July 2011 16:15, Joe Mistachkin wrote: > > > > I upgrade to the latest Managed Only System.Data.SQLite 1.0.74.0 which I > > understand I have to rename sqlite.so to SQLite.Interop.dll > > /SQLite.Interop.DLL (tried both) and placed in the apps bin folder. > > > > Alternatively, you can compile the System.Data.SQLite project using: > > MSBuild System.Data.SQLite.2008.csproj /t:Rebuild /p:UseInteropDll=false > /p:UseSqliteStandard=true > > This will produce a managed assembly that looks for a shared library named > "sqlite3". > > > > > When I run the app and try to access the database i'm getting the > > error: System.DllNotFoundException: SQLite.Interop.DLL. > > > > I seem to recall that the LD_LIBRARY_PATH may need to be modified to > actually > look in the bin folder for the application? I could be wrong here because > I > am not an expert on Mono. > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL
> > I upgrade to the latest Managed Only System.Data.SQLite 1.0.74.0 which I > understand I have to rename sqlite.so to SQLite.Interop.dll > /SQLite.Interop.DLL (tried both) and placed in the apps bin folder. > Alternatively, you can compile the System.Data.SQLite project using: MSBuild System.Data.SQLite.2008.csproj /t:Rebuild /p:UseInteropDll=false /p:UseSqliteStandard=true This will produce a managed assembly that looks for a shared library named "sqlite3". > > When I run the app and try to access the database i'm getting the > error: System.DllNotFoundException: SQLite.Interop.DLL. > I seem to recall that the LD_LIBRARY_PATH may need to be modified to actually look in the bin folder for the application? I could be wrong here because I am not an expert on Mono. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.DllNotFoundException: SQLite.Interop.DLL
Hi I am really trying to get my head around whats happening as I can't seem to find any examples. I have a asp.net app running on x86 Ubuntu(11.04)/Apache2/Mono(2.6.7 ASP.NETVersion: 2.0.50727.1433). The app was running OK with the Managed Only System.Data.SQLite.dll (1.0.66.0) which I understand uses the linux systems sqlite.so. I upgrade to the latest Managed Only System.Data.SQLite 1.0.74.0 which I understand I have to rename sqlite.so to SQLite.Interop.dll /SQLite.Interop.DLL (tried both) and placed in the apps bin folder. When I run the app and try to access the database i'm getting the error: System.DllNotFoundException: SQLite.Interop.DLL. I have been able to run the app on Windows with the windows interop dll, so I even tried coping over that version to see if it would at least see the dll and try and rule out any compile time setup issues. But no, just got the same message: System.DllNotFoundException: SQLite.Interop.DLL So I'm not sure what I'm doing and could really do with guidance. Thank you Grant ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users