Oh -- and the database opens fine -- it only fails when I try and call
sqlite3_prepare_v2() to check if a table exists in the database
sql = pragma table_info('mytablename');
... it returns with the SQLITE_IOERR_ACCESS error.
So the file exists and is good. If I recompile without the 3rd party DLL and
run the exact same code it's fine.
Thanks,
Rail
-------------------------------------------------
On Apr 5, 2016, at 6:43 PM, Simon Slavin <slavins at bigfraud.org> wrote:
>
> On 6 Apr 2016, at 2:11am, Rail Jon Rogut <sqlite3 at platinumsamples.com>
> wrote:
>
>> sql = pragma table_info('mytablename');
>> Sqlite3 log: 3338 Err: os_win.c:37516: (0)
>> winAccess(C:\MyAppPath\Databases\mydatabase.db-journal) - The operation
>> completed successfully.
>> Sqlite3 log: 3338 Err: disk I/O error
>
> Presumably you mean that if you try the same thing and the other program
> isn't running, you get no problem. And that the problem does occur without
> fail when the other program is running.
>
> Also, just because it's so unusual I just want you to restate that these two
> programs are trying to open different databases. At least that's what I
> understood from your post.
>
> Please can you run whatever tools your OS provides for checking disk
> formatting and directory structure, just to ensure that your problem is not
> caused by a corrupt disk.
>
> Can you write some code which tries to open the database file(s) just using
> plain file commands (presumably fopen() or something like that) ? Does this
> code also get 'disk I/O error' ?
>
> Another thing to try would be to download the SQLite shell tool and try using
> that to open the database instead. Do you get the same problem ?
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
