Chris Pierce wrote: > > Here's what I'm doing/getting: > > AIX$ ./sqlite3 test.db > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> create table mytest(first smallint); > Unable to open database "mytest": SQL logic error or > missing database > AIX$ >
There is something fishy going on here. The filename you provide on the command line is "test.db", but the file SQLite says it can't create is "mytest". Is this really a copy of what you entered and th emessages SQLite produced, or is it a hand edited version? I suspect you may have a permission problem in the directory where you are trying to create the database file. You must have write permission in that directory. Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users