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
