Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-24 Thread 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:

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-23 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-22 Thread 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. --

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-22 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Electric Eddy
lite-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 us

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread Rob Richardson
ebruary 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 install

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-20 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-19 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-19 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-18 Thread 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,

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-18 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-18 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-18 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-18 Thread 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

Re: [sqlite] SQLiteDataAdaptor Missing

2012-02-17 Thread 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

[sqlite] SQLiteDataAdaptor Missing

2012-02-17 Thread Electric Eddy
I built a project originally using SQLite-1.0.66.0-setup.exe and when I upgraded to 1.0.79 the SQLiteDataAdaptor Toolbox control under Visual Studio 2005 Professional disappeared. The project still works after updating references from 1.0.66 to 1.0.79 however I