Testing SQLiteTests test2, Test4: Could not load file or assembly 'Community.CsharpSqlite.SQLiteClient, Version=3.7.7.1, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.

[GoogleCodeExporter]

What steps will reproduce the problem?
1. edit SQLiteClientTestDriver.cs and set Test2 (creation of database and 
table, populate tables)
2.
3. launch the app

What is the expected output? 
a few lines with column contents displayed on the DOS command window
What do you see instead?

Could not load file or assembly 'Community.CsharpSqlite.SQLiteClient, 
Version=3.7.7.1, Culture=neutral, PublicKeyToken=null' or one of its 
dependencies. An attempt was made to load a program with an incorrect format.

What version of the product are you using?

3_7_71

On what operating system?
Windows 7

Please provide any additional information below.

Worked fine until march version 3_7_5_30, no longer can execute Test2, etc 
hereafter

TIA

Gerard

Original issue reported on code.google.com by agl...@yahoo.com on 4 Dec 2011 at 7:42

[GoogleCodeExporter]

This error indicates is an incompatibility between the 32 and 64 bit 
applications.  

Confirm that all of the included projects are built for the same systems.  

Original comment by noah.hart@gmail.com on 4 Dec 2011 at 11:11

• Changed state: Reviewed

[GoogleCodeExporter]

Thanks,
�

�
I sort of gathered, but set all projects to ALL CPUs and still.
I'll try with settings as x64. And let you know
�
Gerard

Original comment by agl...@yahoo.com on 5 Dec 2011 at 6:22

[GoogleCodeExporter]

Succeeded in compiling/executing x64.
UNC accepts IP addresses and machine@domain�Thought of setting database 
'somewhere' specific such as a share, as in:
using System.Management; ...
�
string dbFilename = @\\myMachine\temp\SqliteTest3.db;
string cs = string.Format("Version=3,uri=file:{0}", dbFilename);
�
1/ if not exists, then create folder (here, 'temp')
2/ create a share on temp
using (ManagementClass o = new ManagementClass("\\\\.\\root\\cimv2",
�"Win32_Share", null))
�{
�string method = "create";
�ManagementBaseObject inputArgs = o.GetMethodParameters(method);
�inputArgs["Name"] = "SharedTemp"; // share as
�inputArgs["Path"] = "c:\\temp"; // directory to share
�inputArgs["Description"] = "this is a share to store our DB";
�inputArgs["Type"] = 0; // 0 = Disk share type
�ManagementBaseObject outParams = o.InvokeMethod(method, inputArgs, null);
�uint rc = (uint)(outParams.Properties["ReturnValue"].Value);
�if(rc != 0)
�Console.WriteLine("Failed {0}", ret);
�}
// adapt of course
Alter permissions / Restrict access to�this folder only to whoever writes to 
the temp folder. As for read, everybody or a selected panel of people.
Then it is possible to place the DB to some URL / server and access from remote 
client
�
dirSecurity.AddAccessRule(new FileSystemAccessRule(User, FileSystemRights.Read, 
AccessControlType.Allow));
�
Gerard
�

Original comment by agl...@yahoo.com on 6 Dec 2011 at 1:03

[GoogleCodeExporter]

Setting everything to x86 seemed to work.  Instructions for doing that in C# 
Express 2008 or 2010 here: 
http://opensebj.blogspot.com/2007/12/64-bit-windows-with-c-express-net-and.html

To setup your application to do this you need to
1 G[o] in to the menu option Tools>Options and the in the dialog box tick the 
box in the bottom right corner to "Show all settings"
2 Once the settings expand go to "Projects and Settings" expand it and click on 
"General"
3 Check the option which is called "Show advanced build configurations", then 
close the dialog box
4 Now if you right click on the solution explorer, chose properties
5 Goto "Configuration Properties", now you should be able to see the platform 
drop down. This will probably have only "Any CPU" selected; if so click on 
"Configuration Manager"
6 Chose the option "New" under the "Active Solution Platform" drop down box
7 Chose the new platform of x86 and copy your settings from "Any CPU"
8 Then just make sure that your projects in your solution refer to x86 as the 
platform rather that "Any CPU"

Original comment by rufw...@gmail.com on 13 Jan 2012 at 2:34

[GoogleCodeExporter]

Hi,
�
I succeeded in running the x64 version. Now, I also used UNC to place database 
on a remote server share. Will post code.
�
Gerard

From: "csharp-sqlite@googlecode.com" <csharp-sqlite@googlecode.com>
To: aglv01@yahoo.com 
Sent: Thursday, January 12, 2012 9:35 PM
Subject: Re: Issue 132 in csharp-sqlite: Testing SQLiteTests test2, Test4: 
Could not load file or assembly 'Community.CsharpSqlite.SQLiteClient, 
Version=3.7.7.1, Culture=neutral, PublicKeyToken=null' or one of its 
dependencies. An attempt was made to load a program with an incorrect format.

Original comment by agl...@yahoo.com on 13 Jan 2012 at 2:18

[GoogleCodeExporter]

Issue 133 has been merged into this issue.

Original comment by noah.hart@gmail.com on 28 Feb 2012 at 1:49

[GoogleCodeExporter]

Original comment by noah.hart@gmail.com on 28 Feb 2012 at 1:50

• Changed state: NoAction