The SqlException has a Number property that you can check. For duplicate error the number is 2601. catch (SqlException e) { switch (e.Number) { case 2601: // Do something. break; default: throw; } } To get a list of all SQL errors from you server, try this: SELECT * FROM sysmessages Update This can now … Read more
The problem is not the id column. From the statement it looks like you have quotes around all columns. Therefore it seems to the SQL, that you have only one column ‘”title”,”url”,”age”‘ What you might want to have is “insert into table(title, url, age) values (‘” + title + “‘,'” + url + “‘,” + … Read more
Your URL should be jdbc:sqlserver://server:port;DatabaseName=dbname and Class name should be like com.microsoft.sqlserver.jdbc.SQLServerDriver Use MicrosoftSQL Server JDBC Driver 2.0
SQLiteOpenHelper onCreate() and onUpgrade() callbacks are invoked when the database is actually opened, for example by a call to getWritableDatabase(). The database is not opened when the database helper object itself is created. SQLiteOpenHelper versions the database files. The version number is the int argument passed to the constructor. In the database file, the version … Read more