[sqlite] Error 14 - SQLITE_CANTOPEN

[Otto Grunewald]

Hello,

 

The following is what my code looks like :

 

sqlite3 *db_handle;

char* errmsg;

char cStr(255);

 

sqlite3_open(&db_handle);

 

while (sqlite3_exec(db_handle, cStr, NULL, 0, &errmsg) != SQLITE_OK)

{

    printf("sqlite3_exec: %s - retry cnt: %i\n", sqlite3_errmsg(db_handle), 
++cnt);

    if (cnt > 100)

      break;

    usleep(50000);

    break;

}

 

sync();

 

sqlite3_close(db_handle);

 

The problem I'm having is the following.  After doing this a thousand (1000) 
times consecutively the sqlite3_exec function throws the following error : 
 
SQLITE_CANTOPEN    14   /* Unable to open the database file */
 
Does anybody know what the cause of this problem might be?
 
Am I using the correct functions?
 
Some assistance would be greatly appreciated.
 
Regards,
 
Otto Grünewald

 

 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users