Re: [sqlite] sqlite data source not available

[cc]

I wish to add a confirmation to this.

SQLite installation for 1.0.94.0 did not add the option for
System.Data.Sqlite Database File to "Choose Data Source" dialog when adding
ADO.NET Entity Data Model to my application.

Using:
 ~ Visual Studio 2010
 ~ VB.NET WinForms Application @ .NET 4.0
 ~ Windows 7, x64

Version 1.0.93.0 installed (via download, not NuGet) *did* make this
possible.
In my case, it was not necessary to modify the app.config document.


Version 1.0.93.0 can be downloaded here:
http://system.data.sqlite.org/downloads/1.0.93.0/sqlite-netFx40-setup-bundle-x86-2010-1.0.93.0.exe
 ~ and here ~
http://system.data.sqlite.org/downloads/1.0.93.0/sqlite-netFx40-setup-bundle-x64-2010-1.0.93.0.exe





Thanks Joe and Kevin,

I missed changing the folder version #. After doing so was able to download
.93 and it works!




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p79925.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite data source not available

[coffeenkfc]

Thanks Joe and Kevin,

I missed changing the folder version #. After doing so was able to download .93 
and it works!

From: Joe Mistachkin-3 [via SQLite] 
[mailto:ml-node+s1065341n7860...@n5.nabble.com]
Sent: October 14, 2014 10:37 AM
To: Ben Lam
Subject: Re: sqlite data source not available


coffeenkfc wrote:
>
> I removed the line, cleaned the solution, rebuilt, and still don't see
> 'System.Data.Sqlite Database File' in the 'Choose Data Source' window. :(
>

Which setup package did you install?  Were there any error messages?

Could you provide more details about the target system and the log files
from
the installation, etc?

The log files should be located in the %TEMP% directory on the target
machine.
They will have names similar to "Setup Log 2014-10-14 #001.txt" and
"Installer.exe.trace.tmp29.log".

Any other additional information you could provide would be useful as well.

>
> Is there a way to get older versions of the setup bundle? Some time ago on
a
> different machine I was able install 1.0.93.0. I wonder if this is
something
> related to 1.0.94.0.
>

Yes.  As Kevin Benson pointed out, you can simply replace the version
numbers
(*BOTH* of them) in the URI and get it from there.

For example:


https://system.data.sqlite.org/downloads/1.0.94.0/sqlite-netFx45-setup-bundl
e-x86-2012-1.0.94.0.exe

Would become:


https://system.data.sqlite.org/downloads/1.0.93.0/sqlite-netFx45-setup-bundl
e-x86-2012-1.0.93.0.exe

--
Joe Mistachkin

___
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


If you reply to this email, your message will be added to the discussion below:
http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p78605.html
To unsubscribe from sqlite data source not available, click 
here<http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code=78521=YmVuLmxhbUBvY3IuY2F8Nzg1MjF8MTI2OTczMzgyNw==>.
NAML<http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer=instant_html%21nabble%3Aemail.naml=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>


I am using the Free version of SPAMfighter<http://www.spamfighter.com/len>.
SPAMfighter has removed 745 of my spam emails to date.

Do you have a slow PC?<http://www.spamfighter.com/SLOW-PCfighter?cid=sigen> Try 
a free scan!




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p78606.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite data source not available

[Joe Mistachkin]

coffeenkfc wrote:
> 
> I removed the line, cleaned the solution, rebuilt, and still don't see
> 'System.Data.Sqlite Database File' in the 'Choose Data Source' window. :( 
> 

Which setup package did you install?  Were there any error messages?

Could you provide more details about the target system and the log files
from
the installation, etc?

The log files should be located in the %TEMP% directory on the target
machine.
They will have names similar to "Setup Log 2014-10-14 #001.txt" and
"Installer.exe.trace.tmp29.log".

Any other additional information you could provide would be useful as well.

> 
> Is there a way to get older versions of the setup bundle? Some time ago on
a
> different machine I was able install 1.0.93.0. I wonder if this is
something
> related to 1.0.94.0.
> 

Yes.  As Kevin Benson pointed out, you can simply replace the version
numbers
(*BOTH* of them) in the URI and get it from there.

For example:


https://system.data.sqlite.org/downloads/1.0.94.0/sqlite-netFx45-setup-bundl
e-x86-2012-1.0.94.0.exe

Would become:


https://system.data.sqlite.org/downloads/1.0.93.0/sqlite-netFx45-setup-bundl
e-x86-2012-1.0.93.0.exe

--
Joe Mistachkin

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

Re: [sqlite] sqlite data source not available

[coffeenkfc]

Thanks Kevin,

That’s a good idea; I tried and after the countdown to download I get ‘The 
document you are looking for could not be located.’

Curses if only I didn’t delete the .93 install, even tried to recover the 
deleted file. I don’t know if it’s a .94 issue but would have liked to give it 
a try.

From: Kevin Benson [via SQLite] [mailto:ml-node+s1065341n78603...@n5.nabble.com]
Sent: October 14, 2014 10:20 AM
To: Ben Lam
Subject: Re: sqlite data source not available

On Tue, Oct 14, 2014 at 11:47 AM, coffeenkfc <[hidden 
email]> wrote:

> Thanks Joe,
>
> I removed the line, cleaned the solution, rebuilt, and still don't see
> 'System.Data.Sqlite Database File' in the 'Choose Data Source' window. :(


> Is there a way to get older versions of the setup bundle? Some time ago on
> a
> different machine I was able install 1.0.93.0. I wonder if this is
> something
> related to 1.0.94.0.
>

I just tried substituting the string 1.0.93.0 in place of 1.0.94.0 in the
download link URLs (both places) and got offered a download. Maybe that'll
do ya, until Joe Mistachkin (the maintainer) sees this and can respond.


--
   --
  --
 --Ô¿Ô--
K e V i N


>
>
>
> --
> View this message in context:
> http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p78601.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
___
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


If you reply to this email, your message will be added to the discussion below:
http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p78603.html
To unsubscribe from sqlite data source not available, click 
here<http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code=78521=YmVuLmxhbUBvY3IuY2F8Nzg1MjF8MTI2OTczMzgyNw==>.
NAML<http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer=instant_html%21nabble%3Aemail.naml=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>


I am using the Free version of SPAMfighter<http://www.spamfighter.com/len>.
SPAMfighter has removed 744 of my spam emails to date.

Do you have a slow PC?<http://www.spamfighter.com/SLOW-PCfighter?cid=sigen> Try 
a free scan!




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p78604.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite data source not available

[Kevin Benson]

On Tue, Oct 14, 2014 at 11:47 AM, coffeenkfc <ben@ocr.ca> wrote:

> Thanks Joe,
>
> I removed the line, cleaned the solution, rebuilt, and still don't see
> 'System.Data.Sqlite Database File' in the 'Choose Data Source' window. :(


> Is there a way to get older versions of the setup bundle? Some time ago on
> a
> different machine I was able install 1.0.93.0. I wonder if this is
> something
> related to 1.0.94.0.
>

I just tried substituting the string 1.0.93.0 in place of 1.0.94.0 in the
download link URLs (both places) and got offered a download. Maybe that'll
do ya, until Joe Mistachkin (the maintainer) sees this and can respond.


--
   --
  --
 --Ô¿Ô--
K e V i N


>
>
>
> --
> View this message in context:
> http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p78601.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite data source not available

[coffeenkfc]

Thanks Joe,

I removed the line, cleaned the solution, rebuilt, and still don't see
'System.Data.Sqlite Database File' in the 'Choose Data Source' window. :(

Is there a way to get older versions of the setup bundle? Some time ago on a
different machine I was able install 1.0.93.0. I wonder if this is something
related to 1.0.94.0.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-tp78521p78601.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite data source not available

[Kevin Benson]

On Fri, Oct 10, 2014 at 11:55 AM, Ben Lam <ben@ocr.ca> wrote:

> Hi,
>
> Really appreciate any help, spent a day and a half trying to figure this
> out without success. I can't get 'System.Data.SQLite Database File' to show
> up as an option I the 'choose data source' window.
>
> My environment: VS2010 SP1, WIN 8.1 PRO
>
> 1. Installed sqlite-netFx40-setup-bundle-x86-2010-1.0.94.0.exe, ran as
> Administrator, checkmarked 'Install the designer components for Visual
> Studio 2010', avast! antivirus disabled
> 2. Created new WPF project
> 3. Used Nuget package manager console: Install-Package System.Data.SQLite
> 4. Right click on project, Add -> Data -> ADO.NET <http://ado.net/>
> Entity Data Model; Generate from database; New Connection, in the 'Choose
> Data Source' window I don't see 'System.Data.Sqlite Database File' as
> expected
>
> Snippet from app.config:
>
> < DbProviderFactories>
>description=".NET Framework Data Provider for SQLite"
> type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
>   
>   
>invariant="System.Data.SQLite.EF6" description=".NET Framework Data
> Provider for SQLite (Entity Framework 6)"
> type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6"
> />
> 
>   
>   
>  type="System.Data.Entity.Infrastructure.SqlConnectionFactory,
> EntityFramework" />
> 
>type="System.Data.Entity.SqlServer.SqlProviderServices,
> EntityFramework.SqlServer" />
>type="System.Data.SQLite.EF6.SQLiteProviderServices,
> System.Data.SQLite.EF6" />
> 
>   
>
>
>

Did you already do as Joe asked ?

http://sqlite.1065341.n5.nabble.com/sqlite-data-source-not-available-td78521.html

--
   --
  --
 --Ô¿Ô--
K e V i N
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite data source not available

[Ben Lam]

Hi,

Really appreciate any help, spent a day and a half trying to figure this out 
without success. I can't get 'System.Data.SQLite Database File' to show up as 
an option I the 'choose data source' window.

My environment: VS2010 SP1, WIN 8.1 PRO

1. Installed sqlite-netFx40-setup-bundle-x86-2010-1.0.94.0.exe, ran as 
Administrator, checkmarked 'Install the designer components for Visual Studio 
2010', avast! antivirus disabled
2. Created new WPF project
3. Used Nuget package manager console: Install-Package System.Data.SQLite
4. Right click on project, Add -> Data -> ADO.NET Entity Data Model; Generate 
from database; New Connection, in the 'Choose Data Source' window I don't see 
'System.Data.Sqlite Database File' as expected

Snippet from app.config:


  
  
  
  

  
  


  
  

  



I am using the Free version of SPAMfighter.
SPAMfighter has removed 689 of my spam emails to date.

Do you have a slow PC? Try 
a free scan!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite data source not available

[Joe Mistachkin]

Ben Lam wrote:
>
> 4. Right click on project, Add -> Data -> ADO.NET Entity Data Model;
Generate
> from database; New Connection, in the 'Choose Data Source' window I don't
see
> 'System.Data.Sqlite Database File' as expected
> 

Could you try removing the following line from the configuration file?

 

--
Joe Mistachkin

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

[sqlite] sqlite data source not available

[Ben Lam]

Hi,

Really appreciate any help, spent a day and a half trying to figure this out 
without success. I can't get 'System.Data.SQLite Database File' to show up as 
an option I the 'choose data source' window.

My environment: VS2010 SP1, WIN 8.1 PRO

1. Installed sqlite-netFx40-setup-bundle-x86-2010-1.0.94.0.exe, ran as 
Administrator, checkmarked 'Install the designer components for Visual Studio 
2010', avast! antivirus disabled
2. Created new WPF project
3. Used Nuget package manager console: Install-Package System.Data.SQLite
4. Right click on project, Add -> Data -> ADO.NET Entity Data Model; Generate 
from database; New Connection, in the 'Choose Data Source' window I don't see 
'System.Data.Sqlite Database File' as expected

Snippet from app.config:


  
  
  
  

  
  


  
  

  


I am using the Free version of SPAMfighter.
SPAMfighter has removed 674 of my spam emails to date.

Do you have a slow PC? Try 
a free scan!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users