> What I'm wondering is, am I the only one who wants to use SQLite together 
> with Powershell?
You're the first person I've heard of trying to do it.  Really I think
your SQLite.Net provider is incorrectly installed.

can you please provide the output of the following command:
gacutil /l System.Data.SQLite

Mine produces the following output:

Microsoft (R) .NET Global Assembly Cache Utility.  Version 2.0.50727.42
Copyright (c) Microsoft Corporation.  All rights reserved.

The Global Assembly Cache contains the following assemblies:
  System.Data.SQLite, Version=1.0.60.0, Culture=neutral,
PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86
  System.Data.SQLite, Version=1.0.53.0, Culture=neutral,
PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=MSIL


If you dont get any lines returned that means you don't have the
ADO.Net provider installed and you'll need to install it.  Download it
from : http://sqlite.phxsoftware.com.

On Fri, Oct 10, 2008 at 7:56 AM, Brad Stiles <[EMAIL PROTECTED]> wrote:
>>> access ... dll from PowerShell ... PowerShell docs
>>
>> the procedure given there is to register the dll with installutil.
>
> The use of the word "register" implies to me that they might be
> assuming a COM dll or .NET com visible assembly.  I don't believe the
> SQLITE3.DLL qualifies as either. :)  As well, as far as I know,
> InstallUtil is only capable of installing assemblies that have been
> designed to be installed that way.  It's not effective for original
> style DLLs.
>
> You might try revisiting the use of one of the .NET providers by
> installing it in the GAC, or perhaps even using REGASM.  For those,
> though, I will repeat the need for asking on the forums dedicated to
> those products.  If you want a robust, well supported one, Robert
> Simpson's ADO.NET provider, hosted at http://sqlite.phxsoftware.com,
> is excellent.  I've used it in a number of programs, and it works
> quite well.
>
> Since PowerShell is highly .NET aware, using a provider designed for
> that platform seems more likely to result in success than using a
> plain dll.  Installed into the GAC, I suspect that provider would work
> quite well under PowerShell.
>
>> What I'm wondering is, am I the only one who wants to use SQLite together 
>> with Powershell?
>
> Starting to look that way, isn't it?
>
> Brad
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to