in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » connection string (RSS)

Browse by Tags

  • 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

  • Connection String

    How do you build a connection string? I have seen some examples like this: Data Source=C:\\folder\\file.db;Version=3;New=False;Compress=True But I don't know what this parameters mean or if there are more parameters that could be used. Thanks, am65
    Posted to How To (Forum) by am65 on 10-26-2007

  • ConnectionString in settings

    Hi! maybe this question shouldn.t appeer here but.... i'll try :) I made dataset and connection string with wizard. It wrote connection string into ....exe.config file. How can I change string in COnnectionString dynamically in my application? I want to give in menu an option to change default database...
    Posted to How To (Forum) by Wiaz on 09-23-2007
Page 1 of 2 (11 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems