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
documentatio
1:12 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQLite C# differences between Windows Server 2008 and
2003
Sure here is the code.
using (SQLiteConnection sql_con = new SQLiteConnection("Data
Source=C:\\Path\\To\\File\\docuidb.db;"))
neider FE
Sent: Thursday, June 20, 2013 10:37 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQLite C# differences between Windows Server 2008 and 2003
Can you post the code?
And why do you need to use the SQLite.Interop.dll ?
-Original Message-
From:
e.org'
Subject: [sqlite] SQLite C# differences between Windows Server 2008 and 2003
Hello,
I am using System.Data.SQLite.dll version 1.0.82.0 and SQLite.Interop.dll
to connect to some SQLite databases using C# Web Services. The code is
working fine on Windows Server 2008, but on 2003 it is not
Hello,
I am using System.Data.SQLite.dll version 1.0.82.0 and SQLite.Interop.dll to
connect to some SQLite databases using C# Web Services. The code is working
fine on Windows Server 2008, but on 2003 it is not releasing the database at
the end of the call. It is extremely simple code, just
On 12 January 2012 12:22, bhaskarReddy wrote:
>
> Hi Friends,
>
> I am using SQLite. This is the first time. And i am creating,
> accessing and retrieving data from the table.
>
> I am using sqlite3_exec() function to insert and retrieve data.
> Instead using sqlite3_exec(), is t
On 12 Jan 2012, at 11:22am, bhaskarReddy wrote:
> I am using SQLite. This is the first time. And i am creating,
> accessing and retrieving data from the table.
>
> I am using sqlite3_exec() function to insert and retrieve data.
> Instead using sqlite3_exec(), is there any other
Hi Friends,
I am using SQLite. This is the first time. And i am creating,
accessing and retrieving data from the table.
I am using sqlite3_exec() function to insert and retrieve data.
Instead using sqlite3_exec(), is there any other APIs which help inserting
data into tables.
Will do. Thanks again to everyone. At least I learned how to use strace,
which I didnt no.
On Wed, Mar 24, 2010 at 2:25 PM, Pavel Ivanov wrote:
> > When allocating memory for my ICMP packets I wasnt doind a bzero to fill
> all
> > fields with 0, so some "garbage" generated by Sqlite use of memor
On Wed, Mar 24, 2010 at 11:19 AM, Martin Sigwald wrote:
> Problem Solved: As some one point out, it was MY fault.
> When allocating memory for my ICMP packets I wasnt doind a bzero to fill all
> fields with 0, so some "garbage" generated by Sqlite use of memory was
> "corrupting" my packets.
> Tha
> When allocating memory for my ICMP packets I wasnt doind a bzero to fill all
> fields with 0, so some "garbage" generated by Sqlite use of memory was
> "corrupting" my packets.
And still try please my very first suggestion - run you program with
valgrind (just to get used to it and to use it rig
Problem Solved: As some one point out, it was MY fault.
When allocating memory for my ICMP packets I wasnt doind a bzero to fill all
fields with 0, so some "garbage" generated by Sqlite use of memory was
"corrupting" my packets.
Thank you all for the help. One of the best user groups I ever met. Te
On Wed, Mar 24, 2010 at 11:09 AM, Martin Sigwald wrote:
> Doing N pings after a _close or a query has the same result as doind one:
> not one of them works.
Do 2 pings work ever? For example, how about each of these scenarios?
open_db
ping
ping
close_db
or
ping
ping
or
open_db
close_db
ping
Doing N pings after a _close or a query has the same result as doind one:
not one of them works.
On Wed, Mar 24, 2010 at 2:07 PM, David Baird wrote:
> On Wed, Mar 24, 2010 at 9:42 AM, Martin Sigwald
> wrote:
> > I meant socket. I know sockets are FDs. My mistake, sorry.
> > Yes, I tried putting
On Wed, Mar 24, 2010 at 9:42 AM, Martin Sigwald wrote:
> I meant socket. I know sockets are FDs. My mistake, sorry.
> Yes, I tried putting the call before Sqlite calls and it works perfectly. If
> I put it between open and close it works, provided I dont do anything else.
> For example, if I open
I'm attaching the strace output for the following code you asked:
int main(void){
sqlite3* db_handle=NULL;
if(sqlite3_open("guido.db",&db_handle))
{ //abro DB
fprintf(stderr,"Error while open
DB:%s\n",sqlite3_errmsg(db_handle));
printf("No pude abrir la DB\n
> I don't notice any cases of where a stale file descriptor is being
> accessed. I'm stumped :-/
Can it be a problem with clone() calls? AFAIK, it's how SQLite checks
if it can work safely from multiple threads. Martin, can you recompile
SQLite with SQLITE_THREADSAFE set to 0 and look if your pin
On Wed, Mar 24, 2010 at 9:24 AM, David Baird wrote:
> On Wed, Mar 24, 2010 at 9:05 AM, Martin Sigwald wrote:
>> While I could gather, both the open system called generated by the DB and
>> the socket() syscall are returning a FD=3.
>> That is, they are both trying to use the same filedescriptor.
I meant socket. I know sockets are FDs. My mistake, sorry.
Yes, I tried putting the call before Sqlite calls and it works perfectly. If
I put it between open and close it works, provided I dont do anything else.
For example, if I open the DB, ping, then run a query then ping again, the
second ping
On Wed, Mar 24, 2010 at 9:05 AM, Martin Sigwald wrote:
> While I could gather, both the open system called generated by the DB and
> the socket() syscall are returning a FD=3.
> That is, they are both trying to use the same filedescriptor. My guess is
> packets get sent to that file descriptor, in
On Wed, Mar 24, 2010 at 12:05:58PM -0300, Martin Sigwald scratched on the wall:
> While I could gather, both the open system called generated by the DB and
> the socket() syscall are returning a FD=3.
> That is, they are both trying to use the same filedescriptor. My guess is
> packets get sent to
While I could gather, both the open system called generated by the DB and
the socket() syscall are returning a FD=3.
That is, they are both trying to use the same filedescriptor. My guess is
packets get sent to that file descriptor, instead of the port. How can I
changed this? I just followed stand
I tried using STRACE, unfortunately, I am quite new to Linux programming, so
I can't make much sense out of the output. I attached it to this email, in
case some kind soul would like to take a look at it.
The program ran is exactly this:
#include
#include
#include
#include "ping.h"
int main(vo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martin Sigwald wrote:
> Here is the actual code:
>
> int main(void)
> {
> sqlite3* db_handle;
>
> sqlite3_open(DB_NAME,&db_handle);
> sqlite3_close(db_handle);
> my_ping("10.0.0.4");
>
> return 0;
> }
>
> If I call close af
On 23 Mar 2010, at 7:29pm, Martin Sigwald wrote:
> DB_NAME equals "servers.db".
> Both close and open return 0, my code catches a possible error, I didnt
> included for legibility.
> I tired using ":memory:", same result: cant ping.
> These is quite frustrating.
Hmm. Thanks for trying. If both
DB_NAME equals "servers.db".
Both close and open return 0, my code catches a possible error, I didnt
included for legibility.
I tired using ":memory:", same result: cant ping.
These is quite frustrating.
On Tue, Mar 23, 2010 at 4:23 PM, Simon Slavin wrote:
>
> On 23 Mar 2010, at 7:06pm, Martin S
On 23 Mar 2010, at 7:06pm, Martin Sigwald wrote:
> Here is the actual code:
>
> int main(void)
> {
>sqlite3* db_handle;
>
> sqlite3_open(DB_NAME,&db_handle);
> sqlite3_close(db_handle);
> my_ping("10.0.0.4");
>
> return 0;
> }
>
> If I call close after ping, it works. How
Here is the actual code:
int main(void)
{
sqlite3* db_handle;
sqlite3_open(DB_NAME,&db_handle);
sqlite3_close(db_handle);
my_ping("10.0.0.4");
return 0;
}
If I call close after ping, it works. However, if besides of opening the DB
I perform any query, ping doesnt work e
On Tue, Mar 23, 2010 at 12:55 PM, Martin Sigwald wrote:
> I have a program which builds an ICMP package over IP and sends it. Before
> that, I get IP number and other information from a SQlite DB. I was having
> problems, so I began to comment different parts of the code, until I got to
> this cod
> Pavel: Yes, I allocate memory inside the ping function, but that is done
> after calling de sqlite functions. There are no pointers shared between the
> sqlite functions and the ping part.
Actually I meant pointers shared between ping part and the part before
calls to sqlite functions.
Did you t
I already tried that, and the first ping works while the second one doesn't,
which validates my "screwing ports theory".
Simon: Tried changing the DB_NAME and it didnt work either.
Pavlov: Yes, I allocate memory inside the ping function, but that is done
after calling de sqlite functions. There a
Hello Martin,
Do the ping both before and after you open the DB.
ping_server("10.0.0.4"); //my ping function, which pings a "hardcoded" IP,
sqlite3_open(DB_NAME);
sqlite3_close(DB_NAME);
ping_server("10.0.0.4"); //my ping function, which pings a "hardcoded" IP,
See if the first one works. That'l
On 23 Mar 2010, at 4:55pm, Martin Sigwald wrote:
> sqlite3_open(DB_NAME);
> sqlite3_close(DB_NAME);
>
> ping_server("10.0.0.4"); //my ping function, which pings a "hardcoded" IP,
> doesnt interact with DB
>
>
> If I run that code, the package nevers gets send (can't detect it with
> Wireshark)
Does your pinging code involves some pointers to memory (strings or
any other stuff) that could be already released before SQLite code is
called? Try to run your program under valgrind and see whether it
gives any errors.
Pavel
On Tue, Mar 23, 2010 at 12:55 PM, Martin Sigwald wrote:
> I have a p
I have a program which builds an ICMP package over IP and sends it. Before
that, I get IP number and other information from a SQlite DB. I was having
problems, so I began to comment different parts of the code, until I got to
this code (pseudocode):
sqlite3_open(DB_NAME);
sqlite3_close(DB_NAME);
Darko Miletic wrote:
>> Maybe he is looking for a C++ wrapper for Sqlite.
>
> Than look no further. SOCI is the definite sqlite c++ wrapper.
>
> http://soci.sourceforge.net/
This wrapper looked really promising. But, the SQLite backend wasn't
being maintained and is no longer officially suppor
Rajesh Nair wrote:
> Hi
>
> Is there any future plan to develop sqlite in C++.
>
Given that C++ has source and binary compatibility with C, I don't think
there would be any point. I develop in C++ using SQLite quite happily,
and see no reason to stop now.
Clay
___
Darko Miletic wrote:
> Rajesh Nair wrote:
>> Hi
>>
>> Is there any future plan to develop sqlite in C++.
>>
>
> Why would anybody want to do that?
Sabotage?
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/ma
dcharno wrote:
>>> Is there any future plan to develop sqlite in C++.
>>>
>> Why would anybody want to do that?
>
> Maybe he is looking for a C++ wrapper for Sqlite.
Than look no further. SOCI is the definite sqlite c++ wrapper.
http://soci.sourceforge.net/
_
>> Is there any future plan to develop sqlite in C++.
>>
>
> Why would anybody want to do that?
Maybe he is looking for a C++ wrapper for Sqlite.
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
___
sqlite-users mailing list
sqlite-users@sqlit
Rajesh Nair wrote:
> Hi
>
> Is there any future plan to develop sqlite in C++.
>
Why would anybody want to do that?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 5/29/08, Rajesh Nair <[EMAIL PROTECTED]> wrote:
> Hi
>
> Is there any future plan to develop sqlite in C++.
Didn't you (or someone else) just ask that just a couple of days ago?
I would say the chances of SQLite++ are less than zero (thank
heavens), but for more details, search the list for an
Hi
Is there any future plan to develop sqlite in C++.
Rajesh Nair
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 6/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
sqlite3_enable_load_extension(db, 1);
sqlite3_load_extension(db, "./libfts1.so", 0, 0);
thanks, it works fine
--
Regards,
Zoobave A
http://zoobave.blogspot.com/
Zoobave <[EMAIL PROTECTED]> wrote:
> Hello group,
>
> In sqlite, how to load fts1 module in 'C'? I couldn't execute the
> *"select load_extension('libfts1.so');" * query using "sqlite3_exec"
> function. How can i execute the above query to load fts1 module, in order
> to use virtual tab
Hello group,
In sqlite, how to load fts1 module in 'C'? I couldn't execute the
*"select load_extension('libfts1.so');" * query using "sqlite3_exec"
function. How can i execute the above query to load fts1 module, in order
to use virtual tables?
by
zoobave
http://zoobave.blogspot.com/
Pavan wrote:
I was googling for c++ interfaces for sqlite and found sqlitemm provides.
But, i am unable to download the code. Can some one pls point me to link
from where i can download the c++ interfaces for sqlite.
This page http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers has links
to ma
Pavan wrote:
> Hi,
>
> I was googling for c++ interfaces for sqlite and found sqlitemm provides.
> But, i am unable to download the code. Can some one pls point me to link
> from where i can download the c++ interfaces for sqlite.
You can try my wrapper at http://www.lazarusid.com/download/sqdat
Hi,
I was googling for c++ interfaces for sqlite and found sqlitemm provides.
But, i am unable to download the code. Can some one pls point me to link
from where i can download the c++ interfaces for sqlite.
Thanks,
Pavan.
--
'
Al
> For me a C library as no way to carry a this pointer for a c++ wrapper,
> I pass a static C function as call-pack, and this pointer as usr_data,
> and call member function from there. Maybe I'm wrong but it works:
Ah I see. This is handled by the runtime, the C function gets a pointer to
the
me
Richard Heyes wrote:
> > I don't know what unsafe is, but shouldnt it be static (since no 'this'
> pointer
> > can be expected) ?
>
> The unsafe keyword allows the use of pointers, and there's no need for
> static as the method is passed as an instance method.
>
> --
> Richard Heyes
Does it have
Richard Heyes wrote:
> > I've done a c++ wrapper around sqlite and have no problem with count(*),
> do you
> > check NULL values ?
>
> I check for null pointers in the argv values. Thing is the callback appears
> to run just as it should, the column name is returned as "count(*)", number
> of colu
Richard Heyes wrote:
> Hi,
>
> I'm in the process of writing a C# wrapper for Sqlite, and all is going
> reasonably well. However the following query is giving me problems:
>
> SELECT COUNT(*) FROM myTable
>
> Whenever it's run, a null reference exception is thrown. When stepping
> through the cod
Hi,
I'm in the process of writing a C# wrapper for Sqlite, and all is going
reasonably well. However the following query is giving me problems:
SELECT COUNT(*) FROM myTable
Whenever it's run, a null reference exception is thrown. When stepping
through the code I can see the callback method runni
54 matches
Mail list logo
