import-module SQLite (not working)

Dec 10, 2013 at 11:37 PM
Hello Community

I need some assistance please.

I have downloaded SQLite Provider 1.1 and I have extracted the SQLite folder to C:\Program Files\WIndowsPowerShell\Modules

When I run get-module -list SQLite
Directory: C:\Program Files\WindowsPowerShell\Modules
ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Binary     1.0        SQLite                              mount-sqlite
When I run $psversiontable
Name                           Value
----                           -----
PSVersion                      4.0
WSManStackVersion              3.0
SerializationVersion           1.1.0.1
CLRVersion                     4.0.30319.34003
BuildVersion                   6.3.9600.16394
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0}
PSRemotingProtocolVersion      2.2
** However when I run import-module SQLite
Security warning
Run only scripts that you trust. While scripts from the internet can be useful, this script can     potentially h
computer. If you trust this script, use the Unblock-File cmdlet to allow the script to run     without this warni
message. Do you want to run C:\Program Files\WindowsPowerShell\Modules\SQLite\start-    sqlite.psm1?
[D] Do not run  [R] Run once  [S] Suspend  [?] Help (default is "D"): R
ipmo : Could not load file or assembly 'file:///C:\Program
Files\WindowsPowerShell\Modules\SQLite\bin\CodeOwls.PowerShell.Paths.dll' or one of its     dependencies. Operati
supported. (Exception from HRESULT: 0x80131515)
At C:\Program Files\WindowsPowerShell\Modules\SQLite\start-sqlite.psm1:78 char:30
+ ls $PSScriptRoot/bin/*.dll | ipmo;
+                              ~~~~
    + CategoryInfo          : NotSpecified: (:) [Import-Module], FileLoadException
    + FullyQualifiedErrorId :     System.IO.FileLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand

ipmo : Could not load file or assembly 'file:///C:\Program
Files\WindowsPowerShell\Modules\SQLite\bin\x64\System.Data.SQLite.dll' or one of its     dependencies. Operation
supported. (Exception from HRESULT: 0x80131515)
At C:\Program Files\WindowsPowerShell\Modules\SQLite\start-sqlite.psm1:83 char:35
+     ls $PSScriptRoot/bin/x64/*.dll | ipmo;
+                                      ~~~~
    + CategoryInfo          : NotSpecified: (:) [Import-Module], FileLoadException
    + FullyQualifiedErrorId :     System.IO.FileLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand

import-module : Could not load file or assembly 'file:///C:\Program
Files\WindowsPowerShell\Modules\SQLite\bin\CodeOwls.PowerShell.SQLite.Provider.dll' or     one of its dependencie
Operation is not supported. (Exception from HRESULT: 0x80131515)
At line:1 char:1
+ import-module SQLite
+ ~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Import-Module], FileLoadException
    + FullyQualifiedErrorId :     System.IO.FileLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand



Can someone please assist me with this? I am very much looking forward to using SQLite with PowerShell.
Dec 11, 2013 at 3:37 AM
Fixed!

Found another article somewhere that mentioned to unblock the .zip file before extraction.
Marked as answer by ddrake1984 on 12/10/2013 at 8:37 PM