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