SQLite Connection Write returned an error

Asked By Daniel S Davis 0 points N/A Posted on - 12/26/2013

Hi DBA’s,

I am a beginner to SQLite finding very hard to trace the errors and solutions for it. This is the syntax error I am getting and I have this error for some of my other database too. So please help me to resolve this issue and help me to learn more. Here the syntax should end with period?

Sorry,SQLiteConnection Write returned an error.

Check the event log for details.

SQLite error

near “s”: syntax error

• Status: Open
• Question Views: 637
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Alan Keyes 0 points N/A #178259

SQLite Connection Write returned an error

Hello There SQLite throws “SQLite error Near “s”: syntax error” to indicate there is something wrong in select statement. If you use select, it would say.. Near“x”. So check your query first, you did not put the query here, otherwise we could have tried to check it once.Actually, people who tend to use Oracle, MYSQL, DB2,SYBASE faces some issue with SQLite, because of syntactical difference. Escape characters are differently used also

About Alan Keyes

Questions
0

Answers
100

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 05/10/2014
• Question Category: Database