System.Data.SQLite

"Add Connection" dialog closes (w/o error message) if I try to select/create database. Even if I click on any checkbox or "Test Connection" button.

I had installed SQLite-1.0.29.0-binary.msi and added System.Data.SQLite.DLL (from /bin/) as a reference. I even tryed adding SQLite.Designer.dll as a reference and still couldn't Add New Data Source.

SQLiteConnection conn = new SQLiteConnection()    and   SQLiteConnection.CreateFile()
compiled just fine.

Am I missing something?

Hrm.  Run two instances of Visual Studio.  In the first instance, open the server explorer window and select "Add connection".

In the second instance, attach to process, and select the 1st instance of devenv.exe.  Once its loaded, Go to Debug->Exceptions and make sure you're breaking when .NET exceptions are thrown (check the checkbox).

Back to the first instance (being debugged) go ahead and add a SQLite connection.  The 2nd isntance of VS should break at a first-chance exception error when you hit Test or OK or whatever you do to make it disappear.  Post the error information here so I can view it.

Robert

 

2nd instance of VS didn't broke when the dialog disappeared.

This is my version of VS:
Microsoft Visual Studio 2005
Version 8.0.50727.42  (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727
Installed Edition: Enterprise

Have you had any previous VS2005 betas installed on your machine?

If the dialog box is disappearing with no errors, then something very fishy is going on!

 

rsimpson wrote:

Have you had any previous VS2005 betas installed on your machine?

no, just VS2005 and VB.NET/C# Express 2005

rsimpson wrote:

If the dialog box is disappearing with no errors, then something very fishy is going on!

Interesting thing is that I get the same error on my laptop (C# Express 2005). Is there any chance that some of the installed programs could conflict?

UPDATE:
In the Toolbox I manualy added (right click -> choose items...) SQLiteCommandBuilder, SQLiteCommand, SQLiteDataAdapter and SQLiteConnection (hadn't seen them there before). I can place all controls on the form except for SQLiteDataAdapter. I get "Unable to find the requested .NET Framework Data Provider. It may not be installed" when I try to add SQLiteDataAdapter on the form from Toolbox. Does that mean anything to you? :) At least VS2005 showed some error ;)

Well, that's pretty odd.  Re-run the install.exe program under bin\designer, then check and uncheck the various development environments you want the provider installed into, then see if it still gives you trouble.

Robert

 

Done that a few times -- didn't help.

I do all my database handling thru code so that doesn't bother me too much :) I have Croatian locale settings but I think that that shouldn't make any difference.

Btw; great work Robert!! Big Respect and thanks!
Davorin Vlasic, student

Did somebody solve the error?
I've been having this issue since months, and finally I decided to remove the express editions and install the official Visual Studio Pro.

No change. Still the same behaviour. I'm now guessing that it's something inside the .Net registry values, and that I wont solve the problem unless I uninstall dotnet (if it's possible) and reinstall it.
Any suggestions?

Are you using a non-English version of Windows and/or non-English Visual Studio?  I'd love to track this bug down!!

Robert

 

Yes, Robert. It's Win XP SP2 italian, plus Visual Studio 2005 pro Italian.
The same happened with the express versions.

I was trying to track the problem down looking at the code, but I think it's impossible to load the "Designer" solution. I got an error by visual studio, with a message regarding the problem of importing the project c:\Program Files (x86)\Visual Studio 2005 SDK\2006.08\VisualStudioIntegration\Tools\Build\Microsoft.VsSDK.targets
(not found).

Do I have to install some SDK of visual studio?



By the way, examining the code, in "SR.Designer.cs" I found the part ....

 public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value)
    {
      if (provider == null || context == null) return value;
      if (context.Instance == null) return value;

      try
      {
        context.On
....

   context.OnComponentChanged();
      }
      catch
      {
      }

If I'm right it's the place where the error is internally trapped without any message. I intended to comment the "try catch" and see what happens ... but I'm unable do load the solution properly as I said before.
What can I do?
Can I load manually the files?
Could you please add a message so that the internal error is displayed?

For your information, even in the express versions some older "designer" was working.
For some times I managed to work with an updated System.Data.SQLite and the designer
version 1.0.26 (if I remember well).
Not completely working, but it was possible to create a connection.....
---------------------------------

Another issue:

is it normal that examining the GAC (from the control panel) I get System.Data.SQLite with version 1.0.34 and SQlite.Designer with version 1.0.31? Isn't the designer a little lagging?
Bye.

I can give you a debug version of the designer, or you can sign up to get the Visual Studio SDK at:

http://www.vsipmembers.com

Then download the August Visual Studio SDK, install it -- then change that line in the SQLite.Designer.vcproj from:

c:\Program Files (x86)\Visual Studio 2005 SDK\2006.08\VisualStudioIntegration\Tools\Build\Microsoft.VsSDK.targets

to

c:\Program Files\Visual Studio 2005 SDK\2006.08\VisualStudioIntegration\Tools\Build\Microsoft.VsSDK.targets

 

The Program Files (x86) only appears on 64-bit Windows (which is what I use to develop on).

Robert

 

Thank your Robert, I'll try to register and download, but if you can give me a debug version ... it will be
quicker. I'll try it and report to you what happens or the messages I get.
Bye. Daniele.

I'm sorry Robert, but the August SDK is gone, the September one is yet to come, and the April one ... just gives me 100+ errors (uint) when compiling ... can you send me the debug version of the designer library? Just mail it to dzingoni@email.it.
Thank you very much ....

Here's some more interesting information.
At least in my case the problem is not about the database selection itself, but about ANY action made on the window that appears in order to add the connection.
If you click on browse or new and select a db name (or existing one) the window closes without errors, as reported by others, BUT THE SAME HAPPENS EVEN IF you click on other items ...

Imagine you want to add a connection and after the window opens you just switch the selection from UTF-8 to UTF-16 ... a click on UTF-16 and the window closes in  the same way, with no error message, before entering any database name.
The same applies for the other options ... so the problem seems to be in the management of the window (that, from the source code, looks instantiated and managed by code).
Is there something connected to locales in this management routine?
The fact is that I've seen other Italian computers working correctly, while my pc don't work as described. I've tried to reinstall and fix almost everything with no success ....

There must be something wrong with locales ... or .Net versions ... but I don't understand what.

Another strange behaviour that I've seen regarding SQLite dbs is related to the editing of databases ... Up to now I used an ODBC driver as a workaround on the designer problem, but now .. even the ODBC works partially :  I can connect the db, I see the "tables" tab in the window ... but when I click on "tables" it does not open: no way to list the tables ..
Yet the same was working till 1.0.33 .... I'm really loosing my mind !

I am downloading the Italian MUI (Multi-User Interface) pack and will install the Italian C# Express Edition and see what happens.

In the meantime, I'll e-mail you a debug version of the SQLite designer.  When you get it, you'll have to re-run the install.exe program so that the debug version is installed to the GAC.

Robert