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
