D 2011-07-04T08:04:51.045
J comment I\sdownloaded\ssqlite-dotnet-x64-1006900.exe\sand,\safter\suninstalling\sthe\sprevious\sversion\sof\sSqlite\sfor\s.NET,\sI\sinstalled\sit\son\sa\sWinX64\sv.7\sSP1\swith\sFramework\s4.1,\swithout\sproblems.\sI\ssuccessfuly\srecompiled\sall\smy\sprograms\sassociated\swith\sthe\sSqlite\sassembly\sin\srelease\smode.\r\nWhen\sI\sexecuted\sthe\sprograms,\sall\sof\sthem\sissues\sthe\snext\serror:\s\sSystem.DllNotFoundException:\sUnable\sto\sload\sDLL\s'SQLite.Interop.DLL':\sThe\sspecified\smodule\scould\snot\sbe\sfound.\s(Exception\sfrom\sHRESULT:0x8007007E)\sat\sSystem.Data-SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[]\sutf8Filename,\sInt32\sflags,\sIntPtr&\sdb)\sat\sSystem.Data.SQLite.SQLite3.Open(String\sstrFilename,\sSQLiteOpenFlagsEnum\sflags,\sInt32\smax\smaxPoolSize,\sBoolean\susePool)\sin\s\s....\n\n<hr\s/><i>shane\sadded\son\s2011-04-15\s17:36:29\sUTC:</i><br\s/>\nYou\sneed\sto\splace\sSQLite.Interop.dll\swhere\sSystem.Data.SQLite.dll\scan\sfind\sit.\s\s\sFor\snow,\swe\sare\sno\slonger\scombining\sthem\sinto\sa\ssingle\sDLL.\s\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-16\s05:24:01\sUTC:</i><br\s/>\nI\sam\shaving\ssimilar\sissues.\sAssembly.LoadWithPartialName("System.Data.SQLite")\sused\sto\swork\sin\s1.0.66,\snow\sit\sfails\sdue\sto\sSQLite.Interop.dll.\sJust\sa\sthought:\sshould\snot\sSQLite.Interop.dll\sbe\sin\sthe\sGAC,\stoo?\sIt\sis\snot.\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-16\s05:32:36\sUTC:</i><br\s/>\nI\shave\smanually\scopied\s"C:\\Program\sFiles\\System.Data.SQLite\\bin\\SQLite.Interop.dll"\sto\sC:\\Windows\\assembly\\GAC_MSIL\\System.Data.SQLite\\1.0.69.0__db937bc2d44ff139\swhere\sSystem.Data.SQLite.dll\sis\sinstalled\sand\sthe\sproblem\shas\sgone.\r\n\r\nThis\sissue\slooks\san\sinstallation\sbug\s(if\sthe\s"Install\sto\sGAC"\soption\sis\schecked).\r\n\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-16\s23:07:08\sUTC:</i><br\s/>\nShane,\sI\sfollow\syour\sindications\sand\sit\sworks\swell\snow.\sThanks.\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-23\s11:00:59\sUTC:</i><br\s/>\nI\sdownloaded\ssqlite-dotnet-x86-1007000.exe\son\swin\s7\s32-bits\sand\safter\sinstallation\sI\sstill\smiss\sSQLite.Interop.dll\sin\sC:\\Windows\\assembly\swhere\sI\sfind\s\sSystem.data.SQLite\sand\sSystem.Data.SQLite.Linq.\r\nThe\sfollowing\sPowershell\sScrip\r\n\r\n[System.Reflection.Assembly]::LoadWithPartialName("System.Data.SQLite")\s\r\n$ConnectionString\s=\s"Data\sSource=C:\\Var\\sqlite_ff4\\places.sqlite"\r\n$conn=new-object\sSystem.Data.SQLite.SQLiteConnection\s\r\n$conn.ConnectionString=$ConnectionString\s\r\n$conn.Open()\s\r\n\r\ngives\s\r\n\r\nGAC\s\s\s\sVersion\s\s\s\s\s\s\s\sLocation\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\r\n---\s\s\s\s-------\s\s\s\s\s\s\s\s--------\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\r\nTrue\s\s\sv2.0.50727\s\s\s\s\sC:\\Windows\\assembly\\GAC_MSIL\\System.Data.SQLite\\1.0.70.0__db937bc2d44ff139\\System.Data.SQLite.dll\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\r\nException\scalling\s"Open"\swith\s"0"\sargument(s):\s"Unable\sto\sload\sDLL\s'SQLite.Interop.DLL':\sThe\sspecified\smodule\scould\snot\sbe\sfound.\s(Exception\sfrom\sHRESULT:\s0x8007007E)"\r\nAt\sline:5\schar:11\r\n+\s$conn.Open\s<<<<\s()\s\r\n\s\s\s\s+\sCategoryInfo\s\s\s\s\s\s\s\s\s\s:\sNotSpecified:\s(:)\s[],\sMethodInvocationException\r\n\s\s\s\s+\sFullyQualifiedErrorId\s:\sDotNetMethodException\r\n\s\r\n\r\nI\sthought\sthis\sproblem\swas\sresolved\shttp://system.data.sqlite.org/index.html/tktview?name=54e52d4c6f\r\n\r\nBTW:\sI\sdidn't\ssucceed\swith\sthe\swork\sarounds\seither.\r\n\r\n\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-25\s12:14:53\sUTC:</i><br\s/>\nWhy\sis\sthis\sticket\sclosed?\sThere\sis\sstill\san\sissue.\sIf\susers\schoose\s"Install\sto\sGAC"\son\sinstallation\sthen\sthey\sexpect\sAssembly.LoadWithPartialName("System.Data.SQLite")\sto\swork\sout\sof\sthe\sbox.\sThis\sis\snot\sthe\scase.\sAt\sleast\sthere\sare\sseveral\sevidences\sthat\sthe\sproblem\sexists\safter\sinstallation.\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-25\s15:48:27\sUTC:</i><br\s/>\nFrom\sAnother\s"Anonymous"\s--\sIt\sdoesn't\smatter\sif\sthe\s"GAC'\sselection\sis\smade\sor\snot\s--\sthe\sproblem\sremains.\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-25\s15:51:29\sUTC:</i><br\s/>\nSetting\sStatus\sto\s"Open".\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-25\s18:25:43\sUTC:</i><br\s/>\nChanged\sresolution\sto\s"Open".\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-25\s19:39:37\sUTC:</i><br\s/>\nThe\sissue\salso\sexists\sin\s1.0.70.0,\r\n\r\nI\sam\susing\s.NET\s3.0\son\sVista\sSP1\sand\shaving\sno\sluck\swith\sthe\sworkaround.\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-27\s00:42:02\sUTC:</i><br\s/>\nI\sinstalled\sSQLite\s"sqlite-dotnet-x86-1007000.exe"\son\smy\sXP\sSP3\slaptop\s(x86)\sand\sgot\sthe\ssame\sissue\sas\sthe\srest..\r\nTried\sthe\swork\sarrounds\swith\sthe\ssame\sresult..\r\n\n\n<hr\s/><i>shane\sadded\son\s2011-04-27\s14:17:54\sUTC:</i><br\s/>\nThe\sinterop\sDLL\scontains\sunmanaged\scode\sand\scan\snot\sbe\sinstalled\sin\sthe\sGAC.\s\s\sSystem.Data.SQLite.dll\smakes\scalls\sto\sthis\sDLL,\sand\sthus\sneeds\sto\sbe\sable\sto\sfind\sit.\s\sSome\spossible\swork\sarounds:\r\n\r\n1)\stry\scopying\sthe\sinterop\sDLL\sto\sthe\ssame\sdirectory\sas\swhere\sthe\sSDS\sDLL\swas\sinstalled\r\n2)\stry\sadding\sthe\sdirectory\scontaining\sthe\sinterop\sDLL\sto\sthe\spath\r\n\r\nIf\sthose\sfail,\splease\stry\sthis\sand\sreport\sthe\sresults:\r\n\r\nRun\sthe\sappropriate\s"setup"\sfrom\sthe\sdownloads\spage\sand\sinstall\sto\sa\stemp\sdirectory\slike\s"C:\\temp\\System.Data.SQLite"\s-\sthis\sis\sso\sit\sis\swriteable.\r\nChoose\sall\sthe\sdefault\soptions\sfor\sinstallation.\s\sRun\sthe\stest\sutility\s-\s"C:\\temp\\System.Data.SQLite\\bin\\test.exe".\s\s\sDoes\sit\swork?\s\sWhat\serrors\sare\sreported?\r\n\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-27\s19:48:20\sUTC:</i><br\s/>\nKribo\s(XP\sSP3\slaptop)\r\n\r\nI\sdownloaded\sthe\ssource\sfiles\s[sqlite-dotnetsrc-1007000.zip]\sand\s\r\nmade\sa\ssolution\sbuid\s(release)\sand\sdiscoverd\sthat\sthere's\s\r\nno\ssign\sof\sany\s"SQLite.Interop.dll"\sfiles.\r\n\r\nI\salso\stried\sto\srefactor\sthe\s[sqlite-dotnetsrc-1007000.exe]\s\r\nto\sdiscover\sif\sthe\sdll\sfile\swas\sincluded,\sbut\sto\sno\ssucces\s\r\n\r\nDit\sthe\sfirst\stest\s:\sinstalled\sthe\s.exe\sin\sthe\sC:\\Temp\s\r\nand\sran\sthe\stest.exe\s....\sno\sfaults\r\n\r\nSo\sI\sdid\sthe\snext\sbest\sthing..\r\nCopied\sthe\s[SQLite.Interop.dll]\sto\smy\sdotNet\sproject\\bin\\debug\\\sdirectory\r\nand\sran\sthe\sF5\sagain...\sAND\sWITH\sSUCCES\s...\scool\r\n\r\nI\salso\stried\sto\sincude\sthe\s[SQLite.Interop.dll]\sas\sa\sreference\swith\smy\s\r\ndotNet\sappi\sbut\sgot\sthe\sfollowing\s\r\n\r\n\r\n---------------------------\r\nMicrosoft\sVisual\sStudio\r\n---------------------------\r\nA\sreference\sto\s'C:\\Temp\\System.Data.SQLite\\bin\\SQLite.Interop.dll'\scould\snot\sbe\sadded.\sPlease\smake\ssure\sthat\sthe\sfile\sis\saccessible,\sand\sthat\sit\sis\sa\svalid\sassembly\sor\sCOM\scomponent.\r\n---------------------------\r\nOK\s\s\s\r\n---------------------------\r\n\r\nRequest\s/\sQuestion\r\nby\smaking\sit\saccesable\swil\sthe\sissue\sbe\ssolved\s?\r\n\r\ngrtz\r\nKribo\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-27\s20:18:17\sUTC:</i><br\s/>\nKribo\r\n\r\nSo\sconclusion\s..\r\nWhen\sone\smakes\sa\sdotNet\sappi\susing\sembedded\sSQLite.\r\nOne\smust\sadd\san\s"existing\sitem"\sto\syour\sproject.\r\nAnd\sthis\sdirectly\suder\sthe\sroot\r\n\s\s\sMySolution\r\n\s\s\s\s\sMyProject\r\n\s\s\s\s\s\s\sSQLite.Interop.DLL\r\n\r\nAnd\sone\smust\sulter\sthe\sproperty\sof\sthe\sitem\s"SQLite.Interop.DLL"\r\n\s\sCopy\sto\sOutput\sDirectory\s->\sCopy\salways\r\n\r\nAnd\s"System.Data.SQLite.dll"\sone\sadds\sas\sa\sreference\sto\sones\sproject..\r\n\r\nAfter\sdoing\sso\syour\sappi\sshould\srun..\r\n\r\nKind\sregards\r\n\r\nKribo\n\n<hr\s/><i>anonymous\sclaiming\sto\sbe\sHelga\sadded\son\s2011-04-28\s13:14:27\sUTC:</i><br\s/>\nHello\sall,\r\nI\snoticed\sthe\ssame\serror\s<b>'System.DllNotFoundException:\sUnable\sto\sload\sDLL\s'SQLite.Interop.DLL''</b>\sreproduced\swith\s1.0.70\sand\s1.0.71\sversions.\sRight\safter\sinstallation\sI\sran\syour\stest\sutility\s<i>bin\\test.exe</i>:\severything’s\sOK\swith\sx64\sWindows,\sbut\son\sx32\sthis\serror\soccurs\simmediately.\r\n\r\nI\sdownloaded\s<b>sqlite-dotnetsrc-1007100.zip</b>\sand\stried\sto\scompile\sa\sbuild\sin\sRelease\smode,\sbut\sit\swas\simpossible\sto\scompile\sthe\sSQLite.Designer\sthere.\r\n\r\nIf\sthe\sSQLite.Designer\sproject\sis\sexcluded\sfrom\sthe\ssolution,\severything\sis\scompiled\ssuccessfully,\sbut\sas\sa\sresult\stwo\sassemblies\sof\sSystem.Data.SQLite.dll\scome\sout.\sYour\stest\sutility\s<i>bin\\test.exe</i>\sworks\sOK\swith\sx32\sWindows\sif\sonly\sone\sof\sSystem.Data.SQLite.dlls\s(the\sbigger\sone)\sis\srenamed\sinto\sSQLite.Interop.dll.\r\n\r\nCould\syou\splease\sfix\sthis\sbug\sand\smake\sa\snew\sbuild\sin\sRelease\smode\s[92cf2525cb]?\sThank\syou!\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-28\s18:39:41\sUTC:</i><br\s/>\nWin\sXP\sSP2\r\nInstalled\slastest\sbuild\sand\sran\stest.exe.\s\sGot\s"Unable\sto\sload\sDLL\s"SQLite.Interop.DLL".\s\sHRESULT\s0x8007007E.\s\sCopies\sthe\sinterop\sassembly\sto\severy\sdirectory\sI\scan\sthink\sof\sand\sstill\sget\sthe\serror.\r\n\r\nAlso,\sI'm\snot\shot\son\sthe\s"add\sthe\sdirectory\sto\syour\spath"\ssolution\sas\snone\sof\smy\sother\s.NET\sapplications\srequire\sbeing\sadded\sto\sthe\spath.\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-28\s21:17:50\sUTC:</i><br\s/>\nWe\swere\shaving\ssome\susers\sget\sthe\s'Unable\sto\sload\sDLL'\serror\sand\ssome\snot.\sThe\sSQLite.Interop.dll\swas\sin\sthe\ssame\sdirectory\sas\sour\sexecutable.\sThat\swas\snot\sour\sproblem.\sThe\sproblem\swas\ssome\sare\smissing\sa\sdependency:\sMSVCR100.dll.\r\n\r\nUsing\sDependency\sWalker\sfrom\shttp://dependencywalker.com/\sto\slook\sat\sSQLite.Interop.dll\s(x86\sand\sx64)\sshows\sthat\sit\sdepends\son\sMSVCR100.dll.\r\n\r\nThe\sold\s1.0.66.0\sversion\sof\sSystem.Data.SQLite.dll\sdoes\snot\shave\sthis\sdependency.\sWith\sthe\scurrent\sbuild,\swe\swould\shave\sto\sredistribute\sthat\sMSVCR100.dll\salso\sor\srun\san\sinstaller\sfrom\sMicrosoft.\r\n\r\nSolution:\s\r\nFrom:\shttp://stackoverflow.com/questions/3768522/missing-msvcr100-dll\r\n\r\nUse\sstatic\slinking.\r\nIn\sthe\sSQLite.Interop\sVisual\sStudio\sproject.\sGo\sto\sthis\sProperties\ssetting:\sProject\s->\sProperties\s->\sConfiguration\sProperties\s->\sC/C++\s->\sCode\sGeneration\s->\sRuntime\sLibrary\s\sand\schange\sthe\svalue\sto\sMulti-threaded\s(/MT).\s(The\scurrent\ssource\scode\s(1.0.71.0)\shas\sMulti-threaded\sDLL\s(/MD)\swhich\scauses\sthe\sdll\sto\srely\son\sMSVCR100.dll\sand\sthe\sDLLImport\s(and\sLoadLibary())\sto\sfail\swhen\susers\sdo\snot\shave\sit).\r\n\r\nI\sbelieve\sstatic\slinking\sshould\sbe\schanged\sso\sit\sis\sthe\sdefault\sfor\sSQLite.Interop.dll.\sThank\syou\sfor\syour\swork\son\sthis\sproject.\n\n<hr\s/><i>anonymous\sadded\son\s2011-04-29\s14:52:39\sUTC:</i><br\s/>\nRan\svcredist_x86.\sTest.exe\sstill\snot\sworking.\s\s\r\nSearched\sc:\\windows\\system32\sand\sfound\smsvcr100_clr0400.dll.\r\nCopied\sthat\sto\ssame\sdirectory\sas\sSqlite.Interop.dll.\sTest.exe\sstill\snot\sworking.\r\nRenamed\smsvcr100_clr0400.dll\sto\smsvcr100.dll.\s\sNOW\sIT\sWORKS!\r\n\r\nPlease\sstatic\slink.\s\sThis\sis\stoo\spainful.\n\n<hr\s/><i>anonymous\sadded\son\s2011-05-04\s11:50:38\sUTC:</i><br\s/>\nI\shave\sdownloaded\sand\sinstalled\sboth\sx86\sand\sx64\sversions\sof\s1.0.72.0\sand\shave\sthe\ssame\serror\son\sall.\s\r\n\r\nThis\sis\sstill\sa\sproblem\seven\sif\sall\sof\sthe\sdll's\sare\sin\sthe\sproject\sfolder\s(including\sthe\smsvcr100.dll)\r\n\r\nI\sam\srunning\sXP\sx64\susing\sVS2008,\sthe\sapplication\sis\sset\sto\sbuild\sfor\sx86\sonly\sand\sthe\sdll's\sI\shave\scopied\sare\sthe\sx86\sversion\s(although\sthe\sx64\sversion\sdoes\sthe\ssame)\n\n<hr\s/><i>anonymous\sclaiming\sto\sbe\sBastien\sadded\son\s2011-05-06\s08:44:15\sUTC:</i><br\s/>\nNot\ssure\sthat\sis\sthis\sis\srelated\sto\sthe\soriginal\sbug,\sbut\sI\sstumbled\supon\sthe\ssame\sproblem\sthat\sthe\sanonymous\suser\sat\s2011-05-04\s11:50:38\sUTC\sposted.\s\r\n\r\nThat\sis\sto\ssay\san\sx86\sbuilt\sapp\srunning\son\sa\sx64\smachine\scannot\suse\sthe\sx86\srelease\sof\sthe\s1.0.72.0\sbinary\srelease.\sBy\s"x86\sbuilt\sapp"\sI\smean\sthe\s.NET\sapplication\swas\saimed\sat\san\sx86\sarchitecture\sin\sthe\sbuild\soptions\sof\sthe\sVisual\sStudio\sproject.\r\n\r\nIt\sseems\sto\sme\s(although\sI\sactually\shave\sno\sclue\sabout\sthe\sinvolved\sprocess)\sthat\sthe\sinterop\sDLL\sdoes\snot\sfollow\sthe\srules\sof\srunning\sin\s32\sbits\swhen\sthe\sprocess\swhich\suses\sit\sspecifically\sruns\sinto\sthis\smode\s(which\sis\sdenoted\sin\sthe\sWindows\stask\smanager\sby\sthe\s"*32"\sappended\sto\sthe\sprocess\sname).\sReplacing\sthe\sx86\sinterop\sDLL\sby\sthe\sx64\sversion\sdoes\snot\swork\seither\sin\sthis\ssituation.\r\n\n\n<hr\s/><i>anonymous\sclaiming\sto\sbe\sMatt\sadded\son\s2011-05-06\s18:32:45\sUTC:</i><br\s/>\nI\stoo\swas\sgetting\sthis\smessage\s"Unable\sto\sload\sDLL\s"SQLite.Interop.DLL".\sHRESULT\s0x8007007E"\sI\shad\soriginally\sinstalled\susing\sthe\sGAC\soption.\sI\shad\sto\sun-install\sthen\sreboot.\sI\sthen\sre-installed\swithout\susing\sthe\sGAC\soption.\sI\srebooted\safter\sthe\sre-install\sand\sthe\sissue\swent\saway.\n\n<hr\s/><i>anonymous\sadded\son\s2011-06-10\s10:14:20\sUTC:</i><br\s/>\nPlease\sfix\sthe\sstatic\slinking\smsvcr100.dll\sproblem.\sI\sspent\shours\strying\sto\sfigure\sout\swhy\sa\sdll\swhich\sWAS\sin\sthe\sdirectory\sreported\sit\scould\snot\sbe\sfound!\s\r\n\r\nThe\swhole\spoint\sof\susing\sSQLite\sis\sthe\slack\sof\sdependencies...\n\n<hr\s/><i>anonymous\sclaiming\sto\sbe\sanonymous\sSFA\sadded\son\s2011-06-16\s07:48:05\sUTC:</i><br\s/>\nYeah,\sthis\sproblem\shas\sbeen\sdriving\sme\snuts\son\sand\soff\sfor\sdays.\s\sThe\sdocumentation\sthat\scomes\swith\sthe:\r\nsqlite-dotnet-x86-1007300.exe\sand\r\nsqlite-dotnet-x64-1007300.exe\s\r\ninstallers\sstates\sthe\sfollowing\sabout\sdistribution:\r\n\r\n--\sQuote\s--\r\nDistributing\sthe\sBinaries\s(Desktop)\r\nSystem.Data.SQLite.DLL\sis\sa\smixed\sassembly\ssigned\swith\sa\sstrong\sname\sin\scase\syou\swant\sto\sadd\sit\sto\sthe\sGlobal\sAssembly\sCache\s(GAC).\sThis\sis\sthe\sonly\sDLL\srequired\sto\sbe\sredistributed\swith\syour\sSQLite.NET\sapplication(s).\s\sIt\scomes\sin\s3\sflavors:\sWin32,\sItanium\sand\sx64\s(AMD64).\r\n\r\nDistributing\sthe\sBinaries\s(Compact\sFramework)\r\nSystem.Data.SQLite.DLL\sand\sSQLite.Interop.XXX.DLL\smust\sbe\sdeployed\son\sthe\sCompact\sFramework.\s\sThe\sXXX\sis\sthe\sbuild\snumber\sof\sthe\sSystem.Data.SQLite\slibrary\s(e.g.\s"059").\s\sSQLite.Interop.XXX\sis\sa\sfully\snative\sassembly\scompiled\sfor\sthe\sARM\sprocessor,\sand\sSystem.Data.SQLite\sis\sthe\sfully-managed\sCompact\sFramework\sassembly.\r\n--\sEnd\sQuote\s--\r\n\r\nAt\sa\sminimum,\sthis\sshould\sbe\supdated\sto\sstate\sthe\sactual\sdependancies\sfor\sdistribution.\s\sNote\sthat\sfor\sdesktop\sit\ssays\sthat\sthe\sSystem.Data.SQLite.DLL\sis\sall\sthat's\srequired.\sIf\snot\sstatically\slinked,\smsvcr100.dll\sand\sany\sothers\sshould\salso\sbe\sincluded.\s\sThis\swould\shave\ssaved\sme\sand\sall\son\sthis\spost\sgrief.\n\n<hr\s/><i>anonymous\sadded\son\s2011-06-18\s07:16:33\sUTC:</i><br\s/>\nSo\sfor\smy\sdevelopment\senvironment\sI\sinclude\sSQLite.Interop.DLL\sin\smy\sbin\sdirectory\salong\swith\sSystem.Data.SQLite.dll,\sand\sthat\sworks\sfine.\r\n\r\nProblem\shere\sis\sthat\swhen\sI\sdeployed\sall\sthat\son\san\sXP\smachine,\sit\sfails\smiserably;\seven\sthough\sboth\sdll's\sare\spresent.\sIn\sany\scase,\sI'm\sback\sto\s1.0.66.0.\n\n<hr\s/><i>anonymous\sadded\son\s2011-06-27\s10:34:34\sUTC:</i><br\s/>\nI\shave\sthe\ssame\sproblem\swith\s1.0.73,\sI\salso\shave\sto\sback\sto\s1.0.66\r\n\r\n------------------------------------------------------------------\r\nSo\sfor\smy\sdevelopment\senvironment\sI\sinclude\sSQLite.Interop.DLL\sin\smy\sbin\sdirectory\salong\swith\sSystem.Data.SQLite.dll,\sand\sthat\sworks\sfine.\r\n\s\r\nProblem\shere\sis\sthat\swhen\sI\sdeployed\sall\sthat\son\san\sXP\smachine,\sit\sfails\smiserably;\seven\sthough\sboth\sdll's\sare\spresent.\sIn\sany\scase,\sI'm\sback\sto\s1.0.66.0.\r\n\n\n<hr\s/><i>mistachkin\sadded\son\s2011-07-02\s08:52:45\sUTC:</i><br\s/>\nThis\sissue\swill\sbe\s'fixed'\sin\sthe\snext\srelease\sby\shaving\sbundled\sbinary\sand\ssetup\spackages\sthat\scontain\sthe\smixed-mode\sassembly\s(i.e.\sthe\sone\sthat\scan\sbe\sGAC'd).\r\n\r\nHowever,\sthe\smixed-mode\sassembly\s(and\sthe\snative\sinterop\slibrary\sfor\snon-bundled\spackages)\swill\sstill\srely\son\swhichever\sversion\sof\sthe\sVC++\sruntime\sit\swas\scompiled\sagainst.\r\n\r\nStatic\slinking\sis\sa\svery\sbad\sidea.\s\sIt\smakes\sit\svery\shard\sto\smaintain,\supdate,\sand\ssecure\sthe\sVC++\sruntime\sitself.
J status Closed
K 54e52d4c6f92083749d5796672d09d7dce56643c
U mistachkin
Z 3c79177842525ef42c2b6d1ae4ae08bc