If I run it I get... nothing So I would like to know which steps you have done before.
btw: if I rerun InstallUtil I now get a message: No public installers with the RunInstallerAttribute.Yes attribute could be found in the ...\System.Data.SQLite.dll assembly. -------- Original-Nachricht -------- > Datum: Thu, 9 Oct 2008 12:38:14 -0400 > Von: "Jeffrey Becker" <[EMAIL PROTECTED]> > An: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > When I run the LoadWithPartialName I get: > > GAC Version Location > --- ------- -------- > True v2.0.50727 > C:\WINDOWS\assembly\GAC_32\System.Data.SQLite\1.0.60.0__db937bc2d44ff139\System.Data.SQLite.dll > > printed on my console. Does this happen for you? If not that would > lead me to believe that the System.Data.SQLite.dll file isnt properly > installed in the GAC. > > 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 -- 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