![]() To date the configurations below have been tried on 2 machines. The results seem to indicate it's 64 bit. The installer might have gotten confused somehow because my processor is 64bit capable, but i'm running Windows xp sp 3 32 bit. I would have sworn I installed the x86 version of both versions of Sql CE (3.5/4). Version 2.8Ĭopyright (c) Microsoft Corporation. Okay, tried that and these are my results:Ĭ:\Development\Mvc2MessingAround\Mvc2MessingAround\bin\Lib>corflags System.Data. Suggestions, points, whatever would be highly appreciated. Ideally, I want to setup a private deploy for CE 4.0. I did come across a few mentions of an IBuySpy portal sample app that was supposed to use Sql CE 3.5, but can't actually navigate the msdn download maze to get to it. sdf file to my project, connect to it, and query from it. I really haven't found anything that takes this from the very top for either CE 3.5 or 4.0 and tells me exactly what dll's to add, where to put them, how to reference them, how to add the. I have searched stack overflow, the help docs, books online, and googled. Guys, I really could use some direction here. The curious thing here is when I right click and look at the properties of the referenced SqlServerCE dll, it always says it's version 4.0.0.1. I copy the dlls at the base location (c:\Program Files\Sql Server compact\v3.5), including removing and readding the version of the dll from my project references. I upgrade my local installation of Sql CE 3.5 to sp2. ![]() I figure from here, I'd just try getting Sql CE 3.5 to work. Refer to KB article 974247 for more details. Install the correct version of SQL Server Compact. This yields the error below: Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8402. Next, I just try making a basic connection to my sdf file via: SqlCeConnection conn = new SqlCeConnection("DataSource=rpg.sdf") It's worth mentioning that, from inside VS 2008, this file never appears in my project, but it does exist in the physical location of the App_Data directory. I create a few tables, add a few rows to those tables, copy the *.sdf file to my App_Data directory. An important note is that I did not see an option for creating a CE 4.0 version of this file, so it was created using CE 3.5. I created an sdf file via Sql Studio Express. I then reference the dll and set 'Copy Local' to True. I've set the copy to output direction option to 'Copy if Newer'. So, I've copied all the dll's that install in the base 4.0 direction (c:\Program Files\Sql Server compact\v4.0) to a lib folder in my application. I don't plan to host a market or anything with this. This is really just me shooting the breeze and trying to figure this out. My goal is a private install so I can just include it in my web app without having to do sql server setup on my domain hosting. I can find next to no instruction on how to set this up or a working example application. ![]() I'm probably missing something very obvious here, but I've been trying to get the CTP for Sql Server compact 4 to work in my asp.net mvc application. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |