On Tue, Aug 26, 2014 at 8:44 AM, 王庆刚 <2004wqg2...@163.com> wrote:
> hi, Andy Ling:
> The error disk I / o error I have resolved ;
> but when I used the following code:
> rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",&db);
> it tell me can not find the data base;
>
Have you tried instead:
rc = sqlite3_open("D:/WindRiver/SqliteOne.db", &db);
I do not have access to VxWorks, but as VxWorks is supposed to be POSIX, I
suspect that it would use the POSIX "/" directory separator rather than the
Windows "\\" directory separator.
I'm also suspicious of the "D:" prefix, which I do not believe to be POSIX,
but again, I do not know enough about VxWorks to say whether or not that
will work.
>
> when I used the following code:
> rc = sqlite3_open("SqliteOne.db",&db);
> It is OK
>
>
> How could I resolve the prolblem?
>
>
>
>
>
>
> At 2014-08-25 11:29:57, "Andy Ling" <andy.l...@quantel.com> wrote:
>
> That file name in the first error doesn't look like a vxWorks file. What
> devices have you got mounted. You need to specify a file path that points
> to one of the vxWorks file IO devices. By just specifying the file name in
> your second example it is being created in the current directory.
>
> The second disk I / O error is what I had before applying the patch to
> unixUnlink. The error returned by vxWorks when deleting a file that doesn't
> exist depends on the underlying file system. If it is a POSIX file system
> it should return ENOENT. For dosFS it returns S_dosFsLib_FILE_NOT_FOUND,
> which in vxWorks 6.9 is 0x380003
>
> So if you are using yet another file system, maybe you are getting a
> different error code being set. start by adding a printf to unixUnlink to
> find out if that is your problem.
>
> Regards
>
> Andy Ling
>
>
>
> From: 王庆刚 [2004wqg2...@163.com]
> Sent: 25 August 2014 13:13
> To:sqlite-users@sqlite.org; Andy Ling; Jan Nijtmans
> Subject: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？
>
>
> hi
> I modified the code sqlite3.c according to you method, as follow
>
>
> <
> http://fossil-scm.org/index.html/vpatch?from=dd5743a8239d1ce9&to=b68f65bb69a098a1>
> or <http://fossil-scm.org/index.html/info/c2d4bd7365>
>
>
> I test you method in workbench3.2(vxworks6.8) , the build macros which I
> used in build properties is : -DOS_VXWORKS=1 -DSQLITE_THREADSAFE=0
> -DSQLITE_OMIT_LOAD_EXTENSION -DHAVE_UTIME
>
>
> but it still have some problems.
> 1. if I do as follows:
> rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",&db);
> it tell me the error can not open the database.
>
>
>
>
> 2. if I do as follows:
> rc = sqlite3_open("SqliteOne.db",&db); this will be ok .
> but when I do the following thing
> sql = " create table stu(i int, name text);";
> rc = sqlite3_exec(db,sql,NULL,NULL,&err);
> it tell me the error : disk I / O error.
>
>
>
>
>
>
> 在 2014-08-12 08:10:13，"Jan Nijtmans" <jan.nijtm...@gmail.com> 写道：
>
> 2014-08-03 9:56 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>:
>
> 2014-08-02 16:00 GMT+02:00 王庆刚 <2004wqg2...@163.com>:
>
> > hi ， Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for
> Vxworks6.8 ?
> > When I compile them , there have so many problems .
>
>
> You can find the necessary changes here:
> <
> http://fossil-scm.org/index.html/vpatch?from=dd5743a8239d1ce9&to=b68f65bb69a098a1
> >
> thanks to Andy Ling.
>
> Still has to be reviewed by the SQLite developers for inclusion in 3.8.6
> (not tested yet on other platforms than vxworks, win32/64 and Linux,
> there it works fine)
>
>
>
> New attempt here, base on current SQLite trunk:
> <http://fossil-scm.org/index.html/info/c2d4bd7365>
>
>
> Regards,
>
> Jan Nijtmans
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
