Oh I see. System.Data.SQLite doesn't provide a Snap-in so
Add-PSSnapin wont work. You could use:
[System.Reflection.Assembly]::LoadWithPartialName("System.Data.SQLite")
But from what I see this method is considered 'bad' because this could
lead to versioning issues. Since the System.Data.Common interfaces
are very stable I'd personally feel safe doing this but ymmv.
On Thu, Oct 9, 2008 at 10:15 AM, Helga Lachmann <[EMAIL PROTECTED]> wrote:
> I don't know.
> How should I do this?
> I think that's the point.
>
> As I mentioned I tried manually with Add-PSSnapin, but that doesn't work.
> (... PowerShell-Snap-In "System.Data.SQLite" is not installed ...)
>
>
>
> -------- Original-Nachricht --------
>> Datum: Thu, 9 Oct 2008 10:03:07 -0400
>> Von: "Jeffrey Becker" <[EMAIL PROTECTED]>
>> An: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
>> Betreff: Re: [sqlite] howto setup SQLite with Powershell ?
>
>> IIRC powershell doesnt automatically load every assembly in the GAC.
>> How are you loading the System.Data.SQLite assembly?
>>
>> On Thu, Oct 9, 2008 at 8:51 AM, <[EMAIL PROTECTED]> wrote:
>> > Hello,
>> >
>> > I looked unavailingly around for hours to get SQLite and Powershell
>> working together.
>> >
>> > Is there any little installation/configuration guide for this?
>> >
>> > The problem seems to be how to get SQLite available to PS.
>> >
>> >
>> > I used installutil, which reported "successful".
>> > AddPSSnapin failed with error "...DLL not installed"
>> >
>> > I tried to connect via Database Connection and even with the
>> DBProviderFactory method.
>> > But Powershell always reports an error ("Unable to find the requested
>> .Net Framework Data Provider. It may not be installed.")
>> >
>> > I installed SQLite for ADO.NET 2.0 from sourceforge.
>> > The result seems ok (finished successfully with no errors, SQLite.NET
>> program-folder)
>> > The documentation tells also about using DbProviderFactories.
>> > It says to modify the app.config file. This seems to be a DotNet
>> scenario for VisualStudio but doesn't work for PS.
>> >
>> > In my desperation I copied the SQLite-DLL around in various locations,
>> added manually a line to the machine.config file, but nothing worked.
>> >
>> >
>> > I'm using XPPro, SP3.
>> >
>> >
>> > thanks a lot
>> >
>> > H.L.
>> >
>> > --
>> > GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
>> > Jetzt dabei sein:
>> http://www.shortview.de/[EMAIL PROTECTED]
>> > _______________________________________________
>> > 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
>
> --
> Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen:
> http://www.gmx.net/de/go/multimessenger
> _______________________________________________
> 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
