Re: [sqlite] Encryption using System.Data.SQLite.dll
Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT a.column1 FROM table1 AS a, table2 AS b; however this works: SELECT a.column1, b.column1 FROM table1 AS a, table2 AS b; because /sqlite3_column_table_name /only returns columns in the result set. Is there a way to get the table names that were referenced in the query itself? Thanks in advance, bishwa ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Encryption using System.Data.SQLite.dll
On 08/20/2012 11:08 AM, Bishwa Shrestha wrote: Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT a.column1 FROM table1 AS a, table2 AS b; however this works: SELECT a.column1, b.column1 FROM table1 AS a, table2 AS b; because /sqlite3_column_table_name /only returns columns in the result set. Is there a way to get the table names that were referenced in the query itself? Thanks in advance, bishwa Sorry, wrong thread. I'll create a new one. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to find table names referenced in the query, not in the result set
Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT a.column1 FROM table1 AS a, table2 AS b; however this works: SELECT a.column1, b.column1 FROM table1 AS a, table2 AS b; because /sqlite3_column_table_name /only returns columns in the result set. Is there a way to get the table names that were referenced in the query itself? Thanks in advance, bishwa ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Transaction issues with WinRT build
Simon Slavin slavins@... writes: Using both versions can you tell us the results of SELECT sqlite_version(),sqlite_source_id() Results are exactly the same for both dlls: 3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc The inserts are also in a transaction block. Basically it looks like this: begin transaction insert ... insert... update... - fail So the transaction is already started and the db and journal files are opened. But it also happens on the simple case: begin transaction update... - fail It does not make a difference if I use WAL or not, already tried disbling that. Kind Regards Lukas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3 error
Dear Support Team, I receive an sqlite3 error (see attached) whenever I re-start my computer. I don't actually know what this application is but I would like to get rid of the error. Thanks, Sunshine *Terri Sunshine Lutey* *President and Musical Director, Sunshine Performance Club* *President and Advocate, Alzheimer's Association Club of Laguna Woods* *Advocate, The Associates Club of Saddleback Memorial Foundation and Kiwanis * *Home Phone: 949 586-4100* *Cell Phone: 949 278-6454* *E-Mail: sunshinelu...@gmail.com* ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to find table names referenced in the query, not in the result set
On 20 Aug 2012, at 10:18am, Bishwa Shrestha bishwa.shres...@gmail.com wrote: Is there a way to get the table names that were referenced in the query itself? I don't think so. Consider that you might do things like SELECT 1,2,3; SELECT (a.column1 + b.column1) FROM table1 AS a, table2 AS b; so it's quite possible that values returned aren't from any table at all. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Transaction issues with WinRT build
On 19 Aug 2012, at 6:31pm, lukas lukas.fellech...@gmx.net wrote: Simon Slavin slavins@... writes: Using both versions can you tell us the results of SELECT sqlite_version(),sqlite_source_id() Results are exactly the same for both dlls: 3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc That's interesting and useful for use to know. The inserts are also in a transaction block. Basically it looks like this: begin transaction insert ... insert... update... - fail So the transaction is already started and the db and journal files are opened. But it also happens on the simple case: begin transaction update... - fail It does not make a difference if I use WAL or not, already tried disbling that. Is there a chance that you simply have an UPDATE command with a bad syntax ? You say it works fine on one implementation of 3.7.13 but not the other ? I'm mystified by what you're seeing but I hope someone else can help. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3 error
On 20 Aug 2012, at 3:05am, Sunshine Lutey sunshinelu...@gmail.com wrote: I receive an sqlite3 error (see attached) whenever I re-start my computer. You cannot attach files to messages to this list. However, the most frequent cause of this is installing iTunes on a Windows computer. If you have done this, please install the latest version of iTunes. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to find table names referenced in the query, not in the result set
You can try to use authorizer (http://www.sqlite.org/c3ref/set_authorizer.html) although it seems to me SQLite won't inform you about access to table2 in the first query. Pavel On Mon, Aug 20, 2012 at 2:18 AM, Bishwa Shrestha bishwa.shres...@gmail.com wrote: Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT a.column1 FROM table1 AS a, table2 AS b; however this works: SELECT a.column1, b.column1 FROM table1 AS a, table2 AS b; because /sqlite3_column_table_name /only returns columns in the result set. Is there a way to get the table names that were referenced in the query itself? Thanks in advance, bishwa ___ 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 Provider cannot be found error
Hello, I am trying to convert and ASP page to ASP.NET on Windows 2008 R2. The program I converted previously read in data from multiple Microsoft Access databases, looping through each directory under a directory called pub. The data in the tables is created from a software package called eMill, which sends emails in batches. The ASP page provides totals on how many emails were sent out for each letter type for that day. We are upgrading our eMill application and the new version of the software writes to SQLite databases instead of Microsoft Access db's. I have installed .NET 4.0 (dotNetFx40_Full_x86_x64.exe) on the new server, as well as System.Data.SQLite for .NET 4.0 (sqlite-netFx40-setup-bundle-x64-2010-1.0.81.0.exe), and the program is getting an error Provider cannot be found. It may not be properly installed when trying to open the SQLite databases. The only differences in this program from one that works with Microsoft Access is the provider name (System.Data.SQLite instead of Microsoft.Jet.OLEDB.4.0) and the database names (store.db3 instead of Messages.mdb). Here is a portion of the code, the complete aspx file is attached as txt: --- % dim rs,x, conn, dir conn=Server.CreateObject(ADODB.Connection) 'conn.provider=Microsoft.Jet.OLEDB.4.0 conn.provider=System.Data.SQLite conn.Mode = 1 'conn.open(server.mappath(..\pub\ folder.name \Messages.mdb)) conn.open(server.mappath(..\pub\ folder.name \store.db3)) rs=Server.CreateObject(ADODB.Recordset) The line of code that gets the error is the open of the database. I have tried many things to get rid of this error, among them: registered the System.Data.SQLite.dll, added C:\Program Files\System.Data.SQLite\2010\bin to the PATH variable, re-installed System.Data.SQLite - checked first box to create assemblies, re-installed System.Data.SQLite again - checked second box to create GAC, modified the web_config, with and without the version and publickeytoken (Version=1.0.81.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139), . Does anyone know if there is something that I need to do differently in the code to access the SQLite databases? Or is there something wrong with the environment? Could it be a permissions problem? Is there a way I can increase the debug level to get a better log of the error? (I do not currently have Visual Studio installed on the server). Any help or ideas on how to fix this would be much appreciated. Thanks! Roger Rice. @set @debug(on) %@ Page aspcompat=true % html headtitleDisplay eMill Letter Counts/title/head body % 'Using System.Data Dim grand_total_emails As Integer Dim fso fso = Server.CreateObject(Scripting.FileSystemObject) Dim rootFolder rootFolder = fso.GetFolder(Server.MapPath(..\pub)) Dim subFolders subFolders = rootFolder.SubFolders Dim folder For Each folder in subFolders Response.Write (FolderName: folder.Name br) % % dim rs,x, conn, dir conn=Server.CreateObject(ADODB.Connection) 'conn.provider=Microsoft.Jet.OLEDB.4.0 conn.provider=System.Data.SQLite conn.Mode = 1 'conn.open(server.mappath(..\pub\ folder.name \Messages.mdb)) conn.open(server.mappath(..\pub\ folder.name \store.db3)) rs=Server.CreateObject(ADODB.Recordset) 'rs.open (SELECT count(Receiver) _ ' FROM Messages _ ' where ModifyDate DateTime.Today.AddHours(-4) _ ' and ModifyDate DateTime.Today.AddHours(6) ,conn) rs.open (SELECT count(Receiver) as total_emails _ FROM Messages _ where ModifyDate Date() - .16 _ and ModifyDate Date () + .25 ,conn) % !-- h2List Database Table/h2-- table border=1 width=50% tr bgcolor=#b0c4de % % /tr %do until rs.EOF% tr bgcolor=#b0c4de !-- tr bgcolor=#f0f0f0 -- form method=post action=demo_db_edit.asp target=_blank % for each x in rs.Fields if x.value 0 Then % td%Response.Write(x.value)% /td %grand_total_emails = grand_total_emails + x.value% %end if next % /form %rs.MoveNext% /tr % loop rs.close rs=nothing conn.close conn=nothing % /table % next % table border=1 width=50% tr bgcolor=yellow thGrand Total for %Response.Write(DateTime.Today.AddHours(-4) - DateTime.Today.AddHours(6))%/th td%Response.Write(grand_total_emails)% /td /table % 'End Using % /body /html
Re: [sqlite] SQLite Provider cannot be found error
Rice, Roger wrote: dim rs,x, conn, dir conn=Server.CreateObject(ADODB.Connection) 'conn.provider=Microsoft.Jet.OLEDB.4.0 conn.provider=System.Data.SQLite conn.Mode = 1 'conn.open(server.mappath(..\pub\ folder.name \Messages.mdb)) conn.open(server.mappath(..\pub\ folder.name \store.db3)) rs=Server.CreateObject(ADODB.Recordset) The above code fragment looks a lot like classic ASP, not ASP.NET. The System.Data.SQLite ADO.NET provider only works with .NET. It does not work with classic ADO, which was used by classic ASP. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite Provider cannot be found error
Thanks Joe, I'll work on converting this to ASP.NET. Thanks for pointing me in the right direction! :: Roger Rice, Senior Software Administrator :: University Information Technology Services (UITS) :: University of Massachusetts President's Office :: 774-455-7825 Phone :: 774-455-7733 Fax :: rr...@umassp.edu University of Massachusetts : 333 South St. : Suite 400 : Shrewsbury, MA 01545 : www.massachusetts.edu -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Monday, August 20, 2012 2:03 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] SQLite Provider cannot be found error Rice, Roger wrote: dim rs,x, conn, dir conn=Server.CreateObject(ADODB.Connection) 'conn.provider=Microsoft.Jet.OLEDB.4.0 conn.provider=System.Data.SQLite conn.Mode = 1 'conn.open(server.mappath(..\pub\ folder.name \Messages.mdb)) conn.open(server.mappath(..\pub\ folder.name \store.db3)) rs=Server.CreateObject(ADODB.Recordset) The above code fragment looks a lot like classic ASP, not ASP.NET. The System.Data.SQLite ADO.NET provider only works with .NET. It does not work with classic ADO, which was used by classic ASP. ___ 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] Question about memory consumption of SQLite
Hi I am writing an application which creates a db in runtime (i.e. only INSERT queries are performed, indexing only by primary key...) I am running with the following pragmas: executeString(PRAGMA temp_store=MEMORY); executeString(PRAGMA journal_mode = MEMORY;); executeString(PRAGMA page_size = 8192;); executeString(PRAGMA cache_size=1;); how much memory on heap will the application consume (from SQLite point of view). at most ? is there a rule of thumb here ? (i mean, I assume that page_size* cache_size matters... but what else ?) cheers Tal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Question about memory consumption of SQLite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 20/08/12 13:07, Tal Tabakman wrote: how much memory on heap will the application consume (from SQLite point of view). Why don't you ask SQLite while running your representative schema and queries? http://www.sqlite.org/c3ref/c_dbstatus_options.html See also: http://www.sqlite.org/c3ref/memory_highwater.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlAynTwACgkQmOOfHg372QTdZwCgtKrW3Xp+15MvpX0OCPrtlf94 PuwAoI/CMvApEQPXQoY2leujtYVDtiZ2 =dfMe -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users