Browse by Tags

Insert fails when program run as windows service

Hi, I have a very simple application which starts a thread that creates a new database and the associated tables if it doesn't exist yet. It then inserts new data into the table every 10s. The whole thing works just nice when I run the thread from a regular windows foms application. As soon as I...

Posted to General (Forum) by Grizzly on 10-09-2011
SQLITE_MAX_COLUMN

Question: Is it possible to create a table with more than 3000 columns/fields? I found this environment variable (SQLITE_MAX_COLUMN) on the SQLite site and it appears to default to 2000 max columns but can be changed. However, I don't see any reference to it here so I'm not sure how to change...

Posted to How To (Forum) by precipios on 09-12-2011
Help make batch insert faster

according to this post http://sqlite.phxsoftware.com/forums/t/134.aspx, i am inserting this way Dim conn As SQLiteConnection = New SQLiteConnection("Data Source=" & dbPath) 'conn.SetPassword(dbPassword) conn.Open() Dim mytransaction As SQLiteTransaction = conn.BeginTransaction() Dim...

Posted to General (Forum) by oghenez on 05-20-2011
.Net 4.0 & SQLite 1007000 sample

I created a .net 4.0 WinForm appi with SQLite embedded and want to share the source code.. So here it is [ MyBlog ] [ Code Project ] So have fun and enjoy...

Posted to How To (Forum) by Kribo on 05-02-2011
Some Kind of Disk I/O Error Occurred - NOT using Device Emulator!

Greetings! I have recently started coding in C# after many years of experience with scripting languages (Perl, TCL) and Powerbuilder. I am working on a C# version of a TCL program that I wrote, and have decided to use a database on the back end. I am working in Visual Studio 2008, and have added SQLite...

Posted to Bugs (Forum) by Jonathan on 07-30-2010
Two Date Inserts -- One works and one fails -- Why? (SOLVED)

I have two insert routines to insert a record into each of two tables. The date field is typed as "Date." The first insert (new member) works while the second one (record attendance) fails. In fact, the VS2010 designer won't let me put in the date type saying it is not a DBType. It also...

Posted to General (Forum) by rkulp on 06-15-2010
c# database file is locked error

Hi there! i am using sqlite the latest version and i am using the latest version of the ado.net connector. I have created a database with sqlite admin and saved the file in the debug folder of my application. I code in c#. I have a login page that works perfectly, it opens a connection runs a WHERE clause...

Posted to Bugs (Forum) by casserlyprogramming on 05-21-2010
Read + insert = too many records

Greetings! I think I am completely misusing ADO.Net. I am hoping people here can straighten me out or point me to a better place to answer my question. I am writing to 124 SQLite database files once a minute. It is possible for one or more of those files to be locked when I try to write to it. In that...

Posted to General (Forum) by Interrobang on 05-13-2010
SQLiteCommand.ExecuteNonQuery() consuming memory

Greetings! I have a Windows service whose purpose is to write a new row to a small table (three columns) in each of 124 SQLite databases once a minute. The service's memory allocation grows slowly over time, at a rate of about two megabytes an hour. Since, like all services, my service is designed...

Posted to General (Forum) by Interrobang on 04-23-2010
How do i speed this method up?

Here it is: Public Shared Sub SQLite_ExecuteNonQuerys(ByVal table As DataTable) If SQLite_Connect() = False Then Return End If Dim adapter As New SQLiteDataAdapter() adapter.SelectCommand = New SQLiteCommand(String.Format("SELECT * FROM {0}", table.TableName), SQLite_Connection) Dim update...

Posted to General (Forum) by alex21 on 02-03-2010

Page 1 of 2 (14 items) 1 2 Next >