index > SQL Server Everywhere Edition > possible to connect to SQL Server Mobile database

possible to connect to SQL Server Mobile database

Is it possible to have a Windows applications (based on .NET Framework 2.0) connect to a SQL Server Mobile database?

I manually added the the System.Data.SqlServerCe.dll (retrieved from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll) to my Windows Form project. When I start the app, it gives me an error message:

{"Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)":"System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"}

TIA

Stormin

K. I got this to work.

My problem was that I did not reference the dll from the correct location. The correct location of the SqlServerCe dll to reference is "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\System.Data.SqlServerCe.dll"

Stormin
reply 2

You can use google to search for other answers

 

More Articles

• Error in Synchronizing Data
• Walkthrough Failure: "Creating a Mobile Application w/SQL Se...
• SQL Server Mobile Bug?
• How to open sdf file(2.0) with sql server 2005 standard edition?
• Add connction Fails in VS.NET with SQL Server Everywhere
• Using the same connection in multiple threads -> native except...
• SQL Everywhere - Can't connect from VS.NET after create DB w/ Mgm...
• SQL Server Mobile Merge Replication walkthrough, cant find the .N...
• RDA pull - from a temporary table
• Background replication
Bookmark and Share
Welcome to Bokebb   New Update  
 

New Articles

• sqlserver express and tablet pc
• Sync sql server 2005 mobile edition with
• genral network error on .net framework 1
• Replication Error 28559
• Parameterized queries with RDA
• Transform??sql server mobile edition dat
• SQL Everywhere - Can't connect from VS.N
• Making small database on iPaq
• Recover SDF-File
• SQL Mobile Server Tools install on SQL 2
• Error when "SELECT" statement
• Cannot save English dates!
• VB 6.0 with SQL Everywhere ??
• RDA Push Command Failing ...
• 0x80040e21 error running SQLCE 2.0 on Wi

Hot Articles

• Debuggin on PDA
• Unsupported HTTP function call was made
• Beginner Q: Pocket PC access to SQL Serv
• Where is DataDirectory ?
• Relationship diagrams in SQL mobile 2k5
• Copy SQL Server 2005 DB to SQL Server Mo
• rda.push error
• SDF Creation on Desktop
• Sql Server 2005 Mobile/RDA connection pr
• Open SqlCeConnection from an ASP.NET Web
• Header Corruption Error
• DateTime.Min won't insert into SQL Serve
• File Size Limit
• Export to SQL Server Everywhere Database
• RAPI fails on CeMountDBVol (WinMobile 5)

Recommend Articles

• RDA pull - from a temporary table
• Help setting up replication on remote IIS
• An error has occurred on the computer ru
• Working with data in a mobile solution
• installing sql server mobile in an hp ip
• EDB record limits and EDB vs RAPI
• Compact Sql Mobile 3.0 DataBase in C++/O
• Recover SDF-File
• Setting Security on DB
• how do I use the crosstab query in sql s
• SQL 2005 Mobile loading 2003 Cabs
• SQL Server 2005 Mobile: problem with con
• Cannot save English dates!
• sql server2005 and sql mobile DB (.sdf)
• unable to connect to sql server from han