Browse by Tags

Foreign Key to attached database doesn't work

I have a database called "resources.db" and another called "auto.db". The connection opens (and creates) auto, then attaches resources. It then creates a table in auto that references a table in resources. However, when I try to insert into the newly created table, I get an error...

Posted to Bugs (Forum) by Erzengel on 12-30-2011
Error of deploy on IIS server

I have build a web site base on ASP.Net MVC 3, Entity framework and sqlite, i scuccessfully deploy the site on my own server(win2003), but when I deploy it to the host I get this error "Could not load file or assembly 'System.Data.SQLite.dll' or one of its dependencies.". I have copy...

Posted to General (Forum) by andylang on 12-22-2011
Re: Data Provider for SQLite ERRORS

After try this step: -Uninstall 1.0.60.0, run devenv.exe /resetuserdata, install 1.0.60.0 and the connection dialog is back to normal... from this link: http://sqlite.phxsoftware.com/forums/p/329/10853.aspx I got this error: "Package Load Failure Package 'SQLite Designer Package' has failed...

Posted to Designer (Forum) by rose on 11-22-2011
Re: "Add Connection" closes w/o error msg

[quote user="jaap34"] Fixed... Uninstall 1.0.60.0, run devenv.exe /resetuserdata, install 1.0.60.0 and the connection dialog is back to normal... [/quote] get this error when started vs2005 after install sqlite ado.net: "Package Load Failure Package 'SQLite Designer Package' has...

Posted to Designer (Forum) by rose on 11-22-2011
How to Add a new Property in a Entity?

How to add a property to an entity that is not mapped to the DB. Ex: The entity Person has 2 properties extrapolated from the structure of the DB. The ID, which is the primary key, and Name. I must add a third property, which will be valued in a second time during program execution. If I add a scalar...

Posted to How To (Forum) by abramo on 10-06-2011
One to many relationship problem

I want to report a problem, which has already found a workaround, which was discussed at the page http://sqlite.phxsoftware.com/forums/t/1460.aspx As you can see from the last post in the forum above the bug is very annoying because it obliges us to make a ToList () the whole table if you want the sub...

Posted to Bugs (Forum) by abramo on 10-06-2011
Datasets with Foreign Keys back to AutoIncrement field no longer working?

I have a dataset with several tables. They all reference back to one row whose key is autoincrement. After creating a new record, everything references an ID of -1, as you would expect from autoincrement. In version 1.0.35.1, when I wrote this dataset out using table adapters using the following SQL...

Posted to Bugs (Forum) by jpwkeeper on 09-23-2011
Re: strange Error : no such table : ....

The same error occurs in the following situation too: You add .db file to your project. Then when you run your c# project with debugger, empty db. file is copied into bin/debug folder of the project folder. Your running application looks for tables in the empty database and returns error: "no such...

Posted to General (Forum) by sevenkul on 08-19-2011
Visual Studo 2010 Professional designer

Hello, someone managed to install sqlite in VS2010 Pro? I managed to install the VS2010 express changing a configuration file , however , I 'm not getting the same result in professional , even changing the file . I'm usion XP 32bits

Posted to General (Forum) by Alberto on 07-21-2011
Move the folder for temp files

When I ran SQLite (.Net) on a big file (2.70 Go), two temporary files are written in C:\Documents and Settings\GRVPRDSVC\Local Settings\Temp\etilqs_*. My free space on this disk is 6.8 Go. After a few minutes, an exception is thrown with this message : Disk full. There is a lot of space on D:\, how can...

Posted to General (Forum) by SQLiteBeginner2 on 07-05-2011

Page 1 of 7 (66 items) 1 2 3 4 5 Next > ... Last »