CODEWITHSUNDEEP
.netasp.netsqlite64-bit
Jeffrey Cameron
Jeffrey Cameron

Reputation: 10285

.NET 32-bit dev vs. 64-bit prod

This question is kind of related to another question but I have a specific scenario in mind.

We do our development on 32-bit machines and deploy to a 64-bit server. The application is an ASP.NET Web Application and we use SQLite for the backend of this application. When I try to build on the remote machine I get errors from MSBuild saying it cannot find the DLL.

The web application needs to be able to launch 64-bit processes (because these processes need lots and lots of memory!)

I have seen solutions where you simply put IIS into 32-bit mode and run everything in 32-bit mode to be able to use SQLite, but does this screw me out of being able to launch a 64-bit process??

Help!!

Upvotes: 0

Views: 628

Answers (2)

Joel Coehoorn
Joel Coehoorn

Reputation: 415881

Yes, if you put IIS in 32bit mode you won't get 64bit processes. If you want the database to run in-process with your app, you'll need to choose a database with a 64bit provider - perhaps sql server compact edition.

Alternatively, considering your purported RAM needs it sounds like maybe what you should really do is move to a full out-of-process server-class database engine like SQL Server Express or Standard.

Upvotes: 3

Nick Berardi
Nick Berardi

Reputation: 54854

Have you tried the managed version of SQLite built in .NET? That may solve your problems.

http://code.google.com/p/csharp-sqlite/

Nick

Upvotes: 1

Related Questions