Hi, I was able to modify the ASP code to ASP.NET and I can now access the SQLite databases. One key change was to add the following two lines at the beginning of the code:
<%@ Assembly Name="System.Data.SQLite, Version=1.0.81.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" %> <%@ Import Namespace="System.Data.SQLite" %> The complete ASP.NET page is attached in case this can benefit someone else. Thank you Joe for the help. Roger. -----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