Win7ÏÂIIS·ÃÎÊSqliteÊý¾Ý¿â±¨´í
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔظñʽ²»ÕýÈ·µÄ³ÌÐò¡£
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆڼ䣬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.BadImageFormatException: δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔظñʽ²»ÕýÈ·µÄ³ÌÐò¡£
¶ÑÕ»¸ú×Ù:
[BadImageFormatException: δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔظñʽ²»ÕýÈ·µÄ³ÌÐò¡£]
System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +416
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +166
System.Reflection.Assembly.Load(String assemblyString) +35
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +190
[ConfigurationErrorsException: 뫀
Ïà¹ØÎÊ´ð£º
ÔÚvs2005ÖÐÒýÓÃÁËusing System.Data.SQLite;
¶¨ÒåÁËÒ»¸öÁ¬Êý¾Ý¿âÁ¬½Ó±äÁ¿public SQLiteConnection dBConn;
¾Í±¨ÏÂÃæÕâ¸ö´íÎóÁË.
The type 'System.Data.Common.DbConnection' is defined in an ass ......
sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý£º
ÆäÖÐÊý¾Ý±íÖÐûÓÐרÃűêʶÌõÊýµÄË÷ÒýÖµ£¬ÎÒÃǸù¾ÝÆäËûһЩ×ֶβéÕÒµ½Á˸ÃÊý¾Ý£¬ÏÖÔÚÐèÒª·µ»Ø¸ÃÊý¾ÝËùÔÚµÄÐÐÊý¡£
ÆäÖÐsqlite manager ÖÐÓÐÒ»¸örowid£¬µ«ÊÇÕâ¸ö²¢ÎÞ·¨· ......
×î¼òµ¥µÄÎÊÌâ¡£Ò²ÓеãÓôÃÆ¡£
ÎÒÏë´´½¨Ò»¸öÊý¾Ý¿â
ÎÒÏÖÔÚÖ»ÓÐÒ»¸ösqlite3.exeÎļþ¡£
ÎÒʹÓõķ½·¨ÊÇË«»÷Õâ¸öÎļþ
ʹÓõÄÃüÁîΪ£º
sqlite3 f:\a.db »Ø³µ
¿ÉÊǽá¹ûÈ´ÏÔʾΪ
...>
sqli ......
ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃ棬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆð ......
SQL code:
SELECT a1.FileID AS FileID, SUM( a1.Count + a2.Count + a3.Count + a4.Count ) AS Count
from gmpTableWordList AS a1
INNER JOIN gmpTableWordList AS a2
INNER JOIN gmpTableWordList AS a3
IN ......