Re: [sqlite] System.Data.SQLite won't work untill Iinstall+uninstallit.

[Wamiduku]

On Oct 11, 1:59 am, "Joe Mistachkin" <sql...@mistachkin.com> wrote:
> Wamiduku wrote:
>
> I suppose the setup could uninstall the VC++
> runtime; however, it's typically considered "bad form" to do so (since
> it's officially a "shared" component).

I agree that the uninstall had better leave it there.

> > One solution to this dependency problem would be to add the VC redist
> > dlls to any portable SQLite app you make, but the redist is 19 dlls
> > and 11MB, so that's not very neat.
>
> I agree, several people have expressed concern about this issue both on
> this mailing list and on the project ticket tracker.

Not a problem though, since you can use the static SQLite DLL, which I
didn't know existed.

> > Rebuilding Sys.Data.SQLite with statically linked C++ libs, so that it
> > becomes standalone, would be a better solution. What would I need to
> > change in the VS2010 project in order to do that?
>
> Nothing.  There are already "Static" projects in the solutions.  Simply
> [also] build the projects named "SQLite.Interop.Static." in one of
> the solutions.
>
> The resulting binaries will be present in the:
>
>         \bin\\\Static

Holy hexadecimals, I feel like a moron for wasting all that time with
virtual machines and looking through Thinapp logs to track changes,
when the statically linked Sys.Data.SQLite DLL was just a rebuild
away! Gotta laugh at that ;-).

There's a case that's probably rare, but could be good to be aware of
anyway; Since the name and version is the same for both the static and
non static Sys.Data.SQLite DLL, if there's a Sys.Data.SQLite in the
GAC, .NET will load it and ignore any Sys.Data.SQLite in the app
directory.

So, if any sloppily written app installs a non static Sys.Data.SQLite
in the GAC, but doesn't install the VC runtime, any app with a static
SQLite in the app directory will stop working.

Maybe making the static Sys.Data.SQLite the default version could be
an idea to consider? Not being dependent on a previous VC runtime
installation would emphasize the self-contained and configuration-less
nature of SQLite.

-John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite won't work untill I install+uninstallit.

[Wamiduku]

On Oct 10, 4:01 am, "Joe Mistachkin" <sql...@mistachkin.com> wrote:
> Wamiduku wrote:
> > So, there is something that the installation does, which the uninstall
> > doesn't undo, that you have to do in order to get System.Data.SQLite
> > working. The question is what, and how can you do it without having to
> > run the installation?
>
> The setup attempts to undo everything that it does, including the GAC and
> NGen steps (if they were selected during installation).

I found it! By using the trial version of VMWare Thinapp and installing
+uninstalling Data.SQLite, you can see what the uninstallation left
behind, and it is the Visual C++ 2010 Redistributable Package.

I confirmed this by running textlinq.exe from the unzipped sqlite-
netFx40-
binary-bundle-Win32-2010-1.0.76.0 directory on a clean machine again,
which didn't work, and then installing VC 2010 redist (from
http://www.microsoft.com/download/en/details.aspx?id=), after
which testlinq.exe worked.

One solution to this dependency problem would be to add the VC redist
dlls to any portable SQLite app you make, but the redist is 19 dlls
and 11MB, so that's not very neat.

Rebuilding Sys.Data.SQLite with statically linked C++ libs, so that it
becomes standalone, would be a better solution. What would I need to
change in the VS2010 project in order to do that?

-John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite won't work untill I install+uninstallit.

[Wamiduku]

On Oct 10, 4:01 am, "Joe Mistachkin"  wrote:
>
> I'm not able to reproduce this locally.  As long as the "test.exe",
> "test.exe.config", and "System.Data.SQLite.dll" files are in the same
> directory, the tests should be able to complete.

I've unpacked all of sqlite-netFx40-binary-bundle-
Win32-2010-1.0.76.0.zip to a directory and run it from there, so
everything was in place in the directory.

Did you try this on a clean machine (fresh Windows installation) with
nothing but .NET 4 installed? If you try it on any machine where
System.Data.SQLite has been installed once, you'll not see the error.

> > 5 - Download and run the sqlite-netFx40-setup-bundle-
> > x86-2010-1.0.76.0.exe installation. Uncheck the two options to install
> > to the image cache and GAC.
> > 6 - After the installation, go to Control Panel and uninstall
> > System.Data.SQLite.
> > 7 - Run test.exe again. Now, it will work.
>
> If the "test.exe.config" and "System.Data.SQLite.dll" files are still
> present along side it, yes it will work.

I ran the tests from the unpacked sqlite-netFx40-
binary-bundle-Win32-2010-1.0.76.0.zip directory, so the files were
neither affected by the installation, nor the uninstallation.

-John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite won't work untill I install+uninstall it.

[Wamiduku]

I've tried to create an install-free app (portable), but I can't get
System.Data.SQLite to work unless I install it. Once installed, my app
works and it keeps working even after I uninstall System.Data.SQLite.

The same is true for the tests (test.exe and testlinq.exe) included in
sqlite-netFx40-binary-bundle-x64-2010-1.0.76.0 and sqlite-netFx40-
binary-bundle-Win32-2010-1.0.76.0.

Here are the steps to reproduce the problem:
1 - Start with a clean Windows machine (I've tried with both XP SP3
and Windows 7 SP1) with nothing installed (I used virtual machines for
testing).
2 - Install .NET 4.
3 - Download sqlite-netFx40-binary-bundle-Win32-2010-1.0.76.0.
4 - Run the included test.exe and click "Run". You'll get the error
message
"System.Configuration.ConfigurationErrorsException: Failed to find or
load the registered .Net Framework Data Provider.
   at System.Data.Common.DbProviderFactories.GetFactory(DataRow
providerRow)
   at test.TestCasesDialog.runButton_Click(Object sender, EventArgs e)
in c:\dev\sqlite\dotnet\test\TestCasesDialog.cs:line 104"

5 - Download and run the sqlite-netFx40-setup-bundle-
x86-2010-1.0.76.0.exe installation. Uncheck the two options to install
to the image cache and GAC.
6 - After the installation, go to Control Panel and uninstall
System.Data.SQLite.
7 - Run test.exe again. Now, it will work.

So, there is something that the installation does, which the uninstall
doesn't undo, that you have to do in order to get System.Data.SQLite
working. The question is what, and how can you do it without having to
run the installation?

-John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite - is 1.0.74 or 1.0.75 the currentversion?

[Wamiduku]

OK, so the version on the download page is the stable version and the
NuGet package is the development version. Are there any plans to also
provide the stable version as a NuGet package?

-John


On Oct 1, 10:33 pm, "Joe Mistachkin" <sql...@mistachkin.com> wrote:
> Wamiduku wrote:
>
> > Is this a typo somewhere, or does it mean that Nuget now is the preferred
> way
> > of distributing new Data.SQLite versions?
>
> There is no typo.  The current release version is 1.0.74.0.  The NuGet
> package is
> using the latest unreleased bits from trunk and is technically 1.0.75.0
> beta.
>
> The NuGet package is not necessarily going to be the 'preferred' way of
> distributing the bits in the future; however, it will be one way to get
> them.
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-us...@sqlite.orghttp://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] System.Data.SQLite - is 1.0.74 or 1.0.75 the current version?

[Wamiduku]

There seemes to be some confusion of the version numbers of
System.Data.SQLite. At Nuget, the version number says 1.0.75, whereas
the http://system.data.sqlite.org/ page says 1.0.74. Is this a typo
somewhere, or does it mean that Nuget now is the preferred way of
distributing new Data.SQLite versions?

-John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WPF, VS 2010 and System.Data.SQLite 1007200

[Wamiduku]

On May 23, 5:52 pm, "Christoph P.U. Kukulies" 
wrote:
> Am 23.05.2011 17:02, schrieb Drew Hohmann:
>
> > Hello,
> > What steps do I need to take to get SQLite to appear in the list of Data
> > Providers in Visual Studio 2010?  I've installed the latest
> > System.Data.SQLite (1007200), and when I select a Data Source the only
> > options for a data provider are
> > .NET Framework Data Provider for Microsoft SQL Server Compact 3.5
> > .NET Framework Data Provider for ODBC
> > .NET Framework Data Provider for OLE DB
> > .NET Framework Data Provider for Oracle
> > .NET Framework Data Provider for SQL Server
>
> > To reproduce:
> > Create A WPF project.
> > Add a Data Source to the application (menu, Data, Add New Data Source),
> > I select the Database option, click next and select Dataset, click next
> > and click on New Connection...
>
> > Thanks,
> > Drew
>
> Hi Drew,
>
> I had similar problems in getting System.Data.Sqlite into my project.
>
> First, do an Add Reference to your project and locate
> System.Data.Sqlite.dll in your file system. Load it. It's in \program
> files (x86)\Sqlite.NET\bin (Windows 7 at least, for me here).
>
> Did you tick VS2008 andVS2010both during  the install. I also had
> problems and I'm nit sure whether
> the installer works when both are ticked. Just guessing wildly.
>
> --
> Christoph


I have the exact same problem. When installing, I didn't even see any
checkboxes for VS2008 or VS2010, so I couldn't tick them. I'm running
VS2010 (Vs2008 not installed) on XP SP3.

-John

(This may be a double post, since I might have messed up in Google
groups.)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users