Connect to SQL Server Mobile Edition via VS2005 (Data Provider)

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi,


I try to connect my application via Data Provider to my SQL Mobile DB.

With the ServerExplorer all works fine.
new Connection - via ActiveSync - Data Provider for SQL Server Mobile
Edition
.... fine !

But now i want to use this in my code.
I have the ConnectionString .. "Data Source = Mobile Device \ .... .sdf"
but how can i change my Data Provider? ('for SQL Server' to 'for for SQL
Server Mobile Edition')

When i use the namespace System.Data.SqlClient the SqlConnection class try
to connect with a "normal" Sql Server 2005 database.


Is there a possibility to fix that problem ?

I only want to use a SqlConnection in my code to connect my application with
the database on my device. (via ActiveSync)


thx a lot
Martin


.



Relevant Pages

  • Re: Why Sql Server Mobiles RDA.Pull error ??
    ... SQL Mobile server tools that support RDA and Merge Replication are ...
    (microsoft.public.sqlserver.ce)
  • Re: Administration with SQL Server 2005 Mobile?
    ... database via SQL and the INFORMATION_SCHEMA views. ... Mobile device is VPN into my network and with a client app on the device, ... connect and administer my SQL Server servers on the network. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Mobile
    ... SQL Server 2005 Mobile Edition would correspond to SQL CE 3.0, ... you can create a SQL Mobile database on the server and transfer it to ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: New to threading
    ... project to CF 2.0 that I will get a newer/better CE Sql engine (Sql ... Mobile) ... Server in near real time. ... In an attempt to solve this problem, I tried starting the data transfer ...
    (microsoft.public.dotnet.framework.compactframework)
  • How to set Merge Repl properties for multiple servers?
    ... Currently we have merge replication set up between SQL 2000 and mobile ... have a backup/redundant/mirrored server at a different geographic ...
    (microsoft.public.sqlserver.replication)