problem with SqlCeRemoteDataAccess - pull

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

 

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.

 

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.

 

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

 

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

 

Lonifasiko napsal(a):

And I get this result - SqlCeException, HRESULT : 0x80004005, Native
error : 28022. I have bad IP address...

 

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 napsal(a):

I specifyed ip address. Pocket IE still show "The page cannot be displayed".

Petr

 

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 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

 

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 napsal(a):

I run regsvr32.exe sscesa20.dll. Problem still exist ...

Petr

 

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 napsal(a):

This is my solutions -

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

Petr