Databases
StackOverflow2013
Postsdbo
POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
    primarykey
    data
    text
    <p>I want to run the following code:</p> <pre><code>$dll = [System.Reflection.Assembly]::LoadWithPartialName("System.Data.SQLite") # [System.Reflection.Assembly]::LoadFrom("C:\Program Files\System.Data.SQLite\bin\System.Data.SQLite.dll") $ConnectionString = "Data Source=C:\Var\sqlite_ff4\places.sqlite" $conn = New-Object System.Data.SQLite.SQLiteConnection $conn.ConnectionString = $ConnectionString $conn.Open() $sql = "SELECT * from moz_bookmarks" $cmd = New-Object System.Data.SQLite.SQLiteCommand($sql, $conn) # $cmd.CommandTimeout = $timeout $ds = New-Object system.Data.DataSet $da = New-Object System.Data.SQLite.SQLiteDataAdapter($cmd) $da.fill($ds) $conn.close() $ds.tables[0] </code></pre> <p>At the line</p> <pre><code>$conn.Open() </code></pre> <p>I get the error</p> <pre><code>Exception calling "Open" with "0" argument(s): "File opened that is not a database file file is encrypted or is not a database" At line:5 char:11 + $conn.Open &lt;&lt;&lt;&lt; () + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : DotNetMethodException </code></pre> <p>The file <code>places.sqlite</code> is from Firefox 4.0. I'm using <a href="http://sourceforge.net/projects/sqlite-dotnet2/files/" rel="nofollow noreferrer">http://sourceforge.net/projects/sqlite-dotnet2/files/</a>.</p> <p><strong>EDIT:</strong></p> <p>The above works for the Firefox 3.0 file <code>places.sqlite</code>. Something seems to be different with Firefox 4.0.</p> <p>It doesn't seem to be a password problem, but a version problem. Thanks to <a href="https://stackoverflow.com/questions/4706537/firefox-locks-places-sqlite/4804466#4804466">this Stack&nbsp;Overflow post</a> I found, that I need SQLite 3.7.</p> <p>I hope I find some current ADO provider.</p> <p>sqlite-dotnet-x86-1006900.exe from <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki" rel="nofollow noreferrer">here</a> doesn't work</p> <p>Exception calling "Open" with "0" argument(s): "Unable to load DLL 'SQLite.Inte rop.DLL': The specified module could not be found. (Exception from HRESULT: 0x8 007007E)"</p> <p>It is possibly a debug build. Are there any prebuild version without an SQLite.Interop.DLL?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USbernd_k
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
      1. USRoman Kuzmin
      1. VTFavorite
    2. VO
      singulars
      1. POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you open this database by any other SQLite tool, e.g. sqlite3.exe command line utility (see the official site downloads)?
      singulars
      1. POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
      1. USRoman Kuzmin
    2. COI can open it with the SQLite Manager Firefox Addon
      singulars
      1. POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
      1. USbernd_k
    3. COWith sqlite3.exe places.sqlite I get :Error: file is encrypted or is not a database
      singulars
      1. POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
      1. USbernd_k
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload