Here's the result of running gacutil:
Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.1
Copyright (c) Microsoft Corporation. All rights reserved.
The Global Assembly Cache contains the following assemblies:
System.Data.SQLite, Version=1.0.79.0, Culture=neutral,
PublicKeyToken=db937bc2d44ff139,
processorArchitecture=AMD64
Number of items = 1
I ran this after uninstalling and reinstalling to make sure that the
assemblies were installed in the GAC.
I've also changed the code slightly to avoid opening the db in the form
load - but, apart from the form loading, there's no difference. Here's the
revised (and still simple) code:
Imports System.Data.SQLite
Public Class Form1
Private dbConn As SQLiteConnection
Private Sub Button1_Click(sender As System.Object, e As
System.EventArgs) Handles Button1.Click
'configure & open data connection
dbConn = New SQLiteConnection("Data
Source=C:\Users\David\testJnl;Version=3;")
Try
dbConn.Open()
MessageBox.Show("Conn open", "TestLocaldb",
MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MessageBox.Show(ex.ToString())
Finally
If (dbConn.State = ConnectionState.Open) Then
dbConn.Close()
End If
End Try
End Sub
End Class
Out of ideas and moving to MySQL - unless you have any further suggestions.
Thanks for your help, Joe.
David Horne
On 21 February 2012 22:10, Joe Mistachkin <sql...@mistachkin.com> wrote:
>
> David Horne wrote:
> >
> > The only thing I haven't checked is the contents of the GAC for the
> > possible stray that you mention. Can you tell me how to do this?
> >
>
> Open a Visual Studio 2010 Command Prompt and type:
>
> gacutil /l System.Data.SQLite
>
> --
> 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
