Skip to main content

Database Administration Tool for SQLite

I have been looking for a SQLite database administration tool and I have seen this tool: SQlite Expert Personal. It is completely free and includes all common features such as query builder, data editing, import/export data etc.

SQLite Expert Personal

Download: http://www.sqliteexpert.com/SQLiteExpertPersSetup.exe

In order to find out more managing tools for SQLite, have a look at this web site: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

Solved: “Syntax error in INSERT INTO statement” error that shows up when you connect Access via C#/SQL

Inserting date/time string to database via SQL is generally problematic. Your interpreter (which is Visual Studio in my case) might show up this error:

“Syntax error in INSERT INTO statement”

Solution is adding wrapping square brackets around date (because date is a reserved word) and # signs around the string (it points out the date) like you will see below:

cmd.CommandText = "INSERT INTO AlarmHistory ([Date]) VALUES (#6/8/2012#)";

If It still doesn’t work, check your Access settings. Here is convenient settings for my example:

Settings on Access table

Check the reserved words for Microsoft Jet 4.0: http://support.microsoft.com/kb/321266/en-us

Solved: “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine” error when connecting to Access via C#

As you want to connect Microsoft Access database on Visual Studio (by clicking “Connect to Database” button on “Server Explorer” console), you may face this error:

“The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine”

Incompatiblity error between Office and Visual Studio
Incompatiblity error between Office and Visual Studio

Cause

This error shows up because your Operating System and Office installation have different platform types (32bit, 64bit). It ends up with different Visual Studio platform type.

Solution

Follow these steps: