Is it possible to download only the dll? The download options are an msi and a source zip, but no binary without installer.

Edit: By the way, what is the purpose of the msi?

The MSI file is a Microsoft Installer file.  It does the following:

1. Prompts you for a location to extract the files
2. Extracts the files to the specified location
3. Adds a couple icons to the Start Menu for easy access to the Design-Time installer for VS2005
4. Runs the Design-Time install.exe program so you can choose which environment you want to install VS design-time support for.

If you just want the binaries themselves and would rather pick what ones you want, go here:

http://sqlite-dotnet2.cvs.sourceforge.net/sqlite-dotnet2/SQLite.NET/bin/

The main binary in the above link is the x86 32-bit binary.  The other binaries are in subdirectories corresponding to the processor architecture.

Robert

 

Thanks a lot for the clarification. I guess I'm just a bit allergic to installers :)

Hello

I download the dll file from the address you post and I'm getting this error:

Description: Error processing request.

Error Message: HTTP 500.

Stack Trace:

System.DllNotFoundException: System.Data.SQLite.DLL
  at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_open_interop (byte[],intptr&)
  at System.Data.SQLite.SQLite3.Open (System.String strFilename) [0x00000] 
  at System.Data.SQLite.SQLiteConnection.Open () [0x00000] 
  at Common.DataAccess.Provider.Open () [0x00000] 
  at Common.DataAccess.Provider.OpenDataReader (System.String sqlStatement) [0x00000] 
  at Common.DataAccess.Persistency`1[olimpo.Data.tbl_CORE_Page].GerateDataReader (olimpo.Data.tbl_CORE_Page , System.String ) [0x00000] 
  at Common.DataAccess.Persistency`1[olimpo.Data.tbl_CORE_Page].GetObject (olimpo.Data.tbl_CORE_Page , System.String ) [0x00000] 
  at Common.DataAccess.DataPersistency`1[olimpo.Data.tbl_CORE_Page].GetObject (System.Collections.Generic.Dictionary`2 ) [0x00000] 
  at olimpo.Theme.Manager.LoadTheme (System.Web.UI.Page myPage) [0x00000] 
  at olimpo.WebUI.Default.Page_Load (System.Object sender, System.EventArgs e) [0x00000] 
  at (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
  at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000] 
  at System.Web.UI.Control.LoadRecursive () [0x00000] 
  at System.Web.UI.Page.InternalProcessRequest () [0x00000] 
  at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] 

What can I do to resolve  this?

tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal

I've never seen this error before.  Did you rename the DLL perchance? 

Robert

 

Hello ..

I renemed the dll  because the MonoDevelop only load references with .dll extention and not .DLL and then I get that error.

I go arround this problem and I made the reference a .DLL file and now I'm gettinh this error:

Server error in '/' application

---

Description: Error processing request.

Error Message: HTTP 500.

Stack Trace:

System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.36.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies.
File name: 'System.Data.SQLite, Version=1.0.36.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139'
  at <0x00000> <unknown method>
  at Common.DataAccess.ProviderFactory.CreateConnection (System.String connectionString, DatabaseEnumType databaseType) [0x00000] 
  at Common.DataAccess.Provider..ctor (System.String connectionString, DatabaseEnumType databaseType) [0x00000] 
  at Common.DataAccess.DataPersistency`1[olimpo.Data.tbl_CORE_Page].GetObject (System.Collections.Generic.Dictionary`2 ) [0x00000] 
  at olimpo.Theme.Manager.LoadTheme (System.Web.UI.Page myPage) [0x00000] 
  at olimpo.WebUI.Default.Page_Load (System.Object sender, System.EventArgs e) [0x00000] 
  at (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
  at System.Web.UI.Control.OnLoad (System.EventArgs e) [0x00000] 
  at System.Web.UI.Control.LoadRecursive () [0x00000] 
  at System.Web.UI.Page.InternalProcessRequest () [0x00000] 
  at System.Web.UI.Page.ProcessRequest (System.Web.HttpContext context) [0x00000] 

I'm using this driver in Linux and System.Data.SQLite.dll is a diferente file from System.Data.SQLite.DLL

can you release a .dll file? I can test in linux and see if everything is ok.

tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal

Well, one workaround is to make a copy of System.Data.SQLite.DLL to System.Data.SQLite.dll and have them both in the same folder.

I'll see what I can do in future builds.

Robert

 

I just realized something important ...

You said you were using this library in Linux ...

The System.Data.SQLite.dll is a Win32 mixed-mode assembly and won't run in Linux.  The managed portion of the assembly should work fine under Mono, but the native portion of the assembly was compiled in native C++ for the Windows platform.

If you need this thing to work in Linux, you'll have to build a Linux version of it yourself -- I don't even pretend to understand Linux development ...

Robert

 

I have to revive this old thread...

So I cannot use the System.Data.SQLite.dll under Linux with Mono - even the managed dll ?

Can anybody provide me with his self compiled Linux version then?

If you download the managed only version of System.Data.SQLite, then you can use it on Mono.

The provider requires that you have the shared library SQLite 3.6.1 or higher, and have it compiled with SQLITE_ENABLE_COLUMN_METADATA #define'd.

If you're experiencing specific errors when running on Mono, let me know and I'll try and assist.

Robert Simpson:

If you download the managed only version of System.Data.SQLite, then you can use it on Mono.

 

I do use the managed one.

 

Robert Simpson:

The provider requires that you have the shared library SQLite 3.6.1 or higher, and have it compiled with SQLITE_ENABLE_COLUMN_METADATA #define'd.

Do you or anybody else know the exact name of the module I have to install using apt-get or aptitude on Debian Etch?

Robert Simpson:

If you're experiencing specific errors when running on Mono, let me know and I'll try and assist.

I get this error on Linux:

error CS0234: The type or namespace name `SQLite' does not exist in the namespace `System.Data'. Are you missing an assembly reference?

The System.Data.SQLite.dll and System.Data.SQLite.xml is in the Bin subfolder, the Default.aspx.cs includes the reference "using System.Data.SQLite;"

In Windows everything works fine.

Any ideas?

 

Thanks for your kind help!

 Any idea why I get this error message on Linux:

 

error CS0234: The type or namespace name `SQLite' does not exist in the namespace `System.Data'. Are you missing an assembly reference?

 Thanks for any help!

probably due to a missing reference at compile time ...

Robert Simpson:

probably due to a missing reference at compile time ...

 

You know that I'm talking about developing Webpages in ASP.NET?

The Webpage runs fine within Visual Web Developer 2008 Express, so the general syntax is fine, reference is "using System.Data.SQLite;"

Is anything else needed to install the DLL in Linux? Or is it sufficient to have the dll in the "Bin"-Folder of the Webpage?

For linux (I assume Mono) deployment, you need to deploy the ManagedOnly binary, and you need to have compiled SQLite into a shared library and be using SQLite 3.6.1 or higher.  Search on the forums for the compiler options and preprocessor symbols you need when building SQLite on linux.