Re: [sqlite] Create table error on AIX -- Unable to open database "mytest": SQL logic error or missing database

2008-04-07 Thread Dennis Cote
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

Re: [sqlite] Create table error on AIX -- Unable to open database "mytest": SQL logic error or missing database

2008-04-06 Thread Chris Pierce
John Stanton wrote: > > I had a problem compiling Sqlite on ealrier > versions of AIX. It turned out to be a linker > problem and compiling without the -g optimization > solved the problem. The configure process shows an entry that says: checking whether accepts -g... no I edited the

Re: [sqlite] Create table error on AIX -- Unable to open database "mytest": SQL logic error or missing database

2008-04-06 Thread John Stanton
I had a problem compiling Sqlite on ealrier versions of AIX. It turned out to be a linker problem and compiling without the -g optimization solved the problem. What compiler are you using? Xlc or gcc? Chris Pierce wrote: > Hi, > > I am having problems with SQLite v3.5.7 on AIX v5.2. > > I

[sqlite] Create table error on AIX -- Unable to open database "mytest": SQL logic error or missing database

2008-04-05 Thread Chris Pierce
Hi, I am having problems with SQLite v3.5.7 on AIX v5.2. I downloaded the amalgamation tarball. It looks like it builds fine, but I get an error when I try to create a table. Here's what I'm doing/getting: AIX$ ./sqlite3 test.db SQLite version 3.5.7 Enter ".help" for instructions sqlite>