Re: [sqlite] howto setup SQLite with Powershell ?
> What I'm wondering is, am I the only one who wants to use SQLite together > with Powershell? You're the first person I've heard of trying to do it. Really I think your SQLite.Net provider is incorrectly installed. can you please provide the output of the following command: gacutil /l System.Data.SQLite Mine produces the following output: Microsoft (R) .NET Global Assembly Cache Utility. Version 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved. The Global Assembly Cache contains the following assemblies: System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=x86 System.Data.SQLite, Version=1.0.53.0, Culture=neutral, PublicKeyToken=1fdb50b1b62b4c84, processorArchitecture=MSIL If you dont get any lines returned that means you don't have the ADO.Net provider installed and you'll need to install it. Download it from : http://sqlite.phxsoftware.com. On Fri, Oct 10, 2008 at 7:56 AM, Brad Stiles <[EMAIL PROTECTED]> wrote: >>> access ... dll from PowerShell ... PowerShell docs >> >> the procedure given there is to register the dll with installutil. > > The use of the word "register" implies to me that they might be > assuming a COM dll or .NET com visible assembly. I don't believe the > SQLITE3.DLL qualifies as either. :) As well, as far as I know, > InstallUtil is only capable of installing assemblies that have been > designed to be installed that way. It's not effective for original > style DLLs. > > You might try revisiting the use of one of the .NET providers by > installing it in the GAC, or perhaps even using REGASM. For those, > though, I will repeat the need for asking on the forums dedicated to > those products. If you want a robust, well supported one, Robert > Simpson's ADO.NET provider, hosted at http://sqlite.phxsoftware.com, > is excellent. I've used it in a number of programs, and it works > quite well. > > Since PowerShell is highly .NET aware, using a provider designed for > that platform seems more likely to result in success than using a > plain dll. Installed into the GAC, I suspect that provider would work > quite well under PowerShell. > >> What I'm wondering is, am I the only one who wants to use SQLite together >> with Powershell? > > Starting to look that way, isn't it? > > Brad > ___ > 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
Re: [sqlite] howto setup SQLite with Powershell ?
>> access ... dll from PowerShell ... PowerShell docs > > the procedure given there is to register the dll with installutil. The use of the word "register" implies to me that they might be assuming a COM dll or .NET com visible assembly. I don't believe the SQLITE3.DLL qualifies as either. :) As well, as far as I know, InstallUtil is only capable of installing assemblies that have been designed to be installed that way. It's not effective for original style DLLs. You might try revisiting the use of one of the .NET providers by installing it in the GAC, or perhaps even using REGASM. For those, though, I will repeat the need for asking on the forums dedicated to those products. If you want a robust, well supported one, Robert Simpson's ADO.NET provider, hosted at http://sqlite.phxsoftware.com, is excellent. I've used it in a number of programs, and it works quite well. Since PowerShell is highly .NET aware, using a provider designed for that platform seems more likely to result in success than using a plain dll. Installed into the GAC, I suspect that provider would work quite well under PowerShell. > What I'm wondering is, am I the only one who wants to use SQLite together > with Powershell? Starting to look that way, isn't it? Brad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] howto setup SQLite with Powershell ?
> It's very possible you're the first one. then google will not help > Google is your friend. Not in this case. Be sure that I look around extensively before starting a thread. And so I already found your links. Both are rather nice approaches, but they depend on (an) installed and working database[s]. And that is what I'm still looking for. Original-Nachricht > Datum: Thu, 9 Oct 2008 17:28:40 -0500 > Von: "Ribeiro, Glauber" <[EMAIL PROTECTED]> > An: "General Discussion of SQLite Database" > Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > It's very possible you're the first one. > > How about adapting something like this: > http://theessentialexchange.com/blogs/michael/archive/2008/01/07/multi-p > latform-database-access-with-powershell.aspx > > Even closer to what you want: > http://mcmanus.typepad.com/grind/2007/09/data-driven-asp.html > > Google is your friend. > > g > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 09, 2008 2:58 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] howto setup SQLite with Powershell ? > > [...] > > What I'm wondering is, am I the only one who wants to use SQLite > together with Powershell? > > ___ > 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
Re: [sqlite] howto setup SQLite with Powershell ?
It's very possible you're the first one. How about adapting something like this: http://theessentialexchange.com/blogs/michael/archive/2008/01/07/multi-p latform-database-access-with-powershell.aspx Even closer to what you want: http://mcmanus.typepad.com/grind/2007/09/data-driven-asp.html Google is your friend. g -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 2:58 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] howto setup SQLite with Powershell ? [...] What I'm wondering is, am I the only one who wants to use SQLite together with Powershell? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] howto setup SQLite with Powershell ?
I think it would be cool to use System.Data.SQLite with powershell; I'm waiting until you figure it out before I try it. I don't have a compelling reason to try it myself yet, but the neato factor has me paying attention. Some of the readers seem to think you should ask these questions elsewhere because this is neither the powershell list nor the System.Data.SQLite list, but please stick around if only to give the answer once you figure it out. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, October 09, 2008 3:58 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] howto setup SQLite with Powershell ? > access ... dll from PowerShell ... PowerShell docs the procedure given there is to register the dll with installutil. When I first ran it, it looks ok. As I rerun it during my efforts I got an error: No public installers with the RunInstallerAttribute.Yes attribute could be found in the ...\System.Data.SQLite.dll assembly. What I'm wondering is, am I the only one who wants to use SQLite together with Powershell? Original-Nachricht > Datum: Thu, 9 Oct 2008 15:26:04 -0400 > Von: "Brad Stiles" <[EMAIL PROTECTED]> > An: "General Discussion of SQLite Database" > Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > > The original problem is given in the topic. > > The System.Data.SQLite provider (which I currently can't get running) is > hopefully only one solution. > > You mentioned the System.Data.SQLite provider in every message you > posted, and presented it in such a way that I interpreted you to have > asked "howto setup SQLite with Powershell using System.Data.SQLite". > That's what I was responding to. > > > SQLite provides sqlite3.exe and sqlite3.dll. > > However you'd access any other non-.NET, non-COM, dll from PowerShell > is probably going to be the way you access this one. Are the > PowerShell docs not any help with this? > > > How can I use that with powershell? > > Not a clue, other than to execute the sqlite3.exe program with the > appropriate command line parameters to accomplish what I want. > > Brad > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Pt! 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
Re: [sqlite] howto setup SQLite with Powershell ?
> access ... dll from PowerShell ... PowerShell docs the procedure given there is to register the dll with installutil. When I first ran it, it looks ok. As I rerun it during my efforts I got an error: No public installers with the RunInstallerAttribute.Yes attribute could be found in the ...\System.Data.SQLite.dll assembly. What I'm wondering is, am I the only one who wants to use SQLite together with Powershell? Original-Nachricht > Datum: Thu, 9 Oct 2008 15:26:04 -0400 > Von: "Brad Stiles" <[EMAIL PROTECTED]> > An: "General Discussion of SQLite Database" > Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > > The original problem is given in the topic. > > The System.Data.SQLite provider (which I currently can't get running) is > hopefully only one solution. > > You mentioned the System.Data.SQLite provider in every message you > posted, and presented it in such a way that I interpreted you to have > asked "howto setup SQLite with Powershell using System.Data.SQLite". > That's what I was responding to. > > > SQLite provides sqlite3.exe and sqlite3.dll. > > However you'd access any other non-.NET, non-COM, dll from PowerShell > is probably going to be the way you access this one. Are the > PowerShell docs not any help with this? > > > How can I use that with powershell? > > Not a clue, other than to execute the sqlite3.exe program with the > appropriate command line parameters to accomplish what I want. > > Brad > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Pt! 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
Re: [sqlite] howto setup SQLite with Powershell ?
> The original problem is given in the topic. > The System.Data.SQLite provider (which I currently can't get running) is > hopefully only one solution. You mentioned the System.Data.SQLite provider in every message you posted, and presented it in such a way that I interpreted you to have asked "howto setup SQLite with Powershell using System.Data.SQLite". That's what I was responding to. > SQLite provides sqlite3.exe and sqlite3.dll. However you'd access any other non-.NET, non-COM, dll from PowerShell is probably going to be the way you access this one. Are the PowerShell docs not any help with this? > How can I use that with powershell? Not a clue, other than to execute the sqlite3.exe program with the appropriate command line parameters to accomplish what I want. Brad ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] howto setup SQLite with Powershell ?
I have no idea of unix shell scripts. Is there a startup guide? But it's hard to imagine to use a cmdline-tool in an object-orientated manner. @Jeffrey: which steps have you performed before your LoadWithPartialName succeeds? Original-Nachricht > Datum: Thu, 9 Oct 2008 15:06:41 -0400 > Von: "Jeffrey Becker" <[EMAIL PROTECTED]> > An: "General Discussion of SQLite Database" > Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > Technically there's nothing stopping you from using sqlite3.exe in the > same way you'd use it in a unix shell script. > > On Thu, Oct 9, 2008 at 2:54 PM, Helga Lachmann <[EMAIL PROTECTED]> wrote: > > The original problem is given in the topic. > > The System.Data.SQLite provider (which I currently can't get running) is > hopefully only one solution. > > > > Do you have an answer to the original question? > > SQLite provides sqlite3.exe and sqlite3.dll. > > How can I use that with powershell? > > > > > > Original-Nachricht > >> Datum: Thu, 9 Oct 2008 14:40:47 -0400 > >> Von: "Brad Stiles" <[EMAIL PROTECTED]> > >> An: "General Discussion of SQLite Database" > >> Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > > > >> > 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. > >> > >> You should really be asking these questions on the forum/list > >> dedicated to the support of the product you are working with, i.e. the > >> producer of the System.Data.SQLite provider. > >> > >> You will likely need to either install the assembly to the GAC > >> yourself, or use some other method to tell PowerShell where the > >> assembly is located. > >> ___ > >> 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 -- Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] howto setup SQLite with Powershell ?
Technically there's nothing stopping you from using sqlite3.exe in the same way you'd use it in a unix shell script. On Thu, Oct 9, 2008 at 2:54 PM, Helga Lachmann <[EMAIL PROTECTED]> wrote: > The original problem is given in the topic. > The System.Data.SQLite provider (which I currently can't get running) is > hopefully only one solution. > > Do you have an answer to the original question? > SQLite provides sqlite3.exe and sqlite3.dll. > How can I use that with powershell? > > > Original-Nachricht >> Datum: Thu, 9 Oct 2008 14:40:47 -0400 >> Von: "Brad Stiles" <[EMAIL PROTECTED]> >> An: "General Discussion of SQLite Database" >> Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > >> > 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. >> >> You should really be asking these questions on the forum/list >> dedicated to the support of the product you are working with, i.e. the >> producer of the System.Data.SQLite provider. >> >> You will likely need to either install the assembly to the GAC >> yourself, or use some other method to tell PowerShell where the >> assembly is located. >> ___ >> 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
Re: [sqlite] howto setup SQLite with Powershell ?
The original problem is given in the topic. The System.Data.SQLite provider (which I currently can't get running) is hopefully only one solution. Do you have an answer to the original question? SQLite provides sqlite3.exe and sqlite3.dll. How can I use that with powershell? Original-Nachricht > Datum: Thu, 9 Oct 2008 14:40:47 -0400 > Von: "Brad Stiles" <[EMAIL PROTECTED]> > An: "General Discussion of SQLite Database" > Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > > 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. > > You should really be asking these questions on the forum/list > dedicated to the support of the product you are working with, i.e. the > producer of the System.Data.SQLite provider. > > You will likely need to either install the assembly to the GAC > yourself, or use some other method to tell PowerShell where the > assembly is located. > ___ > 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
Re: [sqlite] howto setup SQLite with Powershell ?
> 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. You should really be asking these questions on the forum/list dedicated to the support of the product you are working with, i.e. the producer of the System.Data.SQLite provider. You will likely need to either install the assembly to the GAC yourself, or use some other method to tell PowerShell where the assembly is located. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] howto setup SQLite with Powershell ?
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" > Betreff: Re: [sqlite] howto setup SQLite with Powershell ? > When I run the LoadWithPartialName I get: > > GACVersionLocation > ------ > 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" > >> 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" > > >> >> 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 > >> &g
Re: [sqlite] howto setup SQLite with Powershell ?
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" >> 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" >> >> 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 >> >&g
Re: [sqlite] howto setup SQLite with Powershell ?
When I run the LoadWithPartialName I get: GACVersionLocation ------ 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" >> 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" >> >> 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] >> >
Re: [sqlite] howto setup SQLite with Powershell ?
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" > 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" > >> 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 > > > > -- > > Pt! 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
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" >> 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 > > -- > Pt! 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
Re: [sqlite] howto setup SQLite with Powershell ?
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" > 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 -- Pt! 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
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
[sqlite] howto setup SQLite with Powershell ?
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