[sqlite] SQL Lite version 3.0.7 not reconizing sqlite databases While version 2.8.15 does

[Steve Frierdich]

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.