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
