SQLite Interop Error

[cemremengu]

I am doing an MVC6 project with .NET Framework 4.6. The ORM is NHibernate and I am trying to setup SQLite as the test database. I have installed System.Data.SQLite from nuget however I am getting the error

{"Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"}

Tried also with DNX451 and I am getting the same error. Some sources say I need to set the copy local property of the sqlite reference to true but there is no way to set it in this new project layout.

[SergeySagan]

I am also getting this error trying to run Hangfire in my MVC 6 DNX 4.6 app.

[Eilon]

@divega @rowanmiller

[divega]

System.Data.SQLite is not our provider. I am not sure but this could be a known DNX issue. Cc @moozzyk and @anurse in case it rings a bell.

In the meanwhile @cemremengu what OS are you getting the error on?

[divega]

Just noticed @cemremengu posted this originally a long time ago. @serjster could you provide more details of what are you doing and the error you are getting?

[SergeySagan]

I am trying to use Hangfire in my app with SQLite and it gave me this error in an MVC 6 app with DNX 4.6 chosen (Hangfire is not available yet for 5.0) I did end up getting past this issue by manually copying the SQLite Interop dll from the build folder down to the bin folder with the SQLite Core dll. Not sure what needs to be fixed or configured so that this manual copying would not be required.

[cemremengu]

Hello @divega I am using Windows 7. I didnt try recently but seems like the issue is on going. I couldnt find any solution at that time so I switched to sql server express which works fine.

[aspnet-hello]

This issue is being closed because it has not been updated in 3 months.

We apologize if this causes any inconvenience. We ask that if you are still encountering this issue, please log a new issue with updated information and we will investigate.

[davidalpert]

This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred: spinthemoose@gmail.com Domain spinthemoose.com has exceeded the max emails per hour (217/200 (108%)) allowed. Message will be reattempted later

…

------- This is a copy of the message, including all the headers. ------ Received: from o4.sgmail.github.com ([192.254.112.99]:2771) by cp1164.blacksun.ca with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89_1) (envelope-from <bounces+848413-6f87-david=spinthemoose.com@sgmail.github.com>) id 1eVkH3-0001Ia-5x for david@spinthemoose.com; Sun, 31 Dec 2017 14:32:01 -0600 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=github.com; h=from:reply-to:to:cc:in-reply-to:references:subject:mime-version:content-type:content-transfer-encoding:list-id:list-archive:list-post:list-unsubscribe; s=s20150108; bh=4FXvZLN18NtnkB3W95NkBFuFvgA=; b=dvSf3/tClErbBkIb iU/TsJ1GWOgBc7OL275ltAF664iNDgKfw82NXUK7devdjBZ8LHFtNeQuuQzIjeIU Fg67PkP4wV+XEvjPNQcPWIsEYL86CelhhtObAbpb4B6DYJdCzHwzyca6pUHsThfJ PeNTax3z7akw5rx69ooh4ecSzus= Received: by filter0256p1las1.sendgrid.net with SMTP id filter0256p1las1-29556-5A49492B-2C 2017-12-31 20:31:40.05522918 +0000 UTC Received: from github-smtp2b-ext-cp1-prd.iad.github.net (github-smtp2b-ext-cp1-prd.iad.github.net [192.30.253.17]) by ismtpd0002p1iad1.sendgrid.net (SG) with ESMTP id VYMhk_8tQamr2EzDf95Q1w for <david@spinthemoose.com>; Sun, 31 Dec 2017 20:31:39.938 +0000 (UTC) Date: Sun, 31 Dec 2017 20:31:40 +0000 (UTC) From: "ASP.NET Hello Bot" <notifications@github.com> Reply-To: aspnet/Home <reply@reply.github.com> To: aspnet/Home <Home@noreply.github.com> Cc: Subscribed <subscribed@noreply.github.com> Message-ID: <aspnet/Home/issue/847/issue_event/1405408552@github.com> In-Reply-To: <aspnet/Home/issues/847@github.com> References: <aspnet/Home/issues/847@github.com> Subject: Re: [aspnet/Home] SQLite Interop Error (#847) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_5a49492bd3140_53323fa16355ef30111920"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: aspnet-hello X-GitHub-Recipient: davidalpert X-GitHub-Reason: subscribed List-ID: aspnet/Home <Home.aspnet.github.com> List-Archive: https://github.com/aspnet/Home List-Post: <mailto:reply@reply.github.com> List-Unsubscribe: <mailto:unsub+0000a944928cc2e9ac5a48707aa8ace40a37d8220ee1712992cf0000000116610b2b92a169ce060ec6c0@reply.github.com>, <https://github.com/notifications/unsubscribe/AACpRHZGSzlmPwHWAfuzJfp7S1Ke8dPdks5tF-8rgaJpZM4FtfEy> X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: david@spinthemoose.com X-SG-EID: rlj3t9ahcX0BZUzAOlajQ3VmBXo43xFJc4M1ImIDJhHxLR1gYQXuKlWPEgw/XvNIvvt3OQ4FTkV2Zr Dgy5TvyZTfyXUayFpEsU+6jqB+KEeO/o+kwLK42ijc8o1IyDcIOW5JUenuk2wpnojjr8sdjBRx74Mv tQGE3oOrt1VAgsga99sP5OnCoZAhmwTZYqS/MuhLSQCpiTgRi8BDWjwp1sSXoH2VTJ3PjE7BiD0t+X s=

----==_mimepart_5a49492bd3140_53323fa16355ef30111920 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Closed #847.

-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: #847 (comment) ----==_mimepart_5a49492bd3140_53323fa16355ef30111920 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit <p>Closed <a href="#847" class="issue-link js-issue-link" data-error-text="Failed to load issue title" data-id="101631680" data-permission-text="Issue title is private" data-url="#847> <p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="#847 (comment) it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AACpRIpsZNZUXe5JZjJRtekw0yaiR_p_ks5tF-8rgaJpZM4FtfEy">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AACpRPuqF1VH9kKvbg-hE64P769SFwe8ks5tF-8rgaJpZM4FtfEy.gif" width="1" /></p> <div itemscope itemtype="http://schema.org/EmailMessage"> <div itemprop="action" itemscope itemtype="http://schema.org/ViewAction"> <link itemprop="url" href="#847 (comment)> <meta itemprop="name" content="View Issue"></meta> </div> <meta itemprop="description" content="View this Issue on GitHub"></meta> </div> <script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/aspnet/Home","title":"aspnet/Home","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/aspnet/Home"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"Closed #847."}],"action":{"name":"View Issue","url":"#847 (comment)> ----==_mimepart_5a49492bd3140_53323fa16355ef30111920--

[davidalpert]

This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred: spinthemoose@gmail.com Domain spinthemoose.com has exceeded the max emails per hour (216/200 (108%)) allowed. Message will be reattempted later

…

------- This is a copy of the message, including all the headers. ------ Received: from o5.sgmail.github.com ([192.254.113.10]:15370) by cp1164.blacksun.ca with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89_1) (envelope-from <bounces+848413-6f87-david=spinthemoose.com@sgmail.github.com>) id 1eVkH3-0001IZ-25 for david@spinthemoose.com; Sun, 31 Dec 2017 14:32:01 -0600 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=github.com; h=from:reply-to:to:cc:in-reply-to:references:subject:mime-version:content-type:content-transfer-encoding:list-id:list-archive:list-post:list-unsubscribe; s=s20150108; bh=AWjgxNKLDX++B8SA3gGWpZ7F5Hg=; b=qNqpBKDQ8iKF95le z+UknemCxAF5tA8Cl1zKGUttxwB5T+AUydN+E3109yLf9fOFISNIkHThUhy58TmI kUfO151KZx0vODYRSJuqVaUzp+ak/zlLJLNJCZhWm7WM/e8zckhgWI3wiwtGmsPC heGPb5o+3sIrVCKkQ6Z72tjBn18= Received: by filter0183p1las1.sendgrid.net with SMTP id filter0183p1las1-15228-5A49492B-21 2017-12-31 20:31:39.77541304 +0000 UTC Received: from github-smtp2a-ext-cp1-prd.iad.github.net (github-smtp2a-ext-cp1-prd.iad.github.net [192.30.253.16]) by ismtpd0008p1iad1.sendgrid.net (SG) with ESMTP id _7P1ntp4SCuXk2hQ0vu5bw for <david@spinthemoose.com>; Sun, 31 Dec 2017 20:31:39.777 +0000 (UTC) Date: Sun, 31 Dec 2017 20:31:39 +0000 (UTC) From: "ASP.NET Hello Bot" <notifications@github.com> Reply-To: aspnet/Home <reply@reply.github.com> To: aspnet/Home <Home@noreply.github.com> Cc: Subscribed <subscribed@noreply.github.com> Message-ID: <aspnet/Home/issues/847/354622565@github.com> In-Reply-To: <aspnet/Home/issues/847@github.com> References: <aspnet/Home/issues/847@github.com> Subject: Re: [aspnet/Home] SQLite Interop Error (#847) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_5a49492ba0484_162393fa9fc52cf34128493a"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: aspnet-hello X-GitHub-Recipient: davidalpert X-GitHub-Reason: subscribed List-ID: aspnet/Home <Home.aspnet.github.com> List-Archive: https://github.com/aspnet/Home List-Post: <mailto:reply@reply.github.com> List-Unsubscribe: <mailto:unsub+0000a944928cc2e9ac5a48707aa8ace40a37d8220ee1712992cf0000000116610b2b92a169ce060ec6c0@reply.github.com>, <https://github.com/notifications/unsubscribe/AACpRHZGSzlmPwHWAfuzJfp7S1Ke8dPdks5tF-8rgaJpZM4FtfEy> X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: david@spinthemoose.com X-SG-EID: rlj3t9ahcX0BZUzAOlajQ3VmBXo43xFJc4M1ImIDJhEXoSjQrQkC8vAKyS52NiwRxkWbtSI2ZTiKjf tvcx3ZqMvOUfUjlC9o6ZLFjYfz8FOlAIVeJfynbYhOV6CSsspiJ6ZxWEoC5dn6zPm5xNXz+PdEnkMD gImcEglf8oVXcCE6qfV5/3YrnbcXpMTtnOkZ6USS10BDQoQGF8kJq2Exupu9uJBiIac38nnGyRCAtM I=

----==_mimepart_5a49492ba0484_162393fa9fc52cf34128493a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit This issue is being closed because it has not been updated in 3 months. We apologize if this causes any inconvenience. We ask that if you are still encountering this issue, please log a new issue with updated information and we will investigate.

-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: #847 (comment) ----==_mimepart_5a49492ba0484_162393fa9fc52cf34128493a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <p>This issue is being closed because it has not been updated in 3 months.<= /p> <p>We apologize if this causes any inconvenience. We ask that if you are st= ill encountering this issue, please log a new issue with updated informatio= n and we will investigate.</p> <p style=3D"font-size:small;-webkit-text-size-adjust:none;color:#666;">&mda= sh;<br />You are receiving this because you are subscribed to this thread.<= br />Reply to this email directly, <a href=3D"https://github.com/aspnet/Hom= e/issues/847#issuecomment-354622565">view it on GitHub</a>, or <a href=3D"h= ttps://github.com/notifications/unsubscribe-auth/AACpRIpsZNZUXe5JZjJRtekw0y= aiR_p_ks5tF-8rgaJpZM4FtfEy">mute the thread</a>.<img alt=3D"" height=3D"1" = src=3D"https://github.com/notifications/beacon/AACpRPuqF1VH9kKvbg-hE64P769S= Fwe8ks5tF-8rgaJpZM4FtfEy.gif" width=3D"1" /></p> <div itemscope itemtype=3D"http://schema.org/EmailMessage"> <div itemprop=3D"action" itemscope itemtype=3D"http://schema.org/ViewAction= "> <link itemprop=3D"url" href=3D"#847 issuecomment-354622565"></link> <meta itemprop=3D"name" content=3D"View Issue"></meta> </div> <meta itemprop=3D"description" content=3D"View this Issue on GitHub"></meta> </div> <script type=3D"application/json" data-scope=3D"inboxmarkup">{"api_version"= :"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"Gi= tHub"},"entity":{"external_key":"github/aspnet/Home","title":"aspnet/Home",= "subtitle":"GitHub repository","main_image_url":"https://cloud.githubuserco= ntent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png",= "avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842= 166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in Git= Hub","url":"https://github.com/aspnet/Home"}},"updates":{"snippets":[{"icon= ":"PERSON","message":"@aspnet-hello in #847: This issue is being closed bec= ause it has not been updated in 3 months.\r\n\r\nWe apologize if this cause= s any inconvenience. We ask that if you are still encountering this issue, = please log a new issue with updated information and we will investigate.\r\= n"}],"action":{"name":"View Issue","url":"https://github.com/aspnet/Home/is= sues/847#issuecomment-354622565"}}}</script>=

----==_mimepart_5a49492ba0484_162393fa9fc52cf34128493a--