Hi zhang jie, I don’t think there was a problem on the creation and updating of the database. You see, I log every sql statement execute from database creation and updates, and I didn’t see any sql error or any error in that case. Also, I open the database using command line in linux and it works fine.
-----Original Message----- From: ½Ü ÕÅ [mailto:[EMAIL PROTECTED] Sent: Monday, March 13, 2006 7:39 PM To: sqlite-users@sqlite.org Subject: [sqlite] why i can not open the new database i created at AT91ARM9200? Hi ryan bel brillo, First of all,thank you for your reply. The problem is not a compatibility with database created in linux and windows . I downloaded source code sqlite-2.8.17.tar.gz through your website under windows OS. But I gunziped and cross-compiled it for AT91ARM9200(development board) under linux OS. I run the binary file "sqlite" at AT91ARM9200. #./sqlite test.sqlite //Am I creating a new database"test.sqlite"? sqlite>CREATE TABLE test(name varchar(80); SQL erro:unable to open database test.sqlite # #./sqlite test.db //Am I creating a new database"test.db"? sqlite>CREATE TABLE test(name varchar(80); SQL erro:unable to open database test.db # # vi test.sqlite # chmod 777 test.sqlite # ./sqlite test.sqlite sqlite>CREATE TABLE test(name varchar(80)); SQL erro:can not write to test.sqlite,it is readonly file. sqlite> # vi test.db # chmod 777 test.db # ./sqlite test.db sqlite>CREATE TABLE test(name varchar(80)，num smallint); SQL erro:can not write to test.db,it is readonly file. sqlite> So why i can not open the new database i created at AT91ARM9200? I guess i didn't create database correctly,aren't you? sincerely zhang jie ryan bel brillo <[EMAIL PROTECTED]> 写道： Hi all, Im new in this list and with sqlite. Im not sure if this topic have been discussed before. Anyway, I have this problem regarding sqlite. I created a c program that would create a new sqlite database from some sql file then update it every five minutes using sql statement stored in a postgresql database. Im using a version 3.3.2 sqlite database and sqlite3 library in c. The sqlite database and c program was executed in a linux OS. When I tried to open my created database in a SQLite database browser in windows It shows nothing but in linux it shows the correct tables and data. Also, I create a sqlite database in windows then open it in linux it works fine. Also, I created a simple sqlite database manually but it still cant be read in windows. Is there a compatibility problem with database created in linux and windows? I remember this problem on occurs on sqlite version 2.6.2 or earlier.. Or is there a problem in the way I create the database? The sqlite browser im using can read sqlite database version 3.x. Thanks --------------------------------- 雅虎1G免费邮箱百分百防垃圾信
