locked
SQL CE access while Sync in progress - WinXP problems RRS feed

  • Question

  • I am running syncs  (SQL CE->SQL Server) on individual tables in a database (C# code). These syncs are running in background threads, no problems. I am also inserting rows into various tables that are being sync'd (c++ code using ADO (COM) ), and it works as well, on Win7.

    When I run the same applications on WinXP, I cannot get an ADO connection (c++) on a SQL CE Database that is being sync'd. I keep getting a DB_E_ERRORSOCCURRED (0x80040e21) when I try a connection via ADO.

    pConn->Open((_bstr_t)(dbCook.sConnectString),"","",adConnectUnspecified);
    ConnectString format is :

    "PROVIDER=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\\NES JOB DATA\\%s\\%s.sdf"


    Any ideas?

    Thursday, December 13, 2012 6:04 PM