Cannot get SSCE 3.5 beta 2 to work

JonM

I'm running VS2008 beta2. I've succefully added a SDF database file to my project and created a couple of tables in it from VS. I added a reference to the System.Data.SqlCeConnection. When I try to create a new instance of the SqlCeConnection class I get a nasty error that states I'm missing the 'sqlceme35.dll' file. I copy all of the files .dll into by bin folder. Now I'm getting a BadImageFormat error when I create an instance. Does anyone know what that means or why I had to copy those files to begin with This is very odd. Any help would be appreciated. I am new to SqlCe.

mike_lockyer


Hi

I can't help - having the same problem but getting this error

Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

when I try and add

C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\sqlceme35.dll

as a reference then I get another error

---------------------------
Microsoft Visual Studio
---------------------------
A reference to 'C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5\sqlceme35.dll' could not be added. Please make sure that the file is accessible, and that it is a valid assembly or COM component.
---------------------------
OK
---------------------------


Hoping for an answer as well

Mike

JonM

Mike,

I'm starting to think it has something to do with x64. I'm only getting this error Windows Server 2003 x64 and on Vista x64. However, when I install VS2008 on Vista x86, I have not seen the issue (at least not so far). What platform are you running on

Jon

Ilya Tumanov

This DLL is not a COM object or .NET assembly so it can't be added as reference and it should not be. It should be simply located in your %WINDIR%\System32 or in your application folder.

Also make sure to mark your application as x86 (platform target in project properties or you won't be able to use SQL CE in 64 bit OS.

JonM

Arg.. That sucks no SQL CE for 64-bit.. Why does VS install all of the tools and SDKs for SQL CE on 64-bit if you can't use it

Ilya Tumanov

You can - in 32 bit mode. That's the way most applications work on 64 bit OS today.

mike_lockyer

Jon

Looks like it - I am running Vista 64

All seeems fine ov XP 32

Hope there is a work round

Mike

mike_lockyer

Hi Ilya

Thanks - I can get a compile and successfull run once I switch to x86 in Orcas Beta 2

but I still can't run SQLMetal in Vista64 either the 32bit version of sqlmetal

Any advice

Thanks again

Mike

Ilya Tumanov

Go ahead and file a bug here.

J_Steele

I know I'm a bit late to this thread, but being that I had the exact same error messages described by JonM, thought I'd toss in a solution that worked for me (running VS 20008 Orcas Beta2 on Vista Ultimate 64-bit):

Go into your project Properties and under Compile--->Advanced Compile Options change the Target CPU to x86.

Shimi Weitzhandler

I had the same problem,

it really sucks

I think the most practical solution is use the program as x86, as Mr. king kong J_Steele explained in previous post.