How about just posting your COMPLETE code example for your console app. Some of us can't import a VS2012 project I just sent you a complete example that works. Are you saying this doesn't work for you?
#include <stdio.h> #include "sqlite3.h" main() { sqlite3 *oDatabase; int returnValue; returnValue = sqlite3_open_v2("D:/SQlite/testing.db", &oDatabase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, NULL); if (returnValue != SQLITE_OK ) { printf("%d: %s\n",returnValue,sqlite3_errmsg(oDatabase)); } else { printf("Got it\n"); } } -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Collie Sent: Friday, April 05, 2013 9:47 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL Logic error or missing database Nothing seems to be overly weird, and the console app is a fresh project, with very little changed. I'm compiling under 32-bit in VS2012 using the amalgamation files. I can attach my test project if needed. I'm really rather curious to know what I broke. On Fri, Apr 5, 2013 at 4:28 PM, Noel Frankinet <noel.franki...@gmail.com>wrote: > it's time to check your compiler setting, anything weird ? Are you sure you > have the source code of sqlite for windows ? 32 or 64 bits settings ?? > > > On 5 April 2013 16:24, Rob Collie <rob.col...@gmail.com> wrote: > > > Same problem, I'm afraid. I've tried just about every combination > suggested > > in http://www.sqlite.org/c3ref/open.html > > > > > > On Fri, Apr 5, 2013 at 4:18 PM, Kevin Benson <kevin.m.ben...@gmail.com > > >wrote: > > > > > On Fri, Apr 5, 2013 at 10:08 AM, Rob Collie <rob.col...@gmail.com> > > wrote: > > > > > > > Yeap, I'm on Visual Studio 2012. I've created a console app: > > > > > > > > > > > > sqlite3 *oDatabase; > > > > int returnValue; > > > > returnValue = sqlite3_open_v2("file://C:/Newfolder/testing.db", > > > > & oDatabase, SQLITE_OPEN_CREATE, NULL); > > > > if (returnValue != SQLITE_OK ) > > > > { > > > > //sqlite3_close(oDatabase); > > > > return returnValue ; > > > > } > > > > int anyKey; > > > > return 0; > > > > > > > > It returns 21. Checking the other project, the open actually does > > return > > > 21 > > > > too. > > > > > > > > > > > > > Three(3) forward slashes for the Internet path style in Windows, maybe? > > > > > > file:///C:/Newfolder/testing.db > > > -- > > > -- > > > -- > > > --Ô¿Ô-- > > > K e V i N > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Noël Frankinet > Strategis sprl > 0478/90.92.54 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users