problem with SqlCeRemoteDataAccess - pull

Discussion in 'microsoft.public.sqlserver.ce' started by Petr Svoboda, Sep 28, 2005.

  1. Petr Svoboda

    Petr Svoboda Guest

    Hello !

    I run this code -

    rda = new SqlCeRemoteDataAccess();

    rda.InternetLogin = "svobodap";
    rda.InternetPassword = "fichtelberg";
    rda.InternetUrl = "http://10.0.0.77/mCatering/sscesa20.dll";

    rda.LocalConnectionString
    ="Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
    Source=\\test.sdf;Password=batoh;";

    rda.Pull("table2", "select * from table2", rdaOleDbConnectString,
    RdaTrackOption.TrackingOn, "ErrorTable");

    And I get this result - SqlCeException, HRESULT : 0x80004005, Native
    error : 28022

    Please help me.

    Thanks, Petr
     
    Petr Svoboda, Sep 28, 2005
    #1
    1. Advertisements

  2. Petr Svoboda

    Lonifasiko Guest

    In your LocalConnectionString (connection to SQL Server CE) I've seen
    you've specified Password but not User. In my case I do not use neither
    user nor pass to connect locally; only "Provider" and "Data Source".
    Could be that?

    Anyway, have you caugth the exception and showed the message in a
    messagebox. Sure it gives you some more detailed error message in
    exc.Message.

    Hope it helps.
     
    Lonifasiko, Sep 28, 2005
    #2
    1. Advertisements

  3. Petr Svoboda

    Arun Guest

    Try to open the sscesa20.dll link in Pocket IE, the correct response is
    SQL Server CE Server Agent.
    If you don't get the response and asks you to download the file then,
    on the IIS machine
    open the IIS and right click on the virtual directory go to
    properties page and manually set Execute Permissions to Scripts and
    Executables.

    After this, try in Pocket IE to check for the response.

    Hope this helps,

    Cheers,
    Arun.
     
    Arun, Sep 29, 2005
    #3
  4. Petr Svoboda

    Petr Svoboda Guest

    Lonifasiko napsal(a):
    I disable password in database.
    My connection string now is
    rda.LocalConnectionString =
    "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\\test.sdf;";
    I get error HRESULT=0x80072eff and native error 28037

    Petr
     
    Petr Svoboda, Sep 29, 2005
    #4
  5. Petr Svoboda

    Petr Svoboda Guest

    Arun napsal(a):

    If I open sscesa20.dll link on pocket pc, I get "The page cannot be
    displayed". I have "Execute Permissions Script and Executables".

    Petr
     
    Petr Svoboda, Sep 29, 2005
    #5
  6. Petr Svoboda

    Petr Svoboda Guest

    Lonifasiko napsal(a):
    And I get this result - SqlCeException, HRESULT : 0x80004005, Native
    error : 28022. I have bad IP address...
     
    Petr Svoboda, Sep 29, 2005
    #6
  7. Petr Svoboda

    Arun Guest

    Then you have to set your IIS right.
    How did you create the virtual directory, use SQL Server Connectivity
    Management to create the virtual directory, specify the IP address
    instead of the computer name in the link to the sscesa20.dll and try.
    If you get SQL Server CE Server Agent as the response then only your
    RDA pull will be successful.
    It is nothing to do with the password given in Local Connection string.
    If you have created the sdf file with Password, you have to provide
    that in the Local Connection String.

    Hope this helps,
    Cheers,
    Arun.
     
    Arun, Sep 29, 2005
    #7
  8. Petr Svoboda

    Petr Svoboda Guest

    Arun napsal(a):
    I specifyed ip address. Pocket IE still show "The page cannot be displayed".

    Petr
     
    Petr Svoboda, Sep 29, 2005
    #8
  9. Petr Svoboda

    Arun Guest

    Double check whether your IIS is running and check whether you can
    reach any of the share folders of the machine from PPC.

    Check whether you are trying with the correct IP address and Link,

    Check in your IIS machine Internet Explorer whether you can browse the
    same sscesa20.dll and get the response.

    Check these links too
    http://groups.google.com/group/micr...e+cannot+be+displayed&rnum=2#da8d925f3d07448a

    http://groups.google.com/group/micr...e+cannot+be+displayed&rnum=3#43bbfc3540ad4cd3

    Cheers,
    Arun.
     
    Arun, Sep 29, 2005
    #9
  10. Petr Svoboda

    Petr Svoboda Guest

    Arun napsal(a):
    IIS is runnig, when i type only "http://127.0.0.1/mCatering", directory
    is open.


    When I type "http://127.0.0.1/mCatering/sscesa20.dll" to the PC Internet
    Explorer, i get -

    "
    Server Application Error
    The server has encountered an error while loading an application during
    the processing of your request. Please refer to the event log for more
    detail information. Please contact the server administrator for assistance.
    "

    Petr
     
    Petr Svoboda, Sep 30, 2005
    #10
  11. Petr Svoboda

    Lonifasiko Guest

    I understand sscesa20.dll is physically located in the physical
    directory that IIS virtual directory points to. And I suppose SQL
    Server CE Server Tools have been correctly installed. If yes, have you
    tried registering sscesa20.dll in the physical directory with regsvr32
    from "Start-->Run".

    It seems like the DLL that acts as the SQL Server CE Server Agent is
    not correctly registered on the system.

    Or you have a strange IIS configuration that does not let you see DLL
    files.

    I expect you soon solve all your problems. Good luck!
     
    Lonifasiko, Sep 30, 2005
    #11
  12. Petr Svoboda

    Petr Svoboda Guest

    Lonifasiko napsal(a):
    I run regsvr32.exe sscesa20.dll. Problem still exist ...

    Petr
     
    Petr Svoboda, Sep 30, 2005
    #12
  13. Petr Svoboda

    muddg Guest

    I had the same problems you are having....

    try using err.exe ... a microsoft tool which will give you more information
    about
    the error numbers you are getting.
    you can download it from
    here...http://www.microsoft.com/downloads/...99-7BB8-4208-B7FC-09E02A13696C&displaylang=en
    See the word doc that comes with it for instructions.

    also check that part of the connect string where it reads
    Provider=SQLOLEDB
    I found that I had to change this to Provider=SQLOLEDB.1
     
    muddg, Oct 3, 2005
    #13
  14. Petr Svoboda

    Petr Svoboda Guest

    muddg napsal(a):
    This is my solutions -

    http://robgarrett.com/Blogs/software/archive/2005/04/20/614.aspx

    Petr
     
    Petr Svoboda, Oct 4, 2005
    #14
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.