Please Help: SSCE RDA error 29004


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Please Help: SSCE RDA error 29004

  1. #1
    Junges Guest

    Please Help: SSCE RDA error 29004


    I want to use RDA to pull tables from SQL Server into PDA, wenn i call the
    pull method then the following errors are reported:
    ------------- ------------- -------------
    Error retrieved from ISSCERDA->get_ErrorRecords
    -------------
    Description:'The OLEDB provider for SQL Server CE cannot be initialized.[,,,,,]'

    Number: 80040154
    NATIVE_ERROR: 29004
    SOURCE: 'Microsoft SQL Server 2000 Windows CE Edition'
    P0: 0
    P1: 0
    P2: 0
    P3: ''
    P4: ''
    P5: ''
    ------------- ------------- -------------
    Error reported on http://SERVER/.../sscerepl.log file
    -------------
    2003/03/04 08:48:50 Hr=00000000 Count of active RSCBs = 0
    2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 RDA processing
    entered 0
    2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 RDA responding
    0
    2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 C:\Arquivos
    de programas\Microsoft SQL Server CE 2.0\Server\A27CF500-39D5-11C1-8000-DD2306CBB08F
    0
    2003/03/04 08:48:50 Thread=124 RSCB=4 Command=SCHK Hr=80040154 SyncCheck
    responding 0
    2003/03/04 08:48:50 Thread=124 RSCB=4 Command=SCHK Hr=00000000 Removing this
    RSCB 0
    ------------- ------------- -------------
    The source
    -------------
    ISSCERDA* ERDA;
    WCHAR wszConnectString[512]; // Persists the RDAConnectionString
    WCHAR wszLocalTable[255]; // Persists the RDALocalTable
    WCHAR wszErrorTable[255]; // Persists the RDAErrorTable
    WCHAR wszQuery[1024]; // Persists the RDAQuery
    HRESULT hr = CoCreateInstance(CLSID_RemoteDataAccess, NULL, CLSCTX_INPROC_SERVER,
    IID_ISSCERDA, (LPVOID *)&CERDA);
    hr = CERDA->put_InternetURL(L"http://SERVER/virtual path/sscesa20.dll");

    hr = CERDA->put_InternetLogin(L"name1");
    hr = CERDA->put_InternetPassword(L"pwd1");
    hr = CERDA->put_LocalConnectionString(L"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
    Source=\\rep.sdf");
    wcscpy(wszConnectString, L"Provider=sqloledb;Initial Catalog=myDB;Data Source=SERVER;UID=name2;password=pwd2");

    wcscpy(wszErrorTable, L"ErrorTable");
    wcscpy(wszQuery, L"Select id,name,description from remoteTable");
    wcscpy(wszLocalTable, L"localTable"); //this table is not yet present
    hr = CERDA->Pull(
    wszLocalTable,
    wszQuery,
    wszConnectString,
    TRACKINGOFF,
    wszErrorTable
    );
    if(FAILED(hr)) ShowErrors( CERDA );
    CERDA->Release();
    ------------- ------------- -------------
    Enviroment:
    -------------
    - PocketPC2002
    - ActiveSynch 3.6
    - eVC++
    - SQL Server 2000, SP3
    - Microsoft SQL Server CE 2.0
    - Basic authentication on IIS
    - the user name2 is only present on SQLServer and with permition for the
    specified Database (public,db_owner).
    thanks in advance
    junges



  2. #2
    junges Guest

    Re: Please Help: SSCE RDA error 29004


    I have solved this problem, am very gladly therefore

    how i solved?
    after 3 hard days i found on the server the dll registry of sqloledb.dll
    was wrong. I repair the registration an now works fine. Our System administrator
    has installed the IIS under his own account it has caused that the registration
    of the DLL was set on its home directory, but everything is again good :-)

    Junges






    "Junges" <daniel_junges@hotmail.com> wrote:
    >
    >I want to use RDA to pull tables from SQL Server into PDA, wenn i call the
    >pull method then the following errors are reported:
    >------------- ------------- -------------
    >Error retrieved from ISSCERDA->get_ErrorRecords
    >-------------
    >Description:'The OLEDB provider for SQL Server CE cannot be initialized.[,,,,,]'
    >
    >Number: 80040154
    >NATIVE_ERROR: 29004
    >SOURCE: 'Microsoft SQL Server 2000 Windows CE Edition'
    >P0: 0
    >P1: 0
    >P2: 0
    >P3: ''
    >P4: ''
    >P5: ''
    >------------- ------------- -------------
    >Error reported on http://SERVER/.../sscerepl.log file
    >-------------
    >2003/03/04 08:48:50 Hr=00000000 Count of active RSCBs = 0
    >2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 RDA processing
    >entered 0
    >2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 RDA responding
    >0
    >2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 C:\Arquivos
    >de programas\Microsoft SQL Server CE 2.0\Server\A27CF500-39D5-11C1-8000-DD2306CBB08F
    >0
    >2003/03/04 08:48:50 Thread=124 RSCB=4 Command=SCHK Hr=80040154 SyncCheck
    >responding 0
    >2003/03/04 08:48:50 Thread=124 RSCB=4 Command=SCHK Hr=00000000 Removing

    this
    >RSCB 0
    >------------- ------------- -------------
    >The source
    >-------------
    >ISSCERDA* ERDA;
    >WCHAR wszConnectString[512]; // Persists the RDAConnectionString
    >WCHAR wszLocalTable[255]; // Persists the RDALocalTable
    >WCHAR wszErrorTable[255]; // Persists the RDAErrorTable
    >WCHAR wszQuery[1024]; // Persists the RDAQuery
    >HRESULT hr = CoCreateInstance(CLSID_RemoteDataAccess, NULL, CLSCTX_INPROC_SERVER,
    >IID_ISSCERDA, (LPVOID *)&CERDA);
    >hr = CERDA->put_InternetURL(L"http://SERVER/virtual path/sscesa20.dll");
    >
    >hr = CERDA->put_InternetLogin(L"name1");
    >hr = CERDA->put_InternetPassword(L"pwd1");
    >hr = CERDA->put_LocalConnectionString(L"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
    >Source=\\rep.sdf");
    >wcscpy(wszConnectString, L"Provider=sqloledb;Initial Catalog=myDB;Data Source=SERVER;UID=name2;password=pwd2");
    >
    >wcscpy(wszErrorTable, L"ErrorTable");
    >wcscpy(wszQuery, L"Select id,name,description from remoteTable");
    >wcscpy(wszLocalTable, L"localTable"); //this table is not yet present
    >hr = CERDA->Pull(
    >wszLocalTable,
    >wszQuery,
    >wszConnectString,
    >TRACKINGOFF,
    >wszErrorTable
    >);
    >if(FAILED(hr)) ShowErrors( CERDA );
    >CERDA->Release();
    >------------- ------------- -------------
    >Enviroment:
    >-------------
    >- PocketPC2002
    >- ActiveSynch 3.6
    >- eVC++
    >- SQL Server 2000, SP3
    >- Microsoft SQL Server CE 2.0
    >- Basic authentication on IIS
    >- the user name2 is only present on SQLServer and with permition for the
    >specified Database (public,db_owner).
    >thanks in advance
    >junges
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center