Problem connecting to SQLite on x64

[jespera]

I have the following code in a .fs file:

let con = @"Data Source=some-path-to\test.db; Version=3"
let res = @"C:\another-path-to-x64ver\contrib\sqlite\lib\net45"

type sql = SqlDataProvider<ConnectionString = con,
                                   DatabaseVendor = Common.DatabaseProviderTypes.SQLITE, 
                                   ResolutionPath = res,
                                   UseOptionTypes = true>

The error I get in Visual Studio 2012 is :

The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not load file or assembly 'file:...contrib\System.Data.SQLite.x64.1.0.89.0\lib\net45\System.Data.SQLite.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format.

After a bit of searching around I saw this: http://pinksquirrellabs.com/post/2013/12/15/SqlProvider-SQLite-support-%28experimental%29.aspx

I have applied the suggested loadFromRemoteSources but that did not help. What does help though is to point to a x86-sqlite dll.

Is it (should it be) possible to use the SqlProvider on a x64-platform?

[pezipink]

I had this problem as well initially when I wrote the SQLite stuff. I have only ever used a 64bit machine with it, but it only worked with the x86 sqlite assemblies .. as this was not a problem for me, I have yet to look into it further. I will add it as an issue.

Is all well when using the x86 flavour of the sqlite assemblies?

[jespera]

All is well when using the x86 assemblies. It just seems strange that the x64 does not work.

Is there anything I can do to help?

[pezipink]

Yes you could work out what the problem is and fix it if you feel that way inclined :)

Other than that, not really as I have not investigated this at all yet so presently have no leads to follow up on. I have an outside feeling it might be to do with the IDE itself but that is purely conjecture at this point.

I will try and investigate it soon.

[jespera]

Yeah. It really does seem to be related to VS being a 32bit application and then not being able to use 64bit dlls (the sqlite one in this case).

[pezipink]

wow, what a guess!