Re: [sqlite] sqlite 3.25.1 windows function. So it should be?

[Clemens Ladisch]

Djelf wrote:
> SQLSTATE[42803]: Grouping error: 7 ERROR:  column "t.v3" must appear in the 
> GROUP BY clause or be used in an aggregate function
>
> It seems to me that sqlite should issue a similar message.

This is allowed for compatibility with MySQL.
And there is a case with min()/max() where this is actually useful:



Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.25.1 windows function. So it should be?

[Djelf]

I understood what's the matter. The query was incorrect.

I tested this on posgresql.

SQLSTATE[42803]: Grouping error: 7 ERROR:  column "t.v3" must appear in the
GROUP BY clause or be used in an aggregate function

It seems to me that sqlite should issue a similar message.

Correct query is

SELECT 
v1,v2,sum(sum(v3+v4)) OVER (PARTITION BY v2 ORDER BY v1) as val 
FROM t 
GROUP BY v1,v2; 

v1  v2  val
1   1   10001
2   1   10011
3   1   1





--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.25.1 windows function. So it should be?

[Clemens Ladisch]

Djelf wrote:
> INSERT INTO t (v1,v2,v3,v4) VALUES
> (1,1,1,0),(1,1,0,1),(2,1,0,10),(3,1,0,100),(3,1,0,1000);
>
> SELECT
>   v1,v2,sum(v3+v4) OVER (PARTITION BY v2 ORDER BY v1) as val
> FROM t
> GROUP BY v1,v2;
>
> v1v2  val
> 1 1   1
> 2 1   10010
> 3 1   10110
>
> Yes, I know that v1 is duplicated, but whether the result should disappear
> 10011?

Looks correct.  The Postgres manual explains it this way:
> If the query contains any window functions, these functions are
> evaluated after any grouping, aggregation, and HAVING filtering is
> performed. That is, if the query uses any aggregates, GROUP BY, or
> HAVING, then the rows seen by the window functions are the group rows
> instead of the original table rows from FROM/WHERE.


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite 3.25.1 windows function. So it should be?

[Djelf]

Hi!

Maybe I do not understand something, but does it really have to work this
way?

DROP TABLE IF EXISTS t;
CREATE TABLE t (v1,v2,v3,v4); 
INSERT INTO t (v1,v2,v3,v4) VALUES
(1,1,1,0),(1,1,0,1),(2,1,0,10),(3,1,0,100),(3,1,0,1000);
SELECT 
v1,v2,sum(v3+v4) OVER (PARTITION BY v2 ORDER BY v1) as val
FROM t

v1  v2  val
1   1   10001
1   1   10001
2   1   10011
3   1   1
3   1   1

SELECT 
v1,v2,sum(v3+v4) OVER (PARTITION BY v2 ORDER BY v1) as val
FROM t
GROUP BY v1,v2;

v1  v2  val
1   1   1
2   1   10010
3   1   10110

Yes, I know that v1 is duplicated, but whether the result should disappear
10011?

---
Anton Azanov



--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite C# Windows Store Apps

[Martin Křížek]

Hi,
can any one write some suggestion (I mean nuget package(s)) for creating
Windows Store App in C# with SQLite? In desktop apps I use simply
"System.Data.SQLite (x86/x64)" which I love because it allows me to write
SQL statements directly. Are there any good (ideally with examples or
documentation) packages that really works with Windows Store Apps posted to
Store?
Thanks in advance.

Best regards

Martin Krizek

Re: [sqlite] SQLite and Windows 95

[BlackWingCat]

Hi.

http://blog.livedoor.jp/blackwingcat/archives/1813730.html
I compiled SQLite 3.7.17 and 3.8.0.2 for Windows 95 before.

If you want to know the reason why it would not work on Win95, see the
following article.
http://blog.livedoor.jp/blackwingcat/archives/1804729.html




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/SQLite-and-Windows-95-tp5271p77748.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in Windows Phone Runtime Component

[Joe Mistachkin]

Arne Fischer wrote:
>
> { "AreFileApisANSI", (SYSCALL)AreFileApisANSI, 0 }, 
> 
> And the Error is:
> Error   2   error C2065: 'AreFileApisANSI' : undeclared identifier 
> 

In order to compile SQLite for Windows Phone 8, the following extra defines
are
normally necessary:

-DSQLITE_OS_WINRT=1
-DWINAPI_FAMILY=WINAPI_FAMILY_PHONE_APP
-DSQLITE_OMIT_LOAD_EXTENSION=1
-DSQLITE_WIN32_FILEMAPPING_API=1

Alternatively, you can use the VSIX package for Windows Phone 8.  It was
designed
for use with Visual Studio 2012; however, it may be possible to get it
working
with Visual Studio 2013.

http://visualstudiogallery.msdn.microsoft.com/cd120b42-30f4-446e-8287-45387a
4f40b7

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite in Windows Phone Runtime Component

[Arne Fischer]

I want to use native c++ code within my WindowsPhone 8 Application. For this 
purpose I did build a "Windows Phone Runtime Component" to wrap my c++ code. I 
simply compile my native code with visual studio when I compile the Runtime 
Component. This took some tweaking but Visual Studio is now compiling.

Now my native Code needs sqlite. For other platforms I was able to just compile 
sqlite3 with my native code and got it to run. But I just can't get it to work 
with Visual Studio. My native class looks like this:

#include "Main.h"
#include 
#include 
#include 

//visual studio needs additional imports for std
#if defined(_MSC_VER)
#include 
#include 
#endif

void NativeClass::testDataBase() {
//some sql stuff here
}

What I have tried:

1. 
My first Idea was to try to solve this like I did for iOS and android. I tried 
to include the sqlite header and .c files. I also tried all options and 
compiler flags listened here. When I do this with a Win32 project it compiles 
just fine. But when I try to compile it for my Runtime component I get a lots 
of errors belonging to lines like this:

{ "AreFileApisANSI", (SYSCALL)AreFileApisANSI, 0 }, 

And the Error is:
Error   2   error C2065: 'AreFileApisANSI' : undeclared identifier

2. 
The Next idea was to just import the headers and Link the binaries. With all a 
lot of different errors and problems this keeps failing. Usually going back to 
the problem, that I'm not able to compile or find a working and for arm 
compiled lib.

I'm asking for ways to solve this here. This could be a solution on how to get 
one of my approaches to work. Or it could be a completely different way to 
solve this.

This problem is driving me crazy. I just can't get it to work. Any help would 
be appreciated.

I'm working with Visual Studio 2013. And I have Windows running in Parallels on 
a Mac.


Mit freundlichen Grüßen/Kind regards,
Arne Fischer
Mobile Developer

let's dev GmbH & Co. KG

Phone: +49 (0) 721-78 80 27 30
Fax: +49 (0) 721-78 80 27 31
Email: arne.fisc...@letsdev.de  (PGP-Key:FD5FBCC8)
Internet: http://www.letsdev.de

Postanschrift/Mailing Address:
Alter Schlachthof 23C 
76131 Karlsruhe
Germany

Amtsgericht/Commercial Register: Mannheim - HRA 705058
Gesellschaftssitz/Registered Office: Karlsruhe

Komplementär/General Partner: W & W Verwaltungsgesellschaft mbH
Amtsgericht/Commercial Register: Mannheim - HRB 717324
Gesellschaftssitz/Registered Office: Karlsruhe
Geschäftsführer/Managing Director: Christian Wack, Karl-J. Wack



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Andrew Arnott]

Hi Joe,

Thanks for the workaround. It works!

Is there a place where a bug should be filed to track this?

--
Andrew Arnott
"I [may] not agree with what you have to say, but I'll defend to the death
your right to say it." - S. G. Tallentyre


On Tue, Mar 11, 2014 at 3:30 PM, Joe Mistachkin wrote:

>
> Andrew Arnott wrote:
> >
> > I tried adding sqlite3_set_directory to the sqliteWP8.cpp file but it got
> > too intense for my limited C++ knowledge.
> >
>
> If the Windows Phone 8 wrapper for SQLite does not properly set the
> temporary
> directory, queries that requires a temporary file (e.g. VACUUM) may fail.
>
> Until the wrapper package is changed to do this, the workaround would be to
> open a database connection and then immediately execute the following
> query:
>
> "PRAGMA temp_store_directory = 'C:\some\temp\directory';"
>
> Using the ApplicationData.LocalFolder property for the temporary directory
> value should work fine.
>
> --
> Joe Mistachkin
>
> ___
> 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

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Joe Mistachkin]

Andrew Arnott wrote:
> 
> I tried adding sqlite3_set_directory to the sqliteWP8.cpp file but it got
> too intense for my limited C++ knowledge.
> 

If the Windows Phone 8 wrapper for SQLite does not properly set the
temporary
directory, queries that requires a temporary file (e.g. VACUUM) may fail.

Until the wrapper package is changed to do this, the workaround would be to
open a database connection and then immediately execute the following query:

"PRAGMA temp_store_directory = 'C:\some\temp\directory';"

Using the ApplicationData.LocalFolder property for the temporary directory
value should work fine.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Andrew Arnott]

Hi Joe,

Thanks for your reply. After making that change (and also adding the
SQLite3.SetDirectory method definition itself since that too was inside an
#if) the app crashes because WP8 doesn't support the TemporaryFolder
property.

'Windows.Storage.ApplicationData.Current.TemporaryFolder' threw an
exception of type 'System.NotImplementedException'

When I replaced the use of TemporaryFolder with just LocalFolder, the line
again threw an exception, but with one I couldn't figure out how to
workaround:

System.NotSupportedException occurred
  _HResult=-2146233067
  _message=DllImport cannot be used on user-defined methods.
  HResult=-2146233067
  Message=DllImport cannot be used on user-defined methods.
  Source=Dart.WinPhone8Lib
  StackTrace:
   at SQLite.SQLite3.SetDirectory(UInt32 directoryType, String
directoryPath)
   at SQLite.SQLiteConnection..ctor(String databasePath,
SQLiteOpenFlags openFlags, Boolean storeDateTimeAsTicks)
  InnerException:

I tried adding sqlite3_set_directory to the sqliteWP8.cpp file but it got
too intense for my limited C++ knowledge.


--
Andrew Arnott
"I [may] not agree with what you have to say, but I'll defend to the death
your right to say it." - S. G. Tallentyre


On Mon, Mar 10, 2014 at 10:57 PM, Joe Mistachkin wrote:

>
> Andrew Arnott wrote:
> >
> > The exception raised when I send "VACUUM" as a sql statement is:
> > SQLite.SQLiteException occurred
> >   _HResult=-2146233088
> >   _message=SQL logic error or missing database
> >   HResult=-2146233088
> >   Message=SQL logic error or missing database
> >   Source=Dart.WinPhone8Lib
> >   StackTrace:
> >at SQLite.SQLiteCommand.ExecuteNonQuery()
> >   InnerException:
> >
> > Thanks for any help you can offer!
> >
>
> In the "SQLite.cs" file, there is the following:
>
> #if NETFX_CORE
> SQLite3.SetDirectory(/*temp directory type*/2,
> Windows.Storage.ApplicationData.Current.TemporaryFolder.Path);
> #endif
>
> Can you please try removing the surrounding "#if" from this code and try it
> again?
>
> --
> Joe Mistachkin
>
> ___
> 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

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Joe Mistachkin]

Andrew Arnott wrote:
>
> The exception raised when I send "VACUUM" as a sql statement is:
> SQLite.SQLiteException occurred
>   _HResult=-2146233088
>   _message=SQL logic error or missing database
>   HResult=-2146233088
>   Message=SQL logic error or missing database
>   Source=Dart.WinPhone8Lib
>   StackTrace:
>at SQLite.SQLiteCommand.ExecuteNonQuery()
>   InnerException:
> 
> Thanks for any help you can offer!
>

In the "SQLite.cs" file, there is the following:

#if NETFX_CORE
SQLite3.SetDirectory(/*temp directory type*/2,
Windows.Storage.ApplicationData.Current.TemporaryFolder.Path);
#endif

Can you please try removing the surrounding "#if" from this code and try it
again?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Andrew Arnott]

I've created a trivial repro project, which you can download here:
http://1drv.ms/N2D4gP

The exception raised when I send "VACUUM" as a sql statement is:
SQLite.SQLiteException occurred
  _HResult=-2146233088
  _message=SQL logic error or missing database
  HResult=-2146233088
  Message=SQL logic error or missing database
  Source=Dart.WinPhone8Lib
  StackTrace:
   at SQLite.SQLiteCommand.ExecuteNonQuery()
  InnerException:

Thanks for any help you can offer!


--
Andrew Arnott
"I [may] not agree with what you have to say, but I'll defend to the death
your right to say it." - S. G. Tallentyre


On Mon, Mar 10, 2014 at 8:06 PM, Andrew Arnott wrote:

> I expect I could build a miniature repro if that would be useful to anyone.
> On Mar 10, 2014 8:05 PM, "Andrew Arnott"  wrote:
>
>> It raises an error, which the sqlite.cs file that everyone uses turns
>> into an exception.
>> On Mar 10, 2014 6:01 PM, "Simon Slavin"  wrote:
>>
>>>
>>> On 11 Mar 2014, at 12:56am, Andrew Arnott 
>>> wrote:
>>>
>>> > When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1,
>>> the
>>> > VACUUM statement quit working. Any idea why?
>>>
>>> What does it do instead of work ?
>>>
>>> Simon.
>>> ___
>>> 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

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Andrew Arnott]

I expect I could build a miniature repro if that would be useful to anyone.
On Mar 10, 2014 8:05 PM, "Andrew Arnott"  wrote:

> It raises an error, which the sqlite.cs file that everyone uses turns into
> an exception.
> On Mar 10, 2014 6:01 PM, "Simon Slavin"  wrote:
>
>>
>> On 11 Mar 2014, at 12:56am, Andrew Arnott  wrote:
>>
>> > When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
>> > VACUUM statement quit working. Any idea why?
>>
>> What does it do instead of work ?
>>
>> Simon.
>> ___
>> 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

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Andrew Arnott]

It raises an error, which the sqlite.cs file that everyone uses turns into
an exception.
On Mar 10, 2014 6:01 PM, "Simon Slavin"  wrote:

>
> On 11 Mar 2014, at 12:56am, Andrew Arnott  wrote:
>
> > When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
> > VACUUM statement quit working. Any idea why?
>
> What does it do instead of work ?
>
> Simon.
> ___
> 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

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Simon Slavin]

On 11 Mar 2014, at 12:56am, Andrew Arnott  wrote:

> When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
> VACUUM statement quit working. Any idea why?

What does it do instead of work ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

[Andrew Arnott]

When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the
VACUUM statement quit working. Any idea why?

I'd be quite happy to 'rollback' to 3.8.1, but I can't find a way to
download prior versions of the SDK.

Thanks.

--
Andrew Arnott
"I [may] not agree with what you have to say, but I'll defend to the death
your right to say it." - S. G. Tallentyre
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite for Windows Phone bug

[Richard Hipp]

Have you activated the error and warning log to see if it gives you any
further diagnostics?

http://www.sqlite.org/errlog.html


On Wed, Feb 19, 2014 at 12:06 AM, Martin Zikmund <martinzikm...@live.com>wrote:

> Hello, SQLite team,
>
>
> I would like to report a bug in the Windows Phone version of SQLite, that
> is already present for three releases in the row. The problem arises quite
> randomly, when SQLite refuses to insert or update some items into database
> and throws the following error: SQL logic error or missing database . I
> have checked the SQL and that database is well present, but the problem
> persists. The situation is even worse because the inserts and updates that
> fail seem to be completely random - if I compare an entry that fails and
> one that doesn't, there is nothing that should be taken as a reason for the
> error. I'm not the only one experiencing this -
> http://stackoverflow.com/questions/20474253/sqlite-3-8-2-exception-on-update-statement.
>  The interesting fact is that in the 3.8.1 version this never happened, so
> the cause must be some change between these the version 3.8.1 and version
> 3.8.2.
>
>
> Can you please check if anything can be done? My project is highly
> dependant on SQLite, but this way it is not reliable enough...
>
>
> Thank you very, very much
>
>
> Sincerely
>
>
> Martin Zikmund
>
>
>
>
>
>
> Sent from Surface Pro
> ___
> 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

Re: [sqlite] SQLite for Windows Phone bug

[Simon Slavin]

On 19 Feb 2014, at 5:06am, Martin Zikmund  wrote:

> SQL logic error or missing database

The two usual causes of this under WinMob are both related to permissions and 
privileges.  The folder the database file is stored in may be protected against 
the app opening the existing database file or creating a new journal file, or 
the permissions on the database file may be protected against the app.

First make sure you are specifying the correct path.  If you didn't specify a 
full path, try temporarily doing so in your test setup and see if anything 
changes.

If that doesn't work try modifying your app to create a new text file (standard 
C file API) in the same folder as the database file normally lives.  Does it 
succeed ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite for Windows Phone bug

[Martin Zikmund]

Hello, SQLite team,


I would like to report a bug in the Windows Phone version of SQLite, that is 
already present for three releases in the row. The problem arises quite 
randomly, when SQLite refuses to insert or update some items into database and 
throws the following error: SQL logic error or missing database . I have 
checked the SQL and that database is well present, but the problem persists. 
The situation is even worse because the inserts and updates that fail seem to 
be completely random - if I compare an entry that fails and one that doesn’t, 
there is nothing that should be taken as a reason for the error. I’m not the 
only one experiencing this - 
http://stackoverflow.com/questions/20474253/sqlite-3-8-2-exception-on-update-statement
 . The interesting fact is that in the 3.8.1 version this never happened, so 
the cause must be some change between these the version 3.8.1 and version 3.8.2.


Can you please check if anything can be done? My project is highly dependant on 
SQLite, but this way it is not reliable enough…


Thank you very, very much


Sincerely


Martin Zikmund






Sent from Surface Pro
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite with Windows 2003 Server Connection

[gert1111]

Hello,

I have troubles connecting to a SQlite DB stored on a Windows 2003 Server.
When the SQlite DB is stored local, or on a Windows 2008 Server or on
another computer in the network, or a NAS, there is no problems.

When the DB is stored on the Windows 2003 Server, the program connecting to
it stalls, my network activity goes up to 25% on a 100MB line for 8 minutes,
and after that the DB is loaded. Changing screens, and doing a new query on
the DB starts the process again.

I enabled network DTC access on the Server, tried other things with
permissions, but ran out of options.

Can someone help me?

thank,

Gert



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/SQLite-with-Windows-2003-Server-Connection-tp73182.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite with Windows Phone 8

[Sascha Sertel]

Did you add the Community.CsharpSqlite.WinPhone.dll as a dependency to your
project?


On Fri, Oct 11, 2013 at 5:09 AM, Tola Fasoyiro
<tola.fasoy...@hotmail.co.uk>wrote:

>
> I am attempting to use SQLite with Windows Phone. I have successfully
> installed SQLite for Windows and sqlite-net. I get an error in SQLite.cs
>  as follows:
>
> type or namespace "Community" could not be found
>
>
> #if USE_CSHARP_SQLITE
> using Sqlite3 = Community.CsharpSqlite.Sqlite3;
> using Sqlite3DatabaseHandle = Community.CsharpSqlite.Sqlite3.sqlite3;
> using Sqlite3Statement = Community.CsharpSqlite.Sqlite3.Vdbe;
> #elif USE_WP8_NATIVE_SQLITE
> using Sqlite3 = Sqlite.Sqlite3;
> using Sqlite3DatabaseHandle = Sqlite.Database;
> using Sqlite3Statement = Sqlite.Statement;
> #else
> using Sqlite3DatabaseHandle = System.IntPtr;
> using Sqlite3Statement = System.IntPtr;
> #endif
>
>
>
> Sent from Windows Mail
> ___
> 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] SQLite with Windows Phone 8

[Tola Fasoyiro]

I am attempting to use SQLite with Windows Phone. I have successfully installed 
SQLite for Windows and sqlite-net. I get an error in SQLite.cs  as follows: 

type or namespace "Community" could not be found


#if USE_CSHARP_SQLITE
using Sqlite3 = Community.CsharpSqlite.Sqlite3;
using Sqlite3DatabaseHandle = Community.CsharpSqlite.Sqlite3.sqlite3;
using Sqlite3Statement = Community.CsharpSqlite.Sqlite3.Vdbe;
#elif USE_WP8_NATIVE_SQLITE
using Sqlite3 = Sqlite.Sqlite3;
using Sqlite3DatabaseHandle = Sqlite.Database;
using Sqlite3Statement = Sqlite.Statement;
#else
using Sqlite3DatabaseHandle = System.IntPtr;
using Sqlite3Statement = System.IntPtr;
#endif



Sent from Windows Mail
_______
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on Windows 8.1 Metro Application returning CannotOpen Error

[Dave Protasowski]

False alarm - the wrapper lib bundled in our repo was an older revision
that was not calling sqlite3_win32_set_directory

After updating to the latest it's resolved.

Link for reference if anyone else is looking for the source
https://github.com/koush/sqlite-net/blob/master/src/SQLite.cs

- dave


On Thu, Sep 19, 2013 at 6:22 PM, Joe Mistachkin wrote:

>
> Dave Protasowski wrote:
> >
> > I'm using this library the relevant code snippet is:
> > https://github.com/koush/sqlite-net/blob/master/src/SQLite.cs#L150
> >
> > While debugging I've confirmed that the call to SetDirectory is
> > returning SQLITE_OK (0).
> >
>
> Are you setting the temporary directory to a location where your
> application has read-write permissions?
>
> What result do you get for "PRAGMA temp_store_directory;" ?
>
> Are you able to install a sqlite3_log callback (via sqlite3_config)
> and see more details about the error message you are seeing?
>
> --
> Joe Mistachkin
>
> ___
> 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

Re: [sqlite] Sqlite on Windows 8.1 Metro Application returning CannotOpen Error

[Joe Mistachkin]

Dave Protasowski wrote:
> 
> I'm using this library the relevant code snippet is:
> https://github.com/koush/sqlite-net/blob/master/src/SQLite.cs#L150
> 
> While debugging I've confirmed that the call to SetDirectory is
> returning SQLITE_OK (0).
> 

Are you setting the temporary directory to a location where your
application has read-write permissions?

What result do you get for "PRAGMA temp_store_directory;" ?

Are you able to install a sqlite3_log callback (via sqlite3_config)
and see more details about the error message you are seeing?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on Windows 8.1 Metro Application returning CannotOpen Error

[Dave Protasowski]

> For the first argument to sqlite3_win32_set_directory(), are you passing a

>  > value of SQLITE_WIN32_TEMP_DIRECTORY_TYPE (which equals 2)?

Yes

 > Is the call to sqlite3_win32_set_directory() being executed prior to
opening

>  > the database and is it returning SQLITE_OK?

>
Yes to both

I'm using this library the relevant code snippet is:
https://github.com/koush/sqlite-net/blob/master/src/SQLite.cs#L150

While debugging I've confirmed that the call to SetDirectory is
returning SQLITE_OK (0).

I'm using the sqlite visual studio extension (
http://www.sqlite.org/2013/sqlite-winrt81-3080002.vsix)

- dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on Windows 8.1 Metro Application returning CannotOpen Error

[Joe Mistachkin]

Dave Protasowski wrote:
> 
> I found this page describing how sqlite on Windows RT should set the temp
> file directory. http://www.sqlite.org/c3ref/temp_directory.html
> 
> I'm using sqlite3_win32_set_directory method (in C#) to do this but I've
> noticed that in some instances sqlite is still returning cannot open
errors
> (when dropping some tables). 
> 

What version of SQLite are you using?

For the first argument to sqlite3_win32_set_directory(), are you passing a
value of SQLITE_WIN32_TEMP_DIRECTORY_TYPE (which equals 2)?

Is the call to sqlite3_win32_set_directory() being executed prior to opening
the database and is it returning SQLITE_OK?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite on Windows 8.1 Metro Application returning Cannot Open Error

[Dave Protasowski]

Hey guys,

I found this page describing how sqlite on Windows RT should set the temp
file directory. http://www.sqlite.org/c3ref/temp_directory.html

I'm using sqlite3_win32_set_directory method (in C#) to do this but I've
noticed that in some instances sqlite is still returning cannot open errors
(when dropping some tables).

The post below suggested using PRAGMA temp_store = memory, to prevent
storing temp files

http://sqlite.1065341.n5.nabble.com/SQLITE-CANTOPEN-returned-from-sqlite3-step-td58437.html

Doing this resolves our issue since sqlite doesn't try to write temp files.
I'm just curious if anyone else has encountered this issue.

- dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE For Windows phone

[Matthijs ter Woord]

See
http://developer.nokia.com/Community/Wiki/How_to_use_SQLite_in_Windows_Phone


On Wed, Aug 7, 2013 at 2:23 AM, Cadu .  wrote:

> Hello I wonder if you could send me a tutorial on how to add the SQLITE
> project in Visual Studio 2012, since not found any material regarding this
> project, I thank the collaboration
> ___
> 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] SQLITE For Windows phone

[Cadu .]

Hello I wonder if you could send me a tutorial on how to add the SQLITE project 
in Visual Studio 2012, since not found any material regarding this project, I 
thank the collaboration 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite for Windows Metro

[Samir Carneiro Jose]

Hello,

with sqlite for windows store, it's possible to create database with
multiples foreign keys?

if don't, when i may expect this update?

i've tryed devart solution but the performance is so slow.

-- 
Trovata
.NET Developer
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on windows ce 5.0 Emulator

[Joe Mistachkin]

Anand Shah wrote:
> 
> DeviceApplication1.exe
> NullReferenceException
> at DeviceApplication1.Form1.Button1_Click()\par
> at System.Windows.Forms.Control.OnClick()\par
> at System.Windows.Forms.Button.OnClick()\par
> at System.Windows.Forms.ButtonBase.WnProc()\par
> at System.Windows.Forms.Control._InternalWnProc()\par
> at Microsoft.AGL.Forms.EVL.EnterMainLoop()\par
> at System.Windows.Forms.Application.Run()\par
> at DeviceApplication1.Form1.Main()\par
> 

I see no references to SQLite or System.Data.SQLite in the above stack
trace.

> 
> The latest version you have suggested might need .net CF 3.5 but I must
use
> 2.0 CF.
> 

It is also possible to target the .NET Compact Framework 2.0 with the
current
sources by using the project file for Visual Studio 2005.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite in windows 8?

[Joe Mistachkin]

satishpatil14 wrote:
> 
> could anybody guide me how to connect sqlite database connection in windws
8
> app using java script,HTML.please i am trying a lot but in
vain
> 

Here you go:

http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from
-windows-store-apps.aspx

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite in windows 8?

[satishpatil14]

could anybody guide me how to connect sqlite database connection in windws 8
app using java script,HTML.please i am trying a lot but in vain



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/sqlite-in-windows-8-tp67341.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on windows ce 5.0 Emulator

[Anand Shah]

Hi,
Thanks for your reply.
It is raising below error:

DeviceApplication1.exe
NullReferenceException
at DeviceApplication1.Form1.Button1_Click()\par
at System.Windows.Forms.Control.OnClick()\par
at System.Windows.Forms.Button.OnClick()\par
at System.Windows.Forms.ButtonBase.WnProc()\par
at System.Windows.Forms.Control._InternalWnProc()\par
at Microsoft.AGL.Forms.EVL.EnterMainLoop()\par
at System.Windows.Forms.Application.Run()\par
at DeviceApplication1.Form1.Main()\par

The latest version you have suggested might need .net CF 3.5 but I must use
2.0 CF.

How would I be able to use this binary files in my vs project?



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Sqlite-on-windows-ce-5-0-Emulator-tp67313p67340.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite on windows ce 5.0 Emulator

[Joe Mistachkin]

Anand Shah wrote:
>
> I am able to run application successfully developed with vs2005 .net CF
2.0
> on my local windows embedded ce 6.0 machine. I am trying to deploy this
> application to windows emulator ce 5.0 as a device application and it also
> gets deployed successfully but when any event calls sqlite dll it is
raising
> errors. 
>

What errors does it raise?

> 
> I am using SQLite-1.0.66.0-binaries.
> 

Have you tried using the latest version?  It is available from:

http://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx35-binary-Pocke
tPC-2008-1.0.84.0.zip

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite on windows ce 5.0 Emulator

[Anand Shah]

Hello,
I am able to run application successfully developed with vs2005 .net CF 2.0
on my local windows embedded ce 6.0 machine. I am trying to deploy this
application to windows emulator ce 5.0 as a device application and it also
gets deployed successfully but when any event calls sqlite dll it is raising
errors. 

I am using SQLite-1.0.66.0-binaries.

Please advice.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Sqlite-on-windows-ce-5-0-Emulator-tp67313.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8

[Peter Naldal]

Hi Scott, Noah,  Joe and others

I downloaded C#-Sqlite source from http://code.google.com/p/csharp-sqlite/
and compiled the Community.CsharpSqlite.WinPhone and
Community.CsharpSqlite.SqliteClient.WP DLLs. In my project I installed
sqlite-net and referenced the above DLLs. Now the sqlite-net wrapper
including LINQ access works on Windows Phone 8. I uninstalled the official
"SQLite for Windows Phone 8" extension.  I don't understand how to take
advantage of it. Tim Heuer writes on his blog, that the purpose is to avoid
the hassle of managing different projects for every CPU.  I hope to be able
to take advantage of this at some point. 

Thank you for your help!

/Peter

-Original message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] (Scott Tiger)
Sent: 6. november 2012 20:55
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite on Windows Phone 8

Hello Naoh.

csharp-sqlite is not a SQLite for Windows Phone 8.
Peter is talking about official release of SQLite for Windows Phone 8.
http://www.sqlite.org/download.html#wp8

Hello Peter.

This also discussed on msdn forum.
http://social.msdn.microsoft.com/Forums/en-US/wpdevelop/thread/083fc2a4-c1a0
-4689-be69-c73361d13457/
They are talking about.
"At the BUILD conference, Peter Torr said a WinRT wrapper for SQLite will be
released soon".

I also waiting official SQLite WinRT wrapper.

Thanks.



2012/11/6 Noah Hart <n...@lipmantpa.com>

> Hello Peter,
>
> This is a common configuration.
>
> Please visit the C#SQLite project here:
> http://code.google.com/p/csharp-sqlite/
>
> and post questions to the usergroup here:
> https://groups.google.com/forum/?fromgroups#!forum/csharp-sqlite
>
> Please keep in mind the following:
>
> This is not an official version of SQLite
> There is completely NO affiliation with SQLite.org
> Bugs should not be reported to their ticket tracking system
>
> Thank you,
> Noah Hart
>
>
>
>
>
> --
> View this message in context:
> http://sqlite.1065341.n5.nabble.com/SQLite-on-Windows-Phone-8-tp65316p
> 65382.html Sent from the SQLite mailing list archive at Nabble.com.
> ___
> 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

Re: [sqlite] SQLite on Windows Phone 8

[Scott Tiger]

Hello Naoh.

csharp-sqlite is not a SQLite for Windows Phone 8.
Peter is talking about official release of SQLite for Windows Phone 8.
http://www.sqlite.org/download.html#wp8

Hello Peter.

This also discussed on msdn forum.
http://social.msdn.microsoft.com/Forums/en-US/wpdevelop/thread/083fc2a4-c1a0-4689-be69-c73361d13457/
They are talking about.
"At the BUILD conference, Peter Torr said a WinRT wrapper for SQLite will
be released soon".

I also waiting official SQLite WinRT wrapper.

Thanks.



2012/11/6 Noah Hart <n...@lipmantpa.com>

> Hello Peter,
>
> This is a common configuration.
>
> Please visit the C#SQLite project here:
> http://code.google.com/p/csharp-sqlite/
>
> and post questions to the usergroup here:
> https://groups.google.com/forum/?fromgroups#!forum/csharp-sqlite
>
> Please keep in mind the following:
>
> This is not an official version of SQLite
> There is completely NO affiliation with SQLite.org
> Bugs should not be reported to their ticket tracking system
>
> Thank you,
> Noah Hart
>
>
>
>
>
> --
> View this message in context:
> http://sqlite.1065341.n5.nabble.com/SQLite-on-Windows-Phone-8-tp65316p65382.html
> Sent from the SQLite mailing list archive at Nabble.com.
> ___
> 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

Re: [sqlite] SQLite on Windows Phone 8

[Noah Hart]

Hello Peter,

This is a common configuration.

Please visit the C#SQLite project here: 
http://code.google.com/p/csharp-sqlite/

and post questions to the usergroup here: 
https://groups.google.com/forum/?fromgroups#!forum/csharp-sqlite

Please keep in mind the following:

This is not an official version of SQLite
There is completely NO affiliation with SQLite.org
Bugs should not be reported to their ticket tracking system 

Thank you,
Noah Hart





--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/SQLite-on-Windows-Phone-8-tp65316p65382.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8

[Joe Mistachkin]

Peter Naldal wrote:
>
> Original message:
> **
> Topic: [sqlite] SQLite on Windows Phone 8
> Hi
> "Visual Studio 2012 for Windows Phone" offers installation of "SQLite for
> Windows Phone 8" as an extension. To enable programming against this
> extension a wrapper component or library needs to be installed. I am using
> sqlite-net installed via NuGet. But when compiling SQLite.cs, the compiler
> complains that the namespace Community.CsharpSqlite is not found. The same
> procedure works just fine in Visual Studio 2012 for Windows 8. For Windows
> Phone a DLL is needed that includes the Community.CsharpSqlite namespace.
I
> have three questions:
> 1.  Has anyone allready build this DLL (Community.CsharpSqlite.WP.dll),
that
> is needed for sqlite-net?
> 2.  How do I compile the DLL myself?
> 3.  Are there other ways to utilize the "SQLite for Windows Phone 8"
> extension?
> I eagerly awaits your comments and answers.
> \Peter Naldal
> **
> 

Did you see the response I sent previously?

http://www.mail-archive.com/sqlite-users%40sqlite.org/msg73619.html

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8

[Peter Naldal]

Has anybody tried to install "SQLite for Windows Phone 8"?
Any success?
I can install it. It shows up fine under References, but then what? The
Object Browser shows nothing.
What namespace can I reference?  What classes can I use?
\Peter

Original message:
**
Topic: [sqlite] SQLite on Windows Phone 8
Hi
"Visual Studio 2012 for Windows Phone" offers installation of "SQLite for
Windows Phone 8" as an extension. To enable programming against this
extension a wrapper component or library needs to be installed. I am using
sqlite-net installed via NuGet. But when compiling SQLite.cs, the compiler
complains that the namespace Community.CsharpSqlite is not found. The same
procedure works just fine in Visual Studio 2012 for Windows 8. For Windows
Phone a DLL is needed that includes the Community.CsharpSqlite namespace. I
have three questions:
1.  Has anyone allready build this DLL (Community.CsharpSqlite.WP.dll), that
is needed for sqlite-net?
2.  How do I compile the DLL myself?
3.  Are there other ways to utilize the "SQLite for Windows Phone 8"
extension?
I eagerly awaits your comments and answers.
\Peter Naldal
**

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows Phone 8

[Joe Mistachkin]

Peter Naldal wrote:
> 
> "Visual Studio 2012 for Windows Phone" offers installation of "SQLite for
> Windows Phone 8" as an extension. To enable programming against this
> extension a wrapper component or library needs to be installed. I am using
> sqlite-net installed via NuGet.
>

When using the SQLite for Windows Phone extension SDK, an additional
component
may be required to use it from managed code (C#).  The "sqlite-net" project
seems to be a popular choice.

>
> But when compiling SQLite.cs, the compiler complains that the namespace
> Community.CsharpSqlite is not found. The same procedure works just fine in
> Visual Studio 2012 for Windows 8.  For Windows Phone a DLL is needed that
> includes the Community.CsharpSqlite namespace. I have three questions:
> 
> 1.   Has anyone allready build this DLL
(Community.CsharpSqlite.WP.dll),
> that is needed for sqlite-net?
> 
> 2.   How do I compile the DLL myself?
>

Unfortunately, I'm not familiar with the implementation of the "sqlite-net"
project.  Perhaps somebody else on the mailing list can comment on these
questions?

> 
> 3.   Are there other ways to utilize the "SQLite for Windows Phone 8"
> extension?
> 

I'm not sure.  If P/Invoke is allowed on Windows Phone 8, that could be
used.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite on Windows Phone 8

[Peter Naldal]

Hi

 

"Visual Studio 2012 for Windows Phone" offers installation of "SQLite for
Windows Phone 8" as an extension. To enable programming against this
extension a wrapper component or library needs to be installed. I am using
sqlite-net installed via NuGet. But when compiling SQLite.cs, the compiler
complains that the namespace Community.CsharpSqlite is not found. The same
procedure works just fine in Visual Studio 2012 for Windows 8. For Windows
Phone a DLL is needed that includes the Community.CsharpSqlite namespace. I
have three questions:

1.   Has anyone allready build this DLL (Community.CsharpSqlite.WP.dll),
that is needed for sqlite-net?

2.   How do I compile the DLL myself?

3.   Are there other ways to utilize the "SQLite for Windows Phone 8"
extension?

 

I eagerly awaits your comments and answers.

 

Peter Naldal

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows Metro Style

[Richard Hipp]

On Fri, Mar 16, 2012 at 10:05 AM, Philipp Kursawe wrote:

> >
> >
> > Click to get to http://www.sqlite.org/src/info/cd70bc4b78 then look
> beside
> > "Other Links:" and click on either "Tarball" or "ZIP Archive".
> >
> > thanks! found it. Compiling without awk is not possible?
>

On my windows7 box, I run:

nmake /f makefile.msc sqlite3.c

It looks like that command requires both gawk and tclsh85.  I don't see
anything else that you are unlikely to already have installed.  You'll also
need TCL libraries in order to do

nmake /f makefile.msc test

But you don't necessarily have to do that.



> ___
> 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

Re: [sqlite] SQLite and Windows Metro Style

[Philipp Kursawe]

>
>
> Click to get to http://www.sqlite.org/src/info/cd70bc4b78 then look beside
> "Other Links:" and click on either "Tarball" or "ZIP Archive".
>
> thanks! found it. Compiling without awk is not possible?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows Metro Style

[Richard Hipp]

On Fri, Mar 16, 2012 at 9:49 AM, Philipp Kursawe wrote:

> Hello
>
>
> > > How can I download the current WinRT efforts and compile them myself
> > into a
> > > WinRT component?
> > >
> >
> > Download the latest winRT code from
> > http://www.sqlite.org/src/timeline?r=winrt
> >
> > All I see there is a checkin  history. Clicking on files does give me
> files but no tarbar or something to download the winrt branch.
>

Click to get to http://www.sqlite.org/src/info/cd70bc4b78 then look beside
"Other Links:" and click on either "Tarball" or "ZIP Archive".


>
>
> Phil
> ___
> 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

Re: [sqlite] SQLite and Windows Metro Style

[Philipp Kursawe]

Hello


> > How can I download the current WinRT efforts and compile them myself
> into a
> > WinRT component?
> >
>
> Download the latest winRT code from
> http://www.sqlite.org/src/timeline?r=winrt
>
> All I see there is a checkin  history. Clicking on files does give me
files but no tarbar or something to download the winrt branch.


Phil
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows Metro Style

[Richard Hipp]

On Fri, Mar 16, 2012 at 7:09 AM, Philipp Kursawe wrote:

> Good to read that a WinRT compatible version is on the way.
> I had struggle myself to get the current 3.7 code to compile without
> compiler complains about uncast assignments. Let alone the non-existent
> Win32 APIs in the WinRT environment.
> By the way there is already a compile time preprocessor define for WinRT
> apps WINAPI_FAMILY=WINAPI_FAMILY_APP
> I think there is no need to find out during runtime if the code is running
> inside the WinRT environment.
>
> How can I download the current WinRT efforts and compile them myself into a
> WinRT component?
>

Download the latest winRT code from
http://www.sqlite.org/src/timeline?r=winrt



>
> Thanks!
>
> Phil
> ___
> 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

Re: [sqlite] SQLite and Windows Metro Style

[Philipp Kursawe]

Good to read that a WinRT compatible version is on the way.
I had struggle myself to get the current 3.7 code to compile without
compiler complains about uncast assignments. Let alone the non-existent
Win32 APIs in the WinRT environment.
By the way there is already a compile time preprocessor define for WinRT
apps WINAPI_FAMILY=WINAPI_FAMILY_APP
I think there is no need to find out during runtime if the code is running
inside the WinRT environment.

How can I download the current WinRT efforts and compile them myself into a
WinRT component?

Thanks!

Phil
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows Metro Style

[Richard Hipp]

On Thu, Mar 1, 2012 at 7:41 PM, Simon Slavin  wrote:

>
> On 2 Mar 2012, at 12:33am, Richard Hipp  wrote:
>
> > We are told that metro style applications may not use many of the win32
> > APIs that SQLite currently does use (APIs such as LoadLibrary(),
> > SetFilePointer(), GetFileSize(), etc.)
>
> I'll have to talk to my colleague.  Is it possible he used posix-style
> calls instead of windows-style calls ?
>

I don't think so.  But I don't really know that much about it.  I'm curious
to know what is going on too.



>
> Simon.
> ___
> 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

Re: [sqlite] SQLite and Windows Metro Style

[Simon Slavin]

On 2 Mar 2012, at 12:33am, Richard Hipp <d...@sqlite.org> wrote:

> We are told that metro style applications may not use many of the win32
> APIs that SQLite currently does use (APIs such as LoadLibrary(),
> SetFilePointer(), GetFileSize(), etc.)

I'll have to talk to my colleague.  Is it possible he used posix-style calls 
instead of windows-style calls ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows Metro Style

[Richard Hipp]

On Thu, Mar 1, 2012 at 6:51 PM, Himadri Sarkar  wrote:

> Hi,
> I am a newbie to the SQLite user group and was wondering if anyone has
> tried to use SQLite to build the new Windows metro style applications and
> if yes is there a step by step approach written down somewhere?
>

We are told that metro style applications may not use many of the win32
APIs that SQLite currently does use (APIs such as LoadLibrary(),
SetFilePointer(), GetFileSize(), etc.)  We are currently working on a new
version of SQLite that avoids the missing interfaces.  You can follow our
progress in this branch:

http://www.sqlite.org/src/timeline?r=winrt

Note that, as far as we can tell, there is no way to configure SQLite such
that it will work for both desktop applications (windows 7, vista, winXP,
winNT, win95) and metro style applications (winRT) at the same time.  You
have to choose one or the other at compile-time.  Currently the default is
for desktop applications and so if you want to run on winRT you have to add
the -DSQLITE_OS_WINRT=1 option to your compiler.  We'll remove that
requirement if and when we can figure out a way to make the platform
determination at run-time.



> Regards,
> --
> Himadri
> ___
> 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

Re: [sqlite] SQLite and Windows Metro Style

[Simon Slavin]

On 1 Mar 2012, at 11:51pm, Himadri Sarkar  wrote:

> I am a newbie to the SQLite user group and was wondering if anyone has
> tried to use SQLite to build the new Windows metro style applications and
> if yes is there a step by step approach written down somewhere?

I have a colleague who has done it, with a pre-release version of Windows 8.  
There was no problem with it.  Just include the C source code for the API in 
you project and make sure your compiler knows it's C and not C++.

His project was a very simple demonstration and didn't use every facility of 
SQLite.  And he didn't put it through thorough testing.  So it's possible there 
is a problem hidden there.  But the basics (opening, exec INSERT and SELECT, 
closing) worked as expected.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite and Windows Metro Style

[Himadri Sarkar]

Hi,
I am a newbie to the SQLite user group and was wondering if anyone has
tried to use SQLite to build the new Windows metro style applications and
if yes is there a step by step approach written down somewhere?
Regards,
-- 
Himadri
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite and windows server 2008 DFS

[Marco Turco]

Hi,

any experience using an sqlite db on Windows server 2008 with DFS enabled ?

A customer with this configuration reported me that there is a lost of data.

 

Marco

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[joel . guittet-ext]

Hi,

Thanks to you to help me with this problem.
As I do not require special features (only insert/select/order by/delete), 
I think it is maybe easier to use an old version of SQLite. I will try 
with 3.6.10 as said by Max. If it does not work I will try an older one.

Regards,
Joel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[Max Vlasov]

On Tue, Dec 21, 2010 at 9:06 PM, wrote:

> I wonder about something : those functions are in kernel32.dll on a XP
> computer. Is it possible (I never do that before), to take the file
> "kernel32.dll" on my XP computer, to put it on the Win95 computer in the
> directory of my SQLite application, and to call the functions I need for
> SQLite in this DLL instead of the kernel32.dll of Win95 ?
> Maybe with a call to LoadLibrary and with some calls to GetProcAddress ?
>
>
Joel, as long as I remember, I managed to make statically linked 3.6.10
working on Windows 98. I'm not sure about 95, but at least you can try.

Max Vlasov
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[Random Coder]

On Tue, Dec 21, 2010 at 10:06 AM,
 wrote:
> I wonder about something : those functions are in kernel32.dll on a XP
> computer. Is it possible (I never do that before), to take the file
> "kernel32.dll" on my XP computer, to put it on the Win95 computer in the
> directory of my SQLite application, and to call the functions I need for
> SQLite in this DLL instead of the kernel32.dll of Win95 ?
> Maybe with a call to LoadLibrary and with some calls to GetProcAddress ?

No, not only will that not work, but the license does not allow you to
copy random DLLs from Windows around.

I'd try something like the Legacy Extender
(http://www.legacyextender.com/).  It claims to contain a DLL with
implementations of many Windows NT functions, including this one.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[Simon Slavin]

On 21 Dec 2010, at 6:06pm, joel.guittet-...@transport.alstom.com wrote:

> Is it possible (I never do that before), to take the file 
> "kernel32.dll" on my XP computer, to put it on the Win95 computer in the 
> directory of my SQLite application

This will not work.  The kernel /is/ pretty-much the version of Windows you're 
running.  Everything else in Windows talks to the kernel and replacing the 
kernel for a Win95 computer will require you to replace many other files on it 
too.

I don't think it's possible to do the thing you want on a Win95 computer.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[Igor Tandetnik]

On 12/21/2010 1:06 PM, 
joel.guittet-...@transport.alstom.com wrote:
> I wonder about something : those functions are in kernel32.dll on a XP
> computer. Is it possible (I never do that before), to take the file
> "kernel32.dll" on my XP computer, to put it on the Win95 computer in the
> directory of my SQLite application, and to call the functions I need for
> SQLite in this DLL instead of the kernel32.dll of Win95 ?

No. Functions in kernel32.dll just turn around and make system calls 
into the actual OS kernel. Those system calls that exist in XP kernel 
but not in Win95 one won't magically materialize when you copy a 
user-mode DLL.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[joel . guittet-ext]

Hi Max and Richard,

Thanks for reply.

To Max: I agree, I do not have unicode support. The call to 
GetFileAttributesExW is in "if( isNT() )", which returns FALSE under 
Win95, so I removed the call to GetFileAttributesExW (It is not a problem 
if I considered that the software is build for a specific plateforme, and 
in the future i can make a definition "SQLITE_WIN95" in the code, like 
done for WinCE.

The problem is still there, but with "InterlockedCompareExchange", and it 
seems I need it.

I wonder about something : those functions are in kernel32.dll on a XP 
computer. Is it possible (I never do that before), to take the file 
"kernel32.dll" on my XP computer, to put it on the Win95 computer in the 
directory of my SQLite application, and to call the functions I need for 
SQLite in this DLL instead of the kernel32.dll of Win95 ?
Maybe with a call to LoadLibrary and with some calls to GetProcAddress ?


On a other hand, I looked for older versions of SQLite, but I'm confused : 
do I need to use source trunk repository on sqlite.org or is there 
somewhere archive of older versions (if possible amalgamation version) ?


Thanks a lot for your help.
Joel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[Max Vlasov]

On Mon, Dec 20, 2010 at 7:44 PM, wrote:

>
> - Using the SQLite sources in my project, but the application do not start
> any more on Windows 95 : error message is that the application is linked
> to kernel32.dll and that function GetFileAttributesExW is not found. If I
> remove this function in the SQLite code, the same problem appears with
> another function.
>
>

Looking at the name of the function that ends with W, the questions is: have
you installed Microsoft Layer for Unicode (
http://msdn.microsoft.com/en-us/goglobal/bb688166)?

Max Vlasov
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[Richard Hipp]

On Mon, Dec 20, 2010 at 12:51 PM, wrote:

>
> Or if it is not possible to use SQLite, which simple database can I use on
> Win95 ?
>

SQLite can probably be made to work on Win95.  It used to work on Win95.
But we do not have (and have not had for years) the ability to test on
Win95.  It's not like we can go out to BestBuy and pick up a new Win95
machine for testing, you know Hence breakage accumulates.  (A similar
problem exists for OS/2.)

Why don't you go back through some historical versions of SQLite and figure
out when it stopped working.  Maybe you can use that version.  Or maybe you
can take the "os_win.c" source file from that version (which is the only
file that should contain any win95-specific code) and port it to the latest
version of SQLite on the trunk?


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[joel . guittet-ext]

Hi Kees,

Thanks for your reply.

I'm surprised, in the source code of SQLite (file sqlite3.c), there are a 
lot of references to Win95/98/Me.
If I want to use SQLite under Win95, which (stable) version can I use ? I 
do not need so special functions, just making 3 tables and 
insert/select/delete data in those tables.

Or if it is not possible to use SQLite, which simple database can I use on 
Win95 ? If I do not found solution, I will have to do the jobs around txt 
files  :-(

I'm developping for very specific hardware, and those developments are an 
upgrade of an existing system, I can't upgrade the operating system to a 
newer windows version.

Regards,
Joel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Windows 95

[Kees Nuyt]

On Mon, 20 Dec 2010 16:44:10 +,
joel.guittet-...@transport.alstom.com wrote:

> Hi,
>
>I'm working with SQLite since few months. I'm developping an application 
>with Visual C++ 6.0 and with SQLite 3.7.2. This application works fine on 
>my computer, which is running Windows XP.
>
>But the final hardware is under Windows 95, and the application does not 
>run on it.

Windows 95 support milestones:
General Availability Date 1995-08-15
Mainstream Support End Date  2000-12-31
Extended Support End Date 2001-12-31

The first Alpha version of SQLite3 is dated 2004-06-18
http://www.sqlite.org/oldnews.html#2004__un_18

In other words, it's not very surprising Windows95 is not supported
any more.

Perhaps you can run a newer Windows version, like Windows CE or
Windows Mobile?

Alternatively, you can build a VFS module which targets Windows95
and avoids newer Windows API calls.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite and Windows 95

[joel . guittet-ext]

 Hi,

I'm working with SQLite since few months. I'm developping an application 
with Visual C++ 6.0 and with SQLite 3.7.2. This application works fine on 
my computer, which is running Windows XP.

But the final hardware is under Windows 95, and the application does not 
run on it.

I tried :

- Using SQLite DLL, with the function LoadLibrary, but LoadLibrary call 
fails on Windows 95 (returns NULL).

- Using the SQLite sources in my project, but the application do not start 
any more on Windows 95 : error message is that the application is linked 
to kernel32.dll and that function GetFileAttributesExW is not found. If I 
remove this function in the SQLite code, the same problem appears with 
another function.

So I'm looking for help to run my application on Windows 95. Maybe I 
simply forget a definition to do before building ?
I found some information on the Internet, but nothing very easy to 
understand and use. Is there somewhere a basic application which runs 
under Windows 95 ? Of course I'm particularly interrested by Visual C++ 
6.0 examples, but any other examples will be apreciated.

Thanks for your help.
Joel


Alstom protège l'environnement : n'imprimez ce mail que si nécessaire.
With Alstom, preserve the environment. Is printing this email really 
necessary ?
:.___

CONFIDENTIALITE : Ce message et les éventuelles pièces attachées sont 
confidentiels. Si vous n'êtes pas dans la liste des destinataires, 
veuillez informer l'expéditeur immédiatement et ne pas divulguer le 
contenu à une tierce personne, ne pas l'utiliser pour quelque raison que 
ce soit, ne pas stocker ou copier l'information qu'il contient sur un 
quelconque support.
CONFIDENTIALITY : This  e-mail  and  any attachments are confidential and 
may be privileged. If  you are not a named recipient, please notify the 
sender immediately and do not disclose the contents to another person, use 
it for any purpose or store or copy the information in any medium.

 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Burnett, Joe]

 
No, actually, not bin. I have tried it from the root directory and the
App_Data directory using
absolute paths. I will try your approach.

Thanks Allan,

Joe

Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
cell: 603.289.0481


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Schrum, Allan
Sent: Thursday, April 08, 2010 9:57 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite on Windows 2003



> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Igmar Palsenberg
> Sent: Thursday, April 08, 2010 6:18 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] SQLite on Windows 2003
> 
> 
> > First of all, I want to thank everyone that has replied to this
email
> > thread.
> >
> > I still do not have a successful opening of the SQLite connection in
> my
> > ASP.NET C# application on
> > Windows 2003. I have done the following:
> >
> > The connection opens successfully with the SQLite command tool.
> > It opens successfully using a C# console application.
> > I have entered the following in my web.config:
> >   
> > I have installed SQLite on the server.
> > I have entered the following in my web.config and machine.config:
> >
> >  
> >
> > invariant="System.Data.SQLite"
> > description=".Net Framework DataProvider for
> > SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite"
> />
> >  
> >
> > I have re-cycled IIS many times.
> > I have done everything suggested in the following link:
> > http://sqlite.phxsoftware.com/forums/p/1391/6025.aspx
> >
> Just a wild guess : You're sure you're not getting bitten by the fact
> that IIS under more recent Windows version is (extremely) restricted
in
> the sense in what it can do on the filesytem ?
> 
> 
>  Igmar

I will second this guess. Have you tried placing your DB into the "bin"
directory and tried opening it from there using a relative path?

-Allan
___
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

Re: [sqlite] SQLite on Windows 2003

[Igmar Palsenberg]

> Yeah, I think it is related to that. I am not new to ASP.NET nor to
> Windows 2003. I am new to SQLite, however.
> But I think you are on to something. I even changed the file name
> extension to .txt and it still doesn't work,
> although it does work in the console application.
>
To test : create a user with admin rights, and let IIS run under that 
user. See if that helps. If it does, you've got a permission problem. If 
it doesn'r, it's more complicated that a simple permission issue.


 Igmar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Burnett, Joe]

Hi Igmar,

Yeah, I think it is related to that. I am not new to ASP.NET nor to
Windows 2003. I am new to SQLite, however.
But I think you are on to something. I even changed the file name
extension to .txt and it still doesn't work,
although it does work in the console application.

Thanks,

Joe 

Joseph Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
CELL: 603.289.0481

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igmar Palsenberg
Sent: Thursday, April 08, 2010 8:18 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite on Windows 2003


> First of all, I want to thank everyone that has replied to this email
> thread.
>
> I still do not have a successful opening of the SQLite connection in
my
> ASP.NET C# application on
> Windows 2003. I have done the following:
>
> The connection opens successfully with the SQLite command tool.
> It opens successfully using a C# console application.
> I have entered the following in my web.config:
>   
> I have installed SQLite on the server.
> I have entered the following in my web.config and machine.config:
>
>  
>
> description=".Net Framework Data  Provider for
> SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
>  
>
> I have re-cycled IIS many times.
> I have done everything suggested in the following link:
> http://sqlite.phxsoftware.com/forums/p/1391/6025.aspx
>
Just a wild guess : You're sure you're not getting bitten by the fact 
that IIS under more recent Windows version is (extremely) restricted in 
the sense in what it can do on the filesytem ?


 Igmar
___
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

Re: [sqlite] SQLite on Windows 2003

[Simon Slavin]

On 8 Apr 2010, at 1:12pm, Burnett, Joe wrote:

> I still do not have a successful opening of the SQLite connection in my
> ASP.NET C# application on
> Windows 2003. I have done the following:
> 
> The connection opens successfully with the SQLite command tool.
> It opens successfully using a C# console application.

Your problem appears to be with the tools supplied with ASP.NET.  If the other 
two methods of opening work fine then the problem is definitely not with 
SQLite.  I can only suggest you look for a mailing list about ASP.NET and ask 
why it has this problem.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Igmar Palsenberg]

> First of all, I want to thank everyone that has replied to this email
> thread.
>
> I still do not have a successful opening of the SQLite connection in my
> ASP.NET C# application on
> Windows 2003. I have done the following:
>
> The connection opens successfully with the SQLite command tool.
> It opens successfully using a C# console application.
> I have entered the following in my web.config:
>   
> I have installed SQLite on the server.
> I have entered the following in my web.config and machine.config:
>
>  
>
> description=".Net Framework Data  Provider for
> SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
>  
>
> I have re-cycled IIS many times.
> I have done everything suggested in the following link:
> http://sqlite.phxsoftware.com/forums/p/1391/6025.aspx
>
Just a wild guess : You're sure you're not getting bitten by the fact 
that IIS under more recent Windows version is (extremely) restricted in 
the sense in what it can do on the filesytem ?


 Igmar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Burnett, Joe]

First of all, I want to thank everyone that has replied to this email
thread.

I still do not have a successful opening of the SQLite connection in my
ASP.NET C# application on
Windows 2003. I have done the following:

The connection opens successfully with the SQLite command tool.
It opens successfully using a C# console application.
I have entered the following in my web.config:
 
I have installed SQLite on the server.
I have entered the following in my web.config and machine.config:
  

  
  

  
I have re-cycled IIS many times.
I have done everything suggested in the following link:
http://sqlite.phxsoftware.com/forums/p/1391/6025.aspx

What am I missing? Your patience and help is appreciated.

Joseph Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
CELL: 603.289.0481

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns
Sent: Wednesday, April 07, 2010 2:27 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite on Windows 2003

>> Alternatively use Process Monitor from sysinternals.com which will
show
>> arguments and return codes without any need to run a debugger.
>
> Even better, use FILEMON (from sysinternals.com) for clues.  It's
wonderful.

Err, no.  You are 4 years out of date.  The functionality of filemon,
regmon 
etc was all wrapped up into Process Monitor.

   http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx

Roger
___
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

Re: [sqlite] SQLite on Windows 2003

[Roger Binns]

>> Alternatively use Process Monitor from sysinternals.com which will show
>> arguments and return codes without any need to run a debugger.
>
> Even better, use FILEMON (from sysinternals.com) for clues.  It's wonderful.

Err, no.  You are 4 years out of date.  The functionality of filemon, regmon 
etc was all wrapped up into Process Monitor.

   http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx

Roger
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Dave Dyer]

>
>Alternatively use Process Monitor from sysinternals.com which will show 
>arguments and return codes without any need to run a debugger.

Even better, use FILEMON (from sysinternals.com) for clues.  It's wonderful.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Roger Binns]

On 04/07/2010 07:34 AM, Mark Spiegel wrote:
> If you can debug your application, more specifically SQLite, set a
> breakpoint in winOpen() and find out what return code CreateFile() is
> returning for the various calls.  That along with the arguments passed
> should help you work it out.

Alternatively use Process Monitor from sysinternals.com which will show 
arguments and return codes without any need to run a debugger.

Roger
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Mark Spiegel]

Burnett, Joe wrote:
> Hi Teg,
>
> UTF-8, no special characters in the file name WorkData.s3db.
>
> Thanks,
>
> Joe 
>
> Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
> TECHNOLOGY
> 2 Contra Way
> Merrimack, NH 03054
> 603.791.5113
> cell: 603.289.0481
>   
If you can debug your application, more specifically SQLite, set a 
breakpoint in winOpen() and find out what return code CreateFile() is 
returning for the various calls.  That along with the arguments passed 
should help you work it out.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Simon Slavin]

On 6 Apr 2010, at 9:03pm, Burnett, Joe wrote:

> Yes, I was able to open the DB file using the command line tool.
> I am unable to do so programmatically using C# .NET 2008.

Okay, there are some other steps in this test.

Rename that database file or move it somewhere safe.
Use the sqlite3 command-line tool to make a new database, and put just one 
table in it.
See if you can use your program to open this new database.

What I'm trying to do is establish if there's some problem with your required 
database.  Perhaps it's corrupt in some way.

If you get the same fault with this dummy database, the fault is with your code 
or your programming environment.  If the dummy database works fine, the fault 
is with the database you're trying to work with.

Also ...

On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote:

> I have a SQLite application running just fine on Windows XP SP3. I am
> attempting to move the application to Windows 2003
> Enterprise Edition. However, the connection open method returns null.
> The connection string is good. The database file is there.

What value does sqlite3_open return ?

And are you actually using sqlite3_ function calls or are you using a framework 
or library ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Burnett, Joe]

Hi Teg,

UTF-8, no special characters in the file name WorkData.s3db.

Thanks,

Joe 

Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
cell: 603.289.0481


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Teg
Sent: Tuesday, April 06, 2010 4:51 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite on Windows 2003

Hello Joe,

UTF8? What's the filename? If it has any accent characters, you need
to convert the filename to UTF8 before you pass the filename to the
SQLite. At least in C++ you do.

C

Tuesday, April 6, 2010, 4:03:24 PM, you wrote:

BJ> Hi Simon,

BJ> Yes, I was able to open the DB file using the command line tool.
BJ> I am unable to do so programmatically using C# .NET 2008.

BJ> Thanks,

BJ> Joe 

BJ> Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
BJ> TECHNOLOGY
BJ> 2 Contra Way
BJ> Merrimack, NH 03054
BJ> 603.791.5113
BJ> cell: 603.289.0481


BJ> -Original Message-
BJ> From: sqlite-users-boun...@sqlite.org
BJ> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
BJ> Sent: Tuesday, April 06, 2010 3:33 PM
BJ> To: General Discussion of SQLite Database
BJ> Subject: Re: [sqlite] SQLite on Windows 2003


BJ> On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote:

>> I have a SQLite application running just fine on Windows XP SP3. I am
>> attempting to move the application to Windows 2003
>> Enterprise Edition. However, the connection open method returns null.
>> The connection string is good. The database file is there.
>> I have the appropriate permissions on the file. The event viewer is
no
>> help.

BJ> Are you using the sqlite3_ library calls in a C program you've
written,
BJ> or are you using some sort of 3rd Party framework or library ?

BJ> If you try to open the same database using the sqlite3 command-line
BJ> tool, does it work ?

BJ> Simon.
BJ> ___
BJ> sqlite-users mailing list
BJ> sqlite-users@sqlite.org
BJ> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

BJ> ___
BJ> sqlite-users mailing list
BJ> sqlite-users@sqlite.org
BJ> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards,
 Tegmailto:t...@djii.com

___
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

Re: [sqlite] SQLite on Windows 2003

[Teg]

Hello Joe,

UTF8? What's the filename? If it has any accent characters, you need
to convert the filename to UTF8 before you pass the filename to the
SQLite. At least in C++ you do.

C

Tuesday, April 6, 2010, 4:03:24 PM, you wrote:

BJ> Hi Simon,

BJ> Yes, I was able to open the DB file using the command line tool.
BJ> I am unable to do so programmatically using C# .NET 2008.

BJ> Thanks,

BJ> Joe 

BJ> Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
BJ> TECHNOLOGY
BJ> 2 Contra Way
BJ> Merrimack, NH 03054
BJ> 603.791.5113
BJ> cell: 603.289.0481


BJ> -Original Message-
BJ> From: sqlite-users-boun...@sqlite.org
BJ> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
BJ> Sent: Tuesday, April 06, 2010 3:33 PM
BJ> To: General Discussion of SQLite Database
BJ> Subject: Re: [sqlite] SQLite on Windows 2003


BJ> On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote:

>> I have a SQLite application running just fine on Windows XP SP3. I am
>> attempting to move the application to Windows 2003
>> Enterprise Edition. However, the connection open method returns null.
>> The connection string is good. The database file is there.
>> I have the appropriate permissions on the file. The event viewer is no
>> help.

BJ> Are you using the sqlite3_ library calls in a C program you've written,
BJ> or are you using some sort of 3rd Party framework or library ?

BJ> If you try to open the same database using the sqlite3 command-line
BJ> tool, does it work ?

BJ> Simon.
BJ> ___
BJ> sqlite-users mailing list
BJ> sqlite-users@sqlite.org
BJ> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

BJ> ___
BJ> sqlite-users mailing list
BJ> sqlite-users@sqlite.org
BJ> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards,
 Tegmailto:t...@djii.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows 2003

[Burnett, Joe]

Hi Simon,

Yes, I was able to open the DB file using the command line tool.
I am unable to do so programmatically using C# .NET 2008.

Thanks,

Joe 

Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
cell: 603.289.0481


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: Tuesday, April 06, 2010 3:33 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite on Windows 2003


On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote:

> I have a SQLite application running just fine on Windows XP SP3. I am
> attempting to move the application to Windows 2003
> Enterprise Edition. However, the connection open method returns null.
> The connection string is good. The database file is there.
> I have the appropriate permissions on the file. The event viewer is no
> help.

Are you using the sqlite3_ library calls in a C program you've written,
or are you using some sort of 3rd Party framework or library ?

If you try to open the same database using the sqlite3 command-line
tool, does it work ?

Simon.
___
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

Re: [sqlite] SQLite on Windows 2003

[Simon Slavin]

On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote:

> I have a SQLite application running just fine on Windows XP SP3. I am
> attempting to move the application to Windows 2003
> Enterprise Edition. However, the connection open method returns null.
> The connection string is good. The database file is there.
> I have the appropriate permissions on the file. The event viewer is no
> help.

Are you using the sqlite3_ library calls in a C program you've written, or are 
you using some sort of 3rd Party framework or library ?

If you try to open the same database using the sqlite3 command-line tool, does 
it work ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite on Windows 2003

[Burnett, Joe]

Hi All.,

I have a SQLite application running just fine on Windows XP SP3. I am
attempting to move the application to Windows 2003
Enterprise Edition. However, the connection open method returns null.
The connection string is good. The database file is there.
I have the appropriate permissions on the file. The event viewer is no
help.

Is there something I am missing on Windows 2003?

Thanks and advance,

Joseph Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL
TECHNOLOGY
2 Contra Way
Merrimack, NH 03054
603.791.5113
CELL: 603.289.0481

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows with Mono

[Roosevelt Anderson]

If you are doing .Net development on both linux and windows I would
recommend using the System.Data.SQLite ADO dataprovider found here
over http://sqlite.phxsoftware.com/ over the default dataprovider
found in Mono. This library will not only work on the Mono platform
but will also work in Visual Studio.

On Mon, Mar 22, 2010 at 6:48 AM, Francesco PIRANEO G. <fpira...@iface.ch> wrote:
> Hi all,
> I normally develop my application on Ubuntu 9.10 and things goes very
> smoothly, but I develop with mono with the "cross platform philosophy"
> on my mind so I tried to partially port my application under windows.
>
> I had very hard time to find all necessary libraries and add-ins for
> mono to correctly use sqlite; on mono website I've found some reference
> (that I publish below) but the references for the "mono.data.sqlite" and
> "mono.data.sqliteclient" are still missing! I'm sure I forgot something so:
>
> 1. Is there any comprehensive document that explain how to install
> things that I need to use SQLite on win?
> 2. Where can I download what I need to use SQLite on mono for windows?
>
> Thank you very much for your precious help.
> Francesco
>
> Interesing but not exahaustive websites:
> http://www.mono-project.com/SQLite
> http://sqlite.phxsoftware.com/
> ___
> 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] SQLite on Windows with Mono

[Francesco PIRANEO G.]

Hi all,
I normally develop my application on Ubuntu 9.10 and things goes very 
smoothly, but I develop with mono with the "cross platform philosophy" 
on my mind so I tried to partially port my application under windows.

I had very hard time to find all necessary libraries and add-ins for 
mono to correctly use sqlite; on mono website I've found some reference 
(that I publish below) but the references for the "mono.data.sqlite" and 
"mono.data.sqliteclient" are still missing! I'm sure I forgot something so:

1. Is there any comprehensive document that explain how to install 
things that I need to use SQLite on win?
2. Where can I download what I need to use SQLite on mono for windows?

Thank you very much for your precious help.
Francesco

Interesing but not exahaustive websites:
http://www.mono-project.com/SQLite
http://sqlite.phxsoftware.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Windows XP with ADO.Net - batching updates + inserts in a single transaction - optimal transaction size

[Pavel Ivanov]

It depends on what else you want to do with database and how important
for you to be safe against power outages and OS crashes. If it's not
important and you're working with database from the single process and
single connection you may never commit a transaction opened at the
beginning of the application.

Pavel

On Thu, Nov 12, 2009 at 12:08 AM, Jon <barfo...@yahoo.com> wrote:
> For performance reasons, I want to batch my SQLite insert/replace
> operations in a single SQL transaction that I send to my local SQLite
> database running on Windows XP.  I am also using the ADO.Net assembly
> to interact with my SQLite database.
>
> Does anyone have any insight into how large my transaction batches
> should be?  For example, have up to 300 insert/replace operations in a
> single transaction?   up to 1000 insert/replace operations in a single
> transaction?  etc.
>
> ___
> 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] SQLite on Windows XP with ADO.Net - batching updates + inserts in a single transaction - optimal transaction size

[Jon]

For performance reasons, I want to batch my SQLite insert/replace
operations in a single SQL transaction that I send to my local SQLite
database running on Windows XP.  I am also using the ADO.Net assembly
to interact with my SQLite database.

Does anyone have any insight into how large my transaction batches
should be?  For example, have up to 300 insert/replace operations in a
single transaction?   up to 1000 insert/replace operations in a single
transaction?  etc.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite under windows

[Dan]

On Dec 22, 2008, at 6:10 PM, Dancsa wrote:

> Good Morning
> I have some problem with sqlite.
> I can't use it. I googled a lot after examples but i just found how  
> to use it under linux with gcc.
> Where can I find static library to link in or how sould I use the dll?

Easiest way to use sqlite is to download the amalgamation package:

   http://www.sqlite.org/sqlite-amalgamation-3_6_7.zip

The zip file contains a source file called sqlite3.c that contains all
of the sqlite code. Compile this file along with the other C files in
your application.


> It's needed to make pointers(with GetProccAddress) to each function  
> which i'd use?
>
> I use Dev-C++ under Win XP.
> Thanks Very Much!
> Dancsa
> ___
> 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] SQLite under windows

[Dancsa]

Good Morning
I have some problem with sqlite.
I can't use it. I googled a lot after examples but i just found how to use it 
under linux with gcc.
Where can I find static library to link in or how sould I use the dll?
It's needed to make pointers(with GetProccAddress) to each function which i'd 
use?

I use Dev-C++ under Win XP.
Thanks Very Much!
Dancsa
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite and windows shares

[Steve D. Perkins]

Ditto that... There is no problem using a windows share.  


On Mon, 06 Dec 2004 17:20:46 +0100, Gregory Letellier
<[EMAIL PROTECTED]> wrote:
> this works fine on windows, i've use it
> 
> Christian Kienle a écrit :
> 
> 
> 
> > Hi all,
> >
> > I would like to write an app with C++ which uses sqlite.
> > We will soon have a windows network here. Is it possible to place the
> > sqlite database files on one server and to let the client apps access
> > the sqlite db file through a windows share which is "mounted" like a
> > normal drive - like G:\my\path\to\mydb.db?
> >
> > At the moment I have no windows to test it.
> >
> > It would be cool to tell me that. :)
> >
> >
> > thx
> > Christian
> >
> >
> >
>

Re: [sqlite] sqlite and windows shares

[Clay Dowling]

Christian Kienle said:
> I would like to write an app with C++ which uses sqlite.
> We will soon have a windows network here. Is it possible to place the
> sqlite database files on one server and to let the client apps access
> the sqlite db file through a windows share which is "mounted" like a
> normal drive - like G:\my\path\to\mydb.db?

http://www.sqlite.org/faq.html#q7

In summary, it's perfectly possible, but not recommended.  One way to make
it work is to have the writer app run on the machine which holds the
database and only have clients access it via shares.  If you use a fairly
fast protocol (i.e. not SOAP) the speed issues shouldn't be too bad.

Clay
-- 
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development

Re: [sqlite] sqlite and windows shares

[Christian Kienle]

Thx.

On Dec 6, 2004, at 5:20 PM, Gregory Letellier wrote:
this works fine on windows, i've use it
Christian Kienle a écrit :
Hi all,
I would like to write an app with C++ which uses sqlite.
We will soon have a windows network here. Is it possible to place the 
sqlite database files on one server and to let the client apps access 
the sqlite db file through a windows share which is "mounted" like a 
normal drive - like G:\my\path\to\mydb.db?

At the moment I have no windows to test it.
It would be cool to tell me that. :)
thx
Christian

[sqlite] sqlite and windows shares

[Christian Kienle]

Hi all,
I would like to write an app with C++ which uses sqlite.
We will soon have a windows network here. Is it possible to place the 
sqlite database files on one server and to let the client apps access 
the sqlite db file through a windows share which is "mounted" like a 
normal drive - like G:\my\path\to\mydb.db?

At the moment I have no windows to test it.
It would be cool to tell me that. :)
thx
Christian

Re: [sqlite] SQLite for Windows CE

[John Oliva]

I am also interested in synchronizing SQLite databases.  As far as I am
aware, there is no support in the SQLite code for the tasks required to
synchronize multiple databases.  You would need meta-data indicating
whether data has been added/deleted/modified along with either timestamps
or update numbering in order to reconcile the changes and possibly
conflicts between multiple databases.

You might want to google for the techniques employed in synchronizing
PalmOS PDB files between the PDA and host. It provides table based
synchronization, and seems to be a robust and efficient solution between a
pair of databases.

John Oliva

> Does anyone know how to synchronize the data on the WinCE device with a
> database on a server computer?  I'm just testing the feasibility of using
> SQLite for our projects that run under wireless  WinCE 3.0 device.  The
> primary database is a Sybase database server running on Sun workstations.
> The WinCE SQLite would be a subset of the Sybase database.  My conceptual
> problem is if we do that, how could we keep the two databases
> synchronized?
> The wireless computers will not always be within radio frequency (RF) of
> the
> database, so a large part of its work is off-line from the main Sybase
> server.
>
> Thanks for any hints or links you may be able to provide.
>
> Mel Stober
>

[sqlite] SQLite for Windows CE

[Stober, Mel]

Does anyone know how to synchronize the data on the WinCE device with a
database on a server computer?  I'm just testing the feasibility of using
SQLite for our projects that run under wireless  WinCE 3.0 device.  The
primary database is a Sybase database server running on Sun workstations.
The WinCE SQLite would be a subset of the Sybase database.  My conceptual
problem is if we do that, how could we keep the two databases synchronized?
The wireless computers will not always be within radio frequency (RF) of the
database, so a large part of its work is off-line from the main Sybase
server.

Thanks for any hints or links you may be able to provide.

Mel Stober

Re: [sqlite] SQLite and Windows 2k

[andy]

To make the dll, I could not get the dllwrap to work.  Based on:
http://www.neuro.gatech.edu/users/cwilson/cygutils/dll-stuff/README
I used this script to create the dll.
#!/bin/sh
gcc -mno-cygwin -Wl,--base-file,base.tmp \
 -mdll -Wl,-e,[EMAIL PROTECTED] \
  -o sqlite3.dll *.o -L/lib/mingw -lmsvcrt
dlltool --base-file base.tmp --output-exp exp.tmp --def sqlite3.def
gcc -mno-cygwin -Wl,--base-file,base.tmp  exp.tmp \
  -mdll -Wl,-e,[EMAIL PROTECTED] -o sqlite3.dll \
  *.o  -L/lib/mingw  -lmsvcrt
dlltool --base-file base.tmp --output-exp exp.tmp --def sqlite3.def
gcc exp.tmp -mno-cygwin -mdll \
  -Wl,-e,[EMAIL PROTECTED] -o sqlite3.dll \
  *.o -L/lib/mingw  -lmsvcrt
Boy did I make that harder than it needed to be.  Here is the easy way:
gcc -shared -mno-cygwin -o sqlite3.dll \
  -L/lib/mingw -lmsvcrt  *.o sqlite3.def
-Andy
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite and Windows 2k

[andy]

Chris Ulliott wrote:
Andy!
 
FANTASTIC JOB! Thank you! Could you also make the source available
please and tell me what changes you made? In the future if a new version
comes out, it may not include your change and I need it!
 
I would hate to upgrade and loose your change...
 
Thanks again, Great work!
 
Chris
 

Wahoo! Got it! It was a -mno-cygwin that was the magic. I have uploaded
it to my website. You can get it from

http://squeakycode.net/files/sqlite3.dll
I noticed the sqlite3.def was also missing sqlite3_changes, so I added
it too.
Let me know if you have problems.
-Andy

I made no changes to the .c files.  the .def file has been patched and 
checked in so you wont need to edit it either.

So here is what I did.
dl the source and uncompress it.  then
mkdir build
cd build
../configure
Then I edited the Makefile and changed this line:
TCC = gcc -g -O2 -mno-cygwin -DOS_WIN=1 -DHAVE_USLEEP=1 -I. -I${TOP}/src
to include the -mno-cygwin
then do a make.  This will make the sqlite.exe for windows without 
requiring the cygwin1.dll

To make the dll, I could not get the dllwrap to work.  Based on:
http://www.neuro.gatech.edu/users/cwilson/cygutils/dll-stuff/README
I used this script to create the dll.
#!/bin/sh
gcc -mno-cygwin -Wl,--base-file,base.tmp \
 -mdll -Wl,-e,[EMAIL PROTECTED] \
  -o sqlite3.dll *.o -L/lib/mingw -lmsvcrt
dlltool --base-file base.tmp --output-exp exp.tmp --def sqlite3.def
gcc -mno-cygwin -Wl,--base-file,base.tmp  exp.tmp \
  -mdll -Wl,-e,[EMAIL PROTECTED] -o sqlite3.dll \
  *.o  -L/lib/mingw  -lmsvcrt
dlltool --base-file base.tmp --output-exp exp.tmp --def sqlite3.def
gcc exp.tmp -mno-cygwin -mdll \
  -Wl,-e,[EMAIL PROTECTED] -o sqlite3.dll \
  *.o -L/lib/mingw  -lmsvcrt
strip sqlite3.dll
cp sqlite3.dll /cygdrive/d/sqlite/
Watch the wrapping, I added a blank line between each command.
However, I dont really think you'll need all that.  Sense  3 is still in 
beta its probably just a build problem that'll get cleared up.  You'll 
be able to download the dll just fine and it'll work once all the kinks 
get worked out.  I'm just posting this so people can play with the dll 
while its in beta.

Have fun,
-Andy
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite and Windows 2k

[Chris Ulliott]

Andy!
 
FANTASTIC JOB! Thank you! Could you also make the source available
please and tell me what changes you made? In the future if a new version
comes out, it may not include your change and I need it!
 
I would hate to upgrade and loose your change...
 
Thanks again, Great work!
 
Chris
 
>Wahoo! Got it! It was a -mno-cygwin that was the magic. I have uploaded
it to my website. You can get it from
> 
http://squeakycode.net/files/sqlite3.dll
>I noticed the sqlite3.def was also missing sqlite3_changes, so I added
it too.
>Let me know if you have problems.
>-Andy

Re: [sqlite] SQLite and Windows 2k

[andy]

Chris Ulliott wrote:
Hi All,
I have downloaded from the downloads page the DLL (Sqlite.dll) for
Windows. I have written some code using the API and everything was going
great until I needed to do an execute and it came to my attention that
the DLL does not export sqlite3_exec
Does anybody have a Win32 DLL of SQLite 3 that exports all the
documented functions? Am I missing something else?
I also tried using the SQLite3.dll instead but I soon found that there
are NO EXPORTED FUNCTIONS from there whatsoever.
Any help appreciated,
Thanks,
Chris
Wahoo!  Got it!  It was a -mno-cygwin that was the magic.  I have 
uploaded it to my website.  You can get it from

http://squeakycode.net/files/sqlite3.dll
I noticed the sqlite3.def was also missing sqlite3_changes, so I added 
it too.

Let me know if you have problems.
-Andy
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite and Windows 2k

[Chris Ulliott]

Hi Richard
 
Unfortionatly there is no link for a Compiled Binary (win 32) for
version 2.x on the downloads page otherwise I would be using it.
 
Thanks for replying.
 
Chris
 
 
 
Richard Boehme wrote:
 
The regular sqlite.dll should be the 2.X release, not the 3 release, and
therefore won't export sqlite3_exec, but will export sqlite_exec.

As for the other, I haven't played around with sqlite3 much as I'm in
the middle of a project, but I intend to in a couple of days.


Thank you.

Richard Boehme




Chris Ulliott wrote: 

Hi All,

I have downloaded from the downloads page the DLL (Sqlite.dll) for

Windows. I have written some code using the API and everything was going

great until I needed to do an execute and it came to my attention that

the DLL does not export sqlite3_exec

Does anybody have a Win32 DLL of SQLite 3 that exports all the

documented functions? Am I missing something else?

I also tried using the SQLite3.dll instead but I soon found that there

are NO EXPORTED FUNCTIONS from there whatsoever.

Any help appreciated,

Thanks,

Chris




-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]






-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]