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免费邮箱百分百防垃圾信
