http://www.loveyuki.com/Comment/Index.aspxArticle/Recomm_SQLite_User_In_ASP_NET.aspxzh-CNloveyuki@gmail.comSun, 21 Oct 2007 16:07:39 GMTCopyright 2007. All rights reserved.L-BLOG.NET, The Matrix Reloaded.http://www.loveyuki.com/Images/banner.gifhttp://www.loveyuki.com/http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_83LoveyukiMon, 26 Nov 2007 10:21:21 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_83http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_86oldcpuMon, 26 Nov 2007 14:47:48 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_86:-)]]>http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_87oldcpuMon, 26 Nov 2007 14:48:40 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_87 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The connection was not closed. The connection's current state is open.

Source Error:


Stack Trace:


Version Information:Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832]]>http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_89ExceptionMon, 26 Nov 2007 08:27:35 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_89http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_201汤尼尔Tue, 04 Dec 2007 04:11:15 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_201感觉很不错~类型兼容性甚至比MySQL还高级…非常喜欢…]]>http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_809汤仁Sat, 23 Feb 2008 00:59:06 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_809<%
set conn = server.createobject("adodb.connection")
connstr = "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("db.db3")
conn.Open connstr
%>
我这么写提示：无法识别的数据库格式。
<%
conn = server.createobject("adodb.connection")
connstr = New SQLiteConnection("Data Source=c:\accounts\user.db;Version=3")
conn.Open connstr
%>
这么写出错！
，拜托！
数据库连接文件应该怎么写，望不吝赐教！]]>http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_811LoveyukiSat, 23 Feb 2008 09:37:30 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_811<%
conn = server.createobject("adodb.connection")
connstr = "Provider=OleSQLite.SQLiteSource.1; " _
& "Data Source=C:\public\customer.dat"
conn.Open connstr
%>]]>http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_838txinkWed, 27 Feb 2008 15:47:33 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_838http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_840txinkWed, 27 Feb 2008 17:40:33 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_840http://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAnchor_968冬雷软件Tue, 18 Mar 2008 10:00:50 GMThttp://www.loveyuki.com/Article/Recomm_SQLite_User_In_ASP_NET.aspx#CommentAuchor_968