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> create table mytest(first smallint); Unable to open database "mytest": SQL logic error or missing database AIX$ I've searched the list's archives and seen some similar problems, but I have been unable to fix the problem. Looking through the config.log file I guess it's not building fine. Here are a few things from the log that may or may not help in troubleshooting: 1) configure:3025: cc -c -Os conftest.c >&5 "conftest.c", line 15.14: 1506-275 (S) Unexpected text me encountered. "conftest.c", line 15.8: 1506-045 (S) Undeclared identifier choke. configure:3031: $? = 1 configure: failed program was: | /* confdefs.h. */ | #define PACKAGE_NAME "sqlite" | #define PACKAGE_TARNAME "sqlite" | #define PACKAGE_VERSION "3.5.7" | #define PACKAGE_STRING "sqlite 3.5.7" | #define PACKAGE_BUGREPORT "http://www.sqlite.org" | #define PACKAGE "sqlite" | #define VERSION "3.5.7" | /* end confdefs.h. */ | | int | main () | { | #ifndef __GNUC__ | choke me | #endif | | ; | return 0; | } 2) configure:3279: cc -c -Os conftest.c >&5 "conftest.c", line 45.39: 1506-195 (S) Integral constant expression with a value greater than zero is required. configure:3285: $? = 1 configure: failed program was: | /* confdefs.h. */ 3) configure:3279: cc -qlanglvl=extc89 -c -Os conftest.c >&5 1506-173 (W) Option langlvl=extc89 is not valid. Enter xlc for list of valid op tions. "conftest.c", line 45.39: 1506-195 (S) Integral constant expression with a value greater than zero is required. I'm not sure if any of this is helpful or not. There are more errors like this. I can send the whole config.log if needed. Oh, the system has cc, but doesn't have gcc, FWIW. BTW, I used the Windows version to create a small test database that works fine in Windows, but when I try to use it with the AIX build I still get the error: AIX$ ./sqlite3 test.db Unable to open database "test.db": SQL logic error or missing database AIX$ Sorry for the long message, but if anyone could help I would greatly appreciate it. I'm not much of a C programmer, I'm rusty on *nix, and I'm not an admin on this system. Please let me know if there is other information I need to send that might help in fixing the problem (or if I'm just completely missing the obvious cause). Thanks! Chris [EMAIL PROTECTED] ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users