As for the code being 'bad' I saw a lot of blog posts that said it
caused problems but very few that had reasonable replacements. There
was one post that gave a hundred lines or so of code to do the same
thing.
On Thu, Oct 9, 2008 at 11:25 AM, <[EMAIL PROTECTED]> wrote:
> if that is "bad" how can it be done correct/better?
>
> [System.Reflection.Assembly]::LoadWithPartialName("System.Data.SQLite")
> itself produces no error, but also
> [System.Reflection.Assembly]::LoadWithPartialName("thisDoesntMatter")
> produces no error,
> but the following
> $conn = New-Object System.Data.SQLite.SQLiteConnection($Conn)
> gives the error
> Type [System.Data.SQLite.SQLiteConnection] cannot be found.
> Make sure assembly containing this type is loaded.
>
> [messages retranslated from german]
>
>
> -------- Original-Nachricht --------
>> Datum: Thu, 9 Oct 2008 11:04:36 -0400
>> Von: "Jeffrey Becker" <[EMAIL PROTECTED]>
>> An: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
>> Betreff: Re: [sqlite] howto setup SQLite with Powershell ?
>
>> 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
>
> --
> 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
