Re: [sqlite] sqlite-users Digest, Vol 6, Issue 90
In my previous post I wrote: >I have successfully created an ASP.Net web page that uses the Membership & >Role providers (http://www.codeproject.com/KB/aspnet/SQLiteProviders.aspx) I was in error. I actually am using the membership and role providers developed by Dr. Peter Bromberg (http://www.eggheadcafe.com/articles/20051119.asp). The big problem I am currently struggling with is how to replace the AspNetSql providers with the SQLite providers. I have copied everything into App_Code as instructed and changed the Web.Config file but when trying to use the WebAdmin tool, the only providers available are the AspNet ones. The SQLite providers do not appear. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Deploying SQLite Membership & Role Providers
I have successfully created an ASP.Net web page that uses the Membership & Role providers (http://www.codeproject.com/KB/aspnet/SQLiteProviders.aspx) and System.Data.SQLite (http://sqlite.phxsoftware.com/). It works fine on my development computer. However, I have the following problems that I have failed to overcome: 1. how to connect to the database on the web server. I have to use a hard path in the Visual Studio IDE. Can all that be handled in web.config? If so, I haven't figured out how yet. 2. Some of the fields on the SQL Server 2005 database are type "Unique Identifier" which is an automatically generated GUID. They transferred to the new db as a string. Is that an insurmountable problem for either the current data or new records? 3. Likewise the usernames and passwords were encrypted. My hope is to replace the SQL Server 2005 database with SQLite. If someone has done something similar, I would appreciate some pointers. It would be nice to not lose the information in the current databases. I am trying to do this for a non-profit charity in hopes of cutting the web hosting cost in half. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table Adapter Update Question (Richard W. Kulp)
Roosevelt, Thanks. That worked perfectly. Dick On Wed, 25 Jun 2008 18:17:39 -0400, Roosevelt Anderson <[EMAIL PROTECTED]> wrote: >Try using this library > >http://sqlite.phxsoftware.com/ > >It a complete ADO.NET 2 implementation and it should support the update. > >On Wed, Jun 25, 2008 at 5:14 PM, Richard W. Kulp <[EMAIL PROTECTED]> >wrote: >> I am trying to convert a VB 2005 program from a SQLExpress database to >> SQLite 3. I have been successful up to the following line of code: >> >> Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) >> >> It seems that the DboTableAdapter does not support the Update command. >> What >> is the preferred way to update a dataset created from a SQLite db? I am >> using CoreLab's dotConnect SQLite data provider. Another consideration is >> that my ultimate goal is to move from Visual Studio to MonoDevelop. >> >> Thanks. >> >> Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Table Adapter Update Question
I am trying to convert a VB 2005 program from a SQLExpress database to SQLite 3. I have been successful up to the following line of code: Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users) It seems that the DboTableAdapter does not support the Update command. What is the preferred way to update a dataset created from a SQLite db? I am using CoreLab's dotConnect SQLite data provider. Another consideration is that my ultimate goal is to move from Visual Studio to MonoDevelop. Thanks. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] MonoDevelop Data Provider (Richard W. Kulp)
I found it lurking under Mono.Data.SqliteClient in the Edit References -- Projects tab. For some reason I was unable to find it yesterday. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] MonoDevelop Data Provider
I am trying to make my first MonoDevelop program using SQLite as the database. I have been unable to find a data provider. Does anyone know of a SQLite data provider for MonoDevelop 1.0? If there is one, an example of how to incorporate it into a MonoDevelop program would be appreciated. I am new to both MonoDevelop and SQLite so have very little to go on. Thanks. Dick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users