System.Data.SQLite.dll cannot be loaded on the blade servers

[swagner]

When trying to load System.Data.SQLite.dll on the blade servers, a BadImageFormatException is thrown.

[gkronber]

The most likely reason for this is that the SQLite assembly is 32bit only so it can't be loaded in a 64bit environment.

[swagner]

Any ideas how we can fix this? Is there a 64bit version of System.Data.SQLite somewhere? Perhaps we can use the native DLLs and some other ADO.NET provider instead of the combined mixed mode assembly? Some open sources solution would be nice ...

[gkronber]

Replying to swagner:

Any ideas how we can fix this?

We just need to deploy the correct version of the assembly.

Is there a 64bit version of System.Data.SQLite somewhere?

Yes both versions are included in the project.

Perhaps we can use the native DLLs and some other ADO.NET provider instead of the combined mixed mode assembly? Some open sources solution would be nice ...

I think using the native DLL would be even more problematic regarding 32bit vs. 64bit environment and also versioning. System.Data.SQLite is open source.

[swagner]

I see, thanks. Ok, then I will tweak the build scripts a bit, so that the correct version is deployed depending on the current configuration.

[swagner]

Milestone 3.2 deleted

[gkronber]

Added conditional deployment of external SQLite assembly in CopyAssemblies.cmd script with r1403.

[gkronber]

Replying to gkronber:

Added conditional deployment of external SQLite assembly in CopyAssemblies.cmd script with r1403.

Solution copied from mkommenda (see Heureka! trac r552).

[gkronber]

xcopy doesn't work.

[gkronber]

Using plain old copy instead with r1464.

[swagner]

Milestone Iteration 2 deleted

[swagner]

Milestone Current deleted