Re: [sqlite] help with optimazing sql query

On 1/6/2011 5:54 PM, gasperhafner wrote: > Igor Tandetnik wrote: >> >> On 1/6/2011 5:25 PM, gasperhafner wrote: >>> Igor Tandetnik wrote: select ID_DISH, sum(ID_INGREDIENT not in (2, 4)) stillMissing from x group by ID_DISH having stillMissing != count(*) order by

Re: [sqlite] The underlying provider failed to open?

Did your hostname change? There are some things with VB-anything that will try and open the file on the hostname, regardless if you specifically told it "c:\DatabaseStuff\Databasefile.db3". IIRC, at least with MS-SQL, it may try to open it as "\\hostname\.\c$\DatabaseStuff\Databasefile.db3" or