in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Browse by Tags

  • Invalid database Path

    hello to all i have a problem on connecting to database coz its always says invalid path i'm using windows mobile 5.0 .net 2005 my code is vb, i'm running in my local pc emulator what should i do to connect to database what correct connection string or where should i put my database..please help...
    Posted to How To (Forum) by kumander on 08-19-2010
  • Connection string properties

    Hello, Let's say I set page size and synchornous pragmas during creating a database from visual studio. Do I need to include them in my connection string every time I open it or is it per database setting? Thanks.
    Posted to General (Forum) by mcnamara on 05-12-2010
  • Parameter for foreign key support in the connection string?

    Hi, I'm interested in turning on the foreign key support when connecting to the database. I know that it is "pragma foreign_keys = ON" but it doesn't work in the connection string... Moreover it doesn't work if I try to turn on later: cmd.CommandText = "PRAGMA foreign_keys...
    Posted to General (Forum) by tsomogyi on 01-15-2010
  • Keyword not supported?

    Hi All, I'm fairly new to using SQLite ADO.NET provider, but not C# and ADO in general, so I'm a bit stummped as to why I'm getting Keyword not supported: 'data source'. When i try the following theNamesContext db = new theNamesContext("Data Source=C:\\Documents and Settings...
    Posted to General (Forum) by shawty_ds on 11-28-2009
  • SQLiteDataAdapter.Fill(datatable)

    Hi everyone i have a problem with the sqlite data adapter when i try to execute fill() method for filling the datatable; when querying the DateTime column in table where that column is NULL. I get the following exception: String was not recognized as a valid DateTime. i found somewhere that...
    Posted to Bugs (Forum) by leo_Mostar on 11-21-2008
  • Re: "Unable to open the database file"

    Dear all, After struckling around with this exception for months I finally found a solution for my product. And thanks to Robert to include the Journal Mode in the SQLiteConnectionStringBuilder. First of all make very sure that the users have write access to the folder the database is created or installed...
    Posted to Bugs (Forum) by IJsbrand on 07-28-2008
  • Problems with connection string and special characters

    Hello! We are using version 1.0.49.0 of System.Data.SQLite. We have problems building a connection string if the path to the database file contains a '='. After some searching we found http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx (search for...
    Posted to Bugs (Forum) by rdreier on 06-25-2008
  • NGEN/JIT Issue with SQLiteConnectionStringBuilder, Regex.Compile

    I recently converted a program to use NGEN at installation time. The program is a .NET 3.5 app. The confusing thing is that even after NGEN, I would get 9 JITted methods! I was looking at the app in Process Explorer. The JIT DLL (mscorjit.dll I think) was also loaded. So I had to figure out what was...
    Posted to Bugs (Forum) by Sam on 02-16-2008
  • SqliteConnectionStringBuilder not threadsafe

    Please note: This is Microsoft bug, not a bug in System.Data.Sqlite. I have submitted this bug to Microsoft, but thought it prudent to submit it here as well. SliteConnectionStringBuilder inherits from DbConnectionStringBuilder, which (eventually) uses ReflectTypeDescriptionProvider.ReflectGetProperties...
    Posted to Bugs (Forum) by jpwkeeper on 12-18-2007
  • database not found

    Hi Robert I use your product for my application. My connection string us like this "Data Source=pub.s3db;New=True;UTF8Encoding=True;Version=3;Pooling=True". At first query to the database. It was perfectly no problem. But when I open new file using the open dialog/save dialog ( the environment...
    Posted to Bugs (Forum) by ms_breeze1012 on 12-14-2007
Page 1 of 2 (13 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems