In the Sqlite version 3.0.7 I used the sqlite3_get_table function that fails with a return value of 26, which is:
"File opened that is not a database file ".
Both version used the same database. Why does one function work in the one version and the same type of function function fail in another? Do I now have to go through and recreate all the databases used in sqlite version 2.x.xx in a new sqlite explorer?
Thanks Steve
Steve Frierdich wrote:
The same databases that are recognized and work in Sqlite version 2.8.15 are not recognized in Sqlite version 3.0.7. When the sqlite function sqlite3_get_table is called using version 3.0.7 the result is 26 which is:
File opened that is not a database file
When the same function is used in version 2.8.15 the result is 0 which is:
SQLITE_OK
Can some one tell me why the function work sin one version and not the other.
Sqlite is a Win32 DLL and the calling application is a Win32 application. Both the DLL and the Win32 application was created using Visual Studio.
Steve
MacLeod, Kenneth wrote:
Changing a process wide variable like that seems a bit drastic. I'd be
concerned about what effect that might have on all the other things running
under iis. For example, some of them might be running as different users
who might not have access to the path.
Thanks.
-----Original Message----- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: 07 October 2004 13:56 To: [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite3_temp_directory
MacLeod, Kenneth wrote:
Is there any way to change the sqlite3_temp_directory global? I'm running
sqlite under iis and the user doesn't have write access to their temp
directory.
On windows you can leave sqlite3_temp_directory alone (leave it as NULL) and set the TMP environment variable to the directory you want to use.
