Unable to connect to Sql Server Compact Edition Database

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



I'm using VS 2005 and ActiveSync 4.5.

Using the Server Explorer in VS 2005, I get the following error when I
try to add a connection to a sql server compact edition database that
resides on a CE device:

"Unable to connect or authenticate Sql Server Compact Edition
connection through Microsoft Activesync. Make sure the device is
properly connected to this computer."

If I copy the same database to my development PC, I'm able to add the
connection and open the database.

Any help would be much appreciated.
.



Relevant Pages

  • Problems with ActiveSync TCP/IP Transport.
    ... I am using ActiveSync and mEnable to connect to my server ... can establish a database connection to the database in the Network Server ...
    (microsoft.public.windowsce.embedded.vb)
  • Re: Unable to connect to Sql Server Compact Edition Database
    ... It sounds to me like the connection may be timing out across the Activesync link, but I don't believe you could change the default connect timeout in VS 2005. ... Did you use the server tools in VS 2005 to browse to the database on the ... > "Unable to connect or authenticate Sql Server Compact Edition ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server Compact 3.5
    ... However i'm getting a error on opening the connection: 'Provider could not set DATASOURCE, USERID, or PASSWORD' ... i need to create a Application on Windows Mobile running SQL Server Compact Edition. ... Iis there a way to connect from a Delphi application to SQL Server Compact 3.5 Edition? ...
    (borland.public.delphi.database.ado)
  • Re: Problem to connect wiht database server
    ... Assuming you're using SQL Server Compact Edition, only one connection at a ... time is permitted to a database located on a network share. ... Ginny Caughey ...
    (microsoft.public.sqlserver.ce)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)