System.Data.SQLite

Hi, I have been having a problem with our deployment of SQLite.  We use SQLite as the database for our CMS product which is written with ASP.NET.  Up until now I have put the System.Data.Sqlite.DLL file in the /bin directory and deployed the file with each website.  However, we have several hundred sites running on a single server and now it seems that whenever more than about 120 sites are running the Sqlite assembly is unable to initialize. 

Now I have begun to think that I should deploy a single instance of Sqlite to the web server and have all sites reference it.  Would this mean that I have to register the dll in the GAC?  What is the proper way to do deploy so that all my web sites can use the same assembly?

 Thanks for any help!

 Joshua

Hrm, that's interesting.  What kind of error do you get?  Anything trackable?  Are they all running in the same application pool? If so, what would happen if you split application pools to limit the system to no more than 100 sites per pool? 

The error is "Unable to initialize assembly."  I'll get the specifics and post it back here.  Currently they are all running in the same application pool.  I'll have to give it a try with the different application pools.  It will take me some time though. 

I've tried to add the assembly to the GAC, which I was hoping would be the quick fix, but everytime I drag it in there or use the gacutil -i to install it I get an error "Unkown Error".  Is there something specific that I need to do, or is it even possible to put the assembly in the GAC at the moment? 

Yes, its absolutely possible.  The dll's are strong named and all the visual studio design-time code depends on the INSTALL.EXE being able to register the DLL in the GAC.

When you run GACUTIL, what version does it say it is?

You've obviously got a lot of experience with this.  Sure enough, I was using the wrong version.  So now I have the assembly in the GAC and the webs are using that.  Right now I only have this setup in my test environments which, at the moment, only have 30 or 40 sites.  I'm working on setting up some systems so I can test this problem properly and see if the GAC solution fixes my production problem and so I can give you some more specific information about what happens when there are a lot of webs using separate SQLite on the one server.  I'll post back here my findings.

Thanks so far!  Already a big help. 

Just to wrap this up.  I was never able to reproduce the error on my test environment, so it is possible it is caused with an environmental conflict.  However, putting the assembly in the GAC did solve my problem on the production environment and I was able to verify that very clearly. 

Around 110 active web sites using the DLL caused an "Unable to initialize assembly error".  When I moved the assembly into the GAC, more than 200 sites came up without any problem. 

So for now my problem seems solved, thanks for your help Robert!

Joshua

http://geographicalmedia.org

That's good news, and one for the mental notes :P