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
