Re: [sqlite] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Electric Eddy wrote:
> 
> Yes.  It's running on 64bit but I compiled it for 32 bit.
>

That would explain it the log file data.  Can you check and see if the
registry keys from the log file data were actually created in the 32-bit
registry hive?  For example:

HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\
8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}

Meanwhile, as for the crash, I think I'll need to create a special
version of the SQLite.Designer.dll just for Visual Studio 2005 due to
the VS reference assemblies it uses.  I'll let you know when it's
available.

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

Yes.  It's running on 64bit but I compiled it for 32 bit.  I've tried using
the 64bit version however, when I reference the 64bit dll's the compiler
generates warnings about the image even when I set it to debug 64bit,  and
when I try to run the 64bit version it crashes so I've opted to compile it
as 32bit where I reinstalled the 32bit version of Sqlite using setup.  The
development environment happens to be 64bit however, the application needs
to run on both CPU architectures.

I'm able to drag and drop an SQLiteConnection from the toolbox within VS
designer 2005.  In 2008 all works well and when I design using 2008 and
manually copy the 2008 generated files back to the 2005 project the code
works fine, therefore the images seem fine.

I have see some instances previously where a package load failure messages
popped up when starting VS however, I believe this happened when I was
compiling under Any CPU or 64Bit.


Patrick

On Thu, Feb 23, 2012 at 1:06 AM, Joe Mistachkin wrote:

>
> Something is not quite right with that output.  You are running on 64-bit
> Windows?
>
> Are you able to add a new SQLite data connection from inside Visual Studio?
>
> Do you see any messages about a package load failure?
>
> For some reason, the installer tool believes it is running on 32-bit
> Windows.
>
> --
> Joe Mistachkin
>
> ___
> 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] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Something is not quite right with that output.  You are running on 64-bit
Windows?

Are you able to add a new SQLite data connection from inside Visual Studio?

Do you see any messages about a package load failure?

For some reason, the installer tool believes it is running on 32-bit
Windows.

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

After copying the compiled files into c:\Program Files
(x86)\System.Data.SQLite\2008\bin> and running the command:
Installer.exe -install true -wow64 true -installFlags All -tracePriority
Lowest -verbose true -noCompact true -noNetFx40 true -noVs2008 true
-noVs2010 true -whatIf false -confirm true

I get the output below but still no sign of the SQLiteDataAdapter as an
option under Toolbox\Choose Items...

Start of output:
---
C:\Program Files (x86)\System.Data.SQLite\2008\bin>Installer.exe -install
true -
wow64 true -installFlags All -tracePriority Lowest -verbose true -noCompact
true
 -noNetFx40 true -noVs2008 true -noVs2010 true -whatIf false -confirm true
Installer.exe: #1 @ 2012.02.21T20:49:44.8310261: Assembly: "Installer,
Version=1
.0.80.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"
Installer.exe: #2 @ 2012.02.21T20:49:44.8320261: LogFileName:
"C:\Users\Administ
rator\AppData\Local\Temp\2\Installer.exe.trace.tmp28CC.log"
Installer.exe: #3 @ 2012.02.21T20:49:44.8320261: Directory: "C:\Program
Files (x
86)\System.Data.SQLite\2008\bin"
Installer.exe: #4 @ 2012.02.21T20:49:44.8320261: CoreFileName: "C:\Program
Files
 (x86)\System.Data.SQLite\2008\bin\System.Data.SQLite.dll"
Installer.exe: #5 @ 2012.02.21T20:49:44.8330262: LinqFileName: "C:\Program
Files
 (x86)\System.Data.SQLite\2008\bin\System.Data.SQLite.Linq.dll"
Installer.exe: #6 @ 2012.02.21T20:49:44.8330262: DesignerFileName:
"C:\Program F
iles (x86)\System.Data.SQLite\2008\bin\SQLite.Designer.dll"
Installer.exe: #7 @ 2012.02.21T20:49:44.8330262: DebugFormat: "#{0} @ {1}:
{2}"
Installer.exe: #8 @ 2012.02.21T20:49:44.8340262: TraceFormat: "#{0} @ {1}:
{2}"
Installer.exe: #9 @ 2012.02.21T20:49:44.8340262: InstallFlags: Default
Installer.exe: #10 @ 2012.02.21T20:49:44.8340262: DebugPriority: Default
Installer.exe: #11 @ 2012.02.21T20:49:44.8340262: TracePriority: Lowest
Installer.exe: #12 @ 2012.02.21T20:49:44.8340262: Install: True
Installer.exe: #13 @ 2012.02.21T20:49:44.8340262: Wow64: True
Installer.exe: #14 @ 2012.02.21T20:49:44.8350263: NoRuntimeVersion: False
Installer.exe: #15 @ 2012.02.21T20:49:44.8350263: NoDesktop: False
Installer.exe: #16 @ 2012.02.21T20:49:44.8350263: NoCompact: True
Installer.exe: #17 @ 2012.02.21T20:49:44.8350263: NoNetFx20: False
Installer.exe: #18 @ 2012.02.21T20:49:44.8350263: NoNetFx40: True
Installer.exe: #19 @ 2012.02.21T20:49:44.8360263: NoVs2005: False
Installer.exe: #20 @ 2012.02.21T20:49:44.8360263: NoVs2008: True
Installer.exe: #21 @ 2012.02.21T20:49:44.8360263: NoVs2010: True
Installer.exe: #22 @ 2012.02.21T20:49:44.8370264: NoTrace: False
Installer.exe: #23 @ 2012.02.21T20:49:44.8370264: NoConsole: False
Installer.exe: #24 @ 2012.02.21T20:49:44.8370264: NoLog: False
Installer.exe: #25 @ 2012.02.21T20:49:44.8370264: ThrowOnMissing: True
Installer.exe: #26 @ 2012.02.21T20:49:44.8380265: WhatIf: False
Installer.exe: #27 @ 2012.02.21T20:49:44.8380265: Debug: False
Installer.exe: #28 @ 2012.02.21T20:49:44.8380265: Verbose: True
Installer.exe: #29 @ 2012.02.21T20:49:44.8380265: Confirm: True
Installer.exe: #30 @ 2012.02.21T20:49:44.8390265: AssemblyTitle:
"System.Data.SQ
Lite Designer Installer"
Installer.exe: #31 @ 2012.02.21T20:49:44.8390265: AssemblyConfiguration:
"Debug"

Installer.exe: #32 @ 2012.02.21T20:49:44.8400266: Configuration.Process:
Running
 executable is: "C:\Program Files
(x86)\System.Data.SQLite\2008\bin\Installer.ex
e"
Installer.exe: #33 @ 2012.02.21T20:49:44.8410266: Configuration.Process:
Origina
l command line is: Installer.exe  -install true -wow64 true -installFlags
All -t
racePriority Lowest -verbose true -noCompact true -noNetFx40 true -noVs2008
true
 -noVs2010 true -whatIf false -confirm true
Installer.exe: #34 @ 2012.02.21T20:49:44.8420267: Configuration.Process:
Running
 process is 32-bit.
Installer.exe: #35 @ 2012.02.21T20:49:44.8440268:
Configuration.CheckRuntimeVers
ion: Assembly is compiled for the .NET Framework v2.0.50727, support for
.NET Fr
amework v4.0.30319 is now disabled.
Installer.exe: #36 @ 2012.02.21T20:49:44.9210312: Installer.Main:
GacInstall: as
semblyPath = "C:\Program Files
(x86)\System.Data.SQLite\2008\bin\System.Data.SQL
ite.dll"
Installer.exe: #37 @ 2012.02.21T20:49:44.9710341: Installer.Main:
GacInstall: as
semblyPath = "C:\Program Files
(x86)\System.Data.SQLite\2008\bin\System.Data.SQL
ite.Linq.dll"
Installer.exe: #38 @ 2012.02.21T20:49:44.9740342:
Installer.ForEachFrameworkRegi
stry: frameworkName = ".NETFramework", frameworkVersion = v2.0.50727,
platformNa
me = 
Installer.exe: #39 @ 2012.02.21T20:49:44.9750343:
RegistryHelper.OpenSubKey: roo
tKey = "HKEY_LOCAL_MACHINE", subKeyName =
"Software\Microsoft\.NETFramework\v2.0
.50727", writable = False
Installer.exe: #40 @ 2012.02.21T20:49:44.9770344:
RegistryHelper.OpenSubKey: roo
tKey = "HKEY_LOCAL_MACHINE", subKeyName =
"Software\Microsoft\.NETFramework", wr
itable = False
Installer.exe: #41 @ 

Re: [sqlite] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Electric Eddy wrote:
> 
> This then popped up an error message dialogue box stating:
> 
> Invalid core file image runtime version.
>

You'll want to copy the "Installer.exe" file to your installation directory
first (where the "SQLite.Designer.dll" file resides).

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

VS is installed on an x64 system so when I build using VS IDE I normally
specify x86.

I don't normally build using MSBuild however, I inserted the line:
x86
in the project file and changed references to Any CPU to x86 and then
rebuilt the installer but get the same error when I run the command.

I tried building it in VS IDE and set the target to Debug x86 but still get
the error.

I've rechecked out the files so it's back to where it was before building.

Is there something specific I need to include on the MSBuild command line?

Patrick


On Mon, Feb 20, 2012 at 3:41 PM, Rob Richardson <rdrichard...@rad-con.com>wrote:

> In another library, I had to specify "x86" processor because it wasn't
> designed for 64-bit machines.  Might you need to do that?
>
> RobR
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:
> sqlite-users-boun...@sqlite.org] On Behalf Of Electric Eddy
> Sent: Monday, February 20, 2012 10:26 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] SQLiteDataAdaptor Missing
>
> I performed the following steps:
>
> 1) Checked out the latest local copy using the command 'fossil update'
> 2) I opened a Visual Studio command prompt, changed into the tools
> installer folder and executed the command MSBuild Installer.2008.csproj
> 3) I changed into the root/bin/2008/Debug/bin folder and executed the
> following one line command:
>
> Installer.exe -install true -wow64 true -installFlags All -tracePriority
> Lowest -verbose true -noCompact true -noNetFx40 true -noVs2008 true
> -noVs2010 true -whatIf false -confirm true
>
> This then popped up an error message dialogue box stating:
>
> Invalid core file image runtime version.
>
>
>
>
> On Mon, Feb 20, 2012 at 1:59 PM, Joe Mistachkin <sql...@mistachkin.com
> >wrote:
>
> >
> > Electric Eddy wrote:
> > >
> > > Maybe not going as far as including updates in the installer for
> > > support for 2005 but at least a manual process for getting it
> > > working in 2005
> > would
> > > be very helpful.
> > >
> >
> > I've just checked-in preliminary support to the design-time component
> > installer for Visual Studio 2005; however, I currently have no way to
> > test it.
> >
> > If you wish to use and/or test it, here is the command line you will
> > need after building "Installer.exe" (which can be built using MSBuild
> > on the command
> > line):
> >
> >Installer.exe -install true -wow64 true -installFlags All
> >-tracePriority Lowest -verbose true -noCompact true -noNetFx40
> true
> >-noVs2008 true -noVs2010 true -whatIf false -confirm true
> >
> > All of that needs to be on one line.
> >
> > --
> > Joe Mistachkin
> >
> > ___
> > 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-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] SQLiteDataAdaptor Missing

[Rob Richardson]

In another library, I had to specify "x86" processor because it wasn't designed 
for 64-bit machines.  Might you need to do that?

RobR

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Electric Eddy
Sent: Monday, February 20, 2012 10:26 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLiteDataAdaptor Missing

I performed the following steps:

1) Checked out the latest local copy using the command 'fossil update'
2) I opened a Visual Studio command prompt, changed into the tools installer 
folder and executed the command MSBuild Installer.2008.csproj
3) I changed into the root/bin/2008/Debug/bin folder and executed the following 
one line command:

Installer.exe -install true -wow64 true -installFlags All -tracePriority Lowest 
-verbose true -noCompact true -noNetFx40 true -noVs2008 true
-noVs2010 true -whatIf false -confirm true

This then popped up an error message dialogue box stating:

Invalid core file image runtime version.




On Mon, Feb 20, 2012 at 1:59 PM, Joe Mistachkin <sql...@mistachkin.com>wrote:

>
> Electric Eddy wrote:
> >
> > Maybe not going as far as including updates in the installer for 
> > support for 2005 but at least a manual process for getting it 
> > working in 2005
> would
> > be very helpful.
> >
>
> I've just checked-in preliminary support to the design-time component 
> installer for Visual Studio 2005; however, I currently have no way to 
> test it.
>
> If you wish to use and/or test it, here is the command line you will 
> need after building "Installer.exe" (which can be built using MSBuild 
> on the command
> line):
>
>Installer.exe -install true -wow64 true -installFlags All
>-tracePriority Lowest -verbose true -noCompact true -noNetFx40 true
>-noVs2008 true -noVs2010 true -whatIf false -confirm true
>
> All of that needs to be on one line.
>
> --
> Joe Mistachkin
>
> ___
> 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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

I performed the following steps:

1) Checked out the latest local copy using the command 'fossil update'
2) I opened a Visual Studio command prompt, changed into the tools
installer folder and executed the command MSBuild Installer.2008.csproj
3) I changed into the root/bin/2008/Debug/bin folder and executed the
following one line command:

Installer.exe -install true -wow64 true -installFlags All -tracePriority
Lowest -verbose true -noCompact true -noNetFx40 true -noVs2008 true
-noVs2010 true -whatIf false -confirm true

This then popped up an error message dialogue box stating:

Invalid core file image runtime version.




On Mon, Feb 20, 2012 at 1:59 PM, Joe Mistachkin wrote:

>
> Electric Eddy wrote:
> >
> > Maybe not going as far as including updates in the installer for support
> > for 2005 but at least a manual process for getting it working in 2005
> would
> > be very helpful.
> >
>
> I've just checked-in preliminary support to the design-time component
> installer
> for Visual Studio 2005; however, I currently have no way to test it.
>
> If you wish to use and/or test it, here is the command line you will need
> after
> building "Installer.exe" (which can be built using MSBuild on the command
> line):
>
>Installer.exe -install true -wow64 true -installFlags All
>-tracePriority Lowest -verbose true -noCompact true -noNetFx40 true
>-noVs2008 true -noVs2010 true -whatIf false -confirm true
>
> All of that needs to be on one line.
>
> --
> Joe Mistachkin
>
> ___
> 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] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Electric Eddy wrote:
> 
> Maybe not going as far as including updates in the installer for support
> for 2005 but at least a manual process for getting it working in 2005
would
> be very helpful.
> 

I've just checked-in preliminary support to the design-time component
installer
for Visual Studio 2005; however, I currently have no way to test it.

If you wish to use and/or test it, here is the command line you will need
after
building "Installer.exe" (which can be built using MSBuild on the command
line):

Installer.exe -install true -wow64 true -installFlags All
-tracePriority Lowest -verbose true -noCompact true -noNetFx40 true
-noVs2008 true -noVs2010 true -whatIf false -confirm true

All of that needs to be on one line.

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

Just the SQLiteDataAdapter component to work in 2005. I've no immediate
need to compile SQLite from source as the downloadable Setup for .NET is
enabling me build my projects successfully.  The problem is I initially
used the designer to create a number of SQLiteDataAdapters and related
components and I have modified the database schema and now need to
regenerate the adapters related SLQ commands.   To include the new fields I
simply delete the old SQLiteDataAdapters and drag a new one in from the
Toolbox and use the SQL query builder to create the new SQL commands.  It's
easy enough for me to build these commands programatically however, the
designer was used extensively throughout the project so it would be very
time consuming to remove the designer generated code and replace it with
normal code.

Patrick

On Mon, Feb 20, 2012 at 12:58 PM, Joe Mistachkin wrote:

>
> Electric Eddy wrote:
> >
> > Maybe not going as far as including updates in the installer for support
> > for 2005 but at least a manual process for getting it working in 2005
> would
> > be very helpful.
> >
>
> Out of curiosity, what do you need more, the design-time component
> installer
> to work with Visual Studio 2005 or the actual project files and build
> system
> to work with Visual Studio 2005?
>
> --
> Joe Mistachkin
>
> ___
> 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] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Electric Eddy wrote:
> 
> Maybe not going as far as including updates in the installer for support
> for 2005 but at least a manual process for getting it working in 2005
would
> be very helpful.
> 

Out of curiosity, what do you need more, the design-time component installer
to work with Visual Studio 2005 or the actual project files and build system
to work with Visual Studio 2005?

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

I was just going on the basis of what I paid for the professional version
the last time.  Although 2005 is an old version there are a huge number of
developers maintaining legacy systems on this platform, so I would consider
it worthwhile keeping them in the loop, and would be willing to setup a
remotely accessible VS 2005 environment for someone to explore the issue
further.

Maybe not going as far as including updates in the installer for support
for 2005 but at least a manual process for getting it working in 2005 would
be very helpful.

Patrick.

On Mon, Feb 20, 2012 at 4:38 AM, Joe Mistachkin wrote:

>
> Electric Eddy wrote:
> >
> > That's a pity, my problem is for the type of development I do, spending a
> > few grand on upgrading to 2008 for the sake of the SQLite designer
> > capability would be hard to justify.
> >
>
> Actually, I managed to find Visual Studio 2008 Standard for sale on the
> Sears web site for less than $300.
>
> >
> > My workaround for the moment is I designed it in a trial version of 2008
> > and manually copy the relevant files back to 2005.
> >
>
> The design-time components are the only feature of System.Data.SQLite that
> have to support specific versions of Visual Studio and their use is
> completely
> optional.  Yes, they make it easier to design tables, etc; however,
> everything
> they do can easily be done manually as well.
>
> >
> > I'll probably need to port to MS SQL to allow for future maintenance of
> the
> > legacy application I'm maintaining.
> >
>
> That might be a valid option; however, even if you use the "Express"
> edition,
> which is the only free option, you still have to install it and that can be
> quite challenging.
>
> --
> Joe Mistachkin
>
> ___
> 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] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Electric Eddy wrote:
> 
> That's a pity, my problem is for the type of development I do, spending a
> few grand on upgrading to 2008 for the sake of the SQLite designer
> capability would be hard to justify.
> 

Actually, I managed to find Visual Studio 2008 Standard for sale on the
Sears web site for less than $300.

> 
> My workaround for the moment is I designed it in a trial version of 2008
> and manually copy the relevant files back to 2005.
> 

The design-time components are the only feature of System.Data.SQLite that
have to support specific versions of Visual Studio and their use is
completely
optional.  Yes, they make it easier to design tables, etc; however,
everything
they do can easily be done manually as well.

> 
> I'll probably need to port to MS SQL to allow for future maintenance of
the
> legacy application I'm maintaining.
> 

That might be a valid option; however, even if you use the "Express"
edition,
which is the only free option, you still have to install it and that can be
quite challenging.

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

That's a pity, my problem is for the type of development I do, spending a
few grand on upgrading to 2008 for the sake of the SQLite designer
capability would be hard to justify.

My workaround for the moment is I designed it in a trial version of 2008
and manually copy the relevant files back to 2005.

I'll probably need to port to MS SQL to allow for future maintenance of the
legacy application I'm maintaining.

Patrick.
On Sun, Feb 19, 2012 at 12:39 AM, Joe Mistachkin wrote:

>
> Electric Eddy wrote:
> >
> > The installer still only appears to detect that VS 2008 is installed and
> > gives me the option to configure designer support for 2008.
> >
>
> The design-time components themselves probably still support Visual Studio
> 2005; however, the new installer does not.  In theory, support could be
> added to the new installer as well; however, I do not have any nice way
> to test it (I would need to build an entirely new virtual machine with
> Visual Studio 2005 on it).
>
> Also, none of the projects in the source tree officially support Visual
> Studio 2005 as it was released almost 7 years ago and is now obsolete,
> having been completely displaced by Visual Studio 2008, which is almost
> 100% forward compatible with it.
>
> --
> Joe Mistachkin
>
> ___
> 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] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Electric Eddy wrote:
> 
> The installer still only appears to detect that VS 2008 is installed and
> gives me the option to configure designer support for 2008.
> 

The design-time components themselves probably still support Visual Studio
2005; however, the new installer does not.  In theory, support could be
added to the new installer as well; however, I do not have any nice way
to test it (I would need to build an entirely new virtual machine with
Visual Studio 2005 on it).

Also, none of the projects in the source tree officially support Visual
Studio 2005 as it was released almost 7 years ago and is now obsolete,
having been completely displaced by Visual Studio 2008, which is almost
100% forward compatible with it.

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

Some addition info...

After restarting VS 2005 I noticed that the output window displays:

"VSIP: Developer edition, all third-party packages allowed to load"

I'm assuming that this means there's no need to apply the 1.0.80 patch now?

As it all works fine under 2008, and although I've installed the SDK for
2005. I'm still not quite sure why the SQLiteDataAdapter doesn't appear as
an available reference when selecting the Toolbox/Choose Items... dialogue.

I've tried replacing the .dll with a patched version 1.0.80 but it still
does not appear in the list.

The installer still only appears to detect that VS 2008 is installed and
gives me the option to configure designer support for 2008.

When I view the toolbox/Choose Items references under VS 2008 I see the
following:

SQLiteCommand
SQLiteCommandBuilder
SQLiteConnection
SQLiteDataAdapter

Whereas under VS 2005 I only see:

SQLiteCommand
SQLiteCommandBuilder
SQLiteConnection

If I add a reference manually, by browsing to the 1.0.80 compiled .dll file
I get an addition reference relating to AutoCompleteEditing, but still no
sign of the SQLiteDataAdapter in the toolbox.

Should the installer list VS 2005 as an option to configure during the
installation or should VS 2005 be covered by the VS 2008 option?

Regards

Patrick


On Sat, Feb 18, 2012 at 12:44 PM, Electric Eddy wrote:

> Thanks, when I looked at the version of the SQLiteDataAdapter it was
> 1.0.66 and listed in the GAC eve n though that version was removed.  When I
> unchecked the reference it disappeared and after a reinstall of 1.0.79 it
> now works in 2008 although I had to install a number of Microsoft tools to
> resolve a subsequent issue relating to Microsoft.SQLServer.Types which
> seems to be a prerequisite.
>
> I'm now trying to get it working under 2005 as I have a licence for that
> specific version. I installed the 2005 SDK as the workaround you suggested
> however, as the 2008 SDK was installed previously it seems to ignore the
> 2005 SDK so I'll download the patch.
>
> Regards
>
> Patrick.
>
>
> On Sat, Feb 18, 2012 at 10:27 AM, Joe Mistachkin wrote:
>
>>
>> Electric Eddy wrote:
>> >
>> > e.g. DeleteCommand/CommandText it pops up an error stating: Data
>> Provider
>> > identified by guid '----' could not be
>> > loaded.
>> >
>> I haven't seen that specific error before.  When you ran the setup, did
>> you
>> select the option to add the assemblies to the GAC?
>>
>> >
>> > Also, I intend to get it working with VS 2005 but I'm not sure about the
>> > fossil clone command to download the patch.  Is there a specific url I
>> need
>> > to specify to get these files?
>> >
>>
>> Also, the instructions on the following web page should work for cloning:
>>
>> http://system.data.sqlite.org/index.html/doc/trunk/www/source.wiki
>>
>> --
>> Joe Mistachkin
>>
>> ___
>> 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] SQLiteDataAdaptor Missing

[Electric Eddy]

Thanks, when I looked at the version of the SQLiteDataAdapter it was 1.0.66
and listed in the GAC even though that version was removed.  When I
unchecked the reference it disappeared and after a reinstall of 1.0.79 it
now works in 2008 although I had to install a number of Microsoft tools to
resolve a subsequent issue relating to Microsoft.SQLServer.Types which
seems to be a prerequisite.

I'm now trying to get it working under 2005 as I have a licence for that
specific version. I installed the 2005 SDK as the workaround you suggested
however, as the 2008 SDK was installed previously it seems to ignore the
2005 SDK so I'll download the patch.

Regards

Patrick.

On Sat, Feb 18, 2012 at 10:27 AM, Joe Mistachkin wrote:

>
> Electric Eddy wrote:
> >
> > e.g. DeleteCommand/CommandText it pops up an error stating: Data Provider
> > identified by guid '----' could not be
> > loaded.
> >
> I haven't seen that specific error before.  When you ran the setup, did you
> select the option to add the assemblies to the GAC?
>
> >
> > Also, I intend to get it working with VS 2005 but I'm not sure about the
> > fossil clone command to download the patch.  Is there a specific url I
> need
> > to specify to get these files?
> >
>
> Also, the instructions on the following web page should work for cloning:
>
> http://system.data.sqlite.org/index.html/doc/trunk/www/source.wiki
>
> --
> Joe Mistachkin
>
> ___
> 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] SQLiteDataAdaptor Missing

[Joe Mistachkin]

Electric Eddy wrote:
> 
> e.g. DeleteCommand/CommandText it pops up an error stating: Data Provider
> identified by guid '----' could not be
> loaded.
> 

I haven't seen that specific error before.  When you ran the setup, did you
select the option to add the assemblies to the GAC?

> 
> Also, I intend to get it working with VS 2005 but I'm not sure about the
> fossil clone command to download the patch.  Is there a specific url I
need
> to specify to get these files? 
> 

Also, the instructions on the following web page should work for cloning:

http://system.data.sqlite.org/index.html/doc/trunk/www/source.wiki

--
Joe Mistachkin

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

Re: [sqlite] SQLiteDataAdaptor Missing

[Electric Eddy]

I downloaded VS 2008 trial and associated SDK and reinstalled sqlite and
the controls appear in the Toolbox under 2008.  However, when I open the
properties of an existing SQLiteDataAdaptor and press the "..." next to
e.g. DeleteCommand/CommandText it pops up an error stating: Data Provider
identified by guid '----' could not be
loaded.

If I drag a new SQLiteDataAdaptor from the toolbox to the VS Designer
nothing appears in the drop down list relating to connections and when I
specify New Connection nothing happens whereas in a previous version I
vaguely recall that a configuration dialogue popped up relating to the
select/update/delete statement configuration.

Also, I intend to get it working with VS 2005 but I'm not sure about the
fossil clone command to download the patch.  Is there a specific url I need
to specify to get these files?

Patrick.



On Fri, Feb 17, 2012 at 11:14 PM, Joe Mistachkin wrote:

>
> This is probably due to an issue with the Package Load Key (PLK) fixed here
> (this fix will be in release 1.0.80.0):
>
> https://system.data.sqlite.org/index.html/ci/67caeebd79
>
> In the meantime, a possible workaround is to install the Visual Studio SDK
> for the version of Visual Studio that you are using as that will allow all
> packages to load.
>
> --
> Joe Mistachkin
>
> ___
> 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] SQLiteDataAdaptor Missing

[Joe Mistachkin]

This is probably due to an issue with the Package Load Key (PLK) fixed here
(this fix will be in release 1.0.80.0):

https://system.data.sqlite.org/index.html/ci/67caeebd79

In the meantime, a possible workaround is to install the Visual Studio SDK
for the version of Visual Studio that you are using as that will allow all
packages to load.

--
Joe Mistachkin

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